The following error is thrown when creating a snapshot: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001
The size of MESSAGE and NLS_MESSAGE columns in the JAC_SYS.VIOLATIONS table is NOT large enough to hold the entire message associated with one of the compliance objects
Resolving the problem
There are 2 ways to resolve this issue.
1. Reduce the size of message associated with each compliance object and ensure that it is not larger than the size of MESSAGE and NLS_MESSAGE columns
2. Increase the size of MESSAGE and NLS_MESSAGE column to a higher value like 1024 as shown below:
alter table jac_sys.violations alter column message set data type varchar(1024)
alter table jac_sys.violations alter column nls_message set data type varchar(1024)
Note: Always maintain the same size for MESSAGE and NLS_MESSAGE columns.
JAC SCM ITSCM