Error when creating snapshot: DB2Exception: SQL0302N

Technote (troubleshooting)


Problem(Abstract)

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

Cause

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.

Product Alias/Synonym

JAC SCM ITSCM

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Security Compliance Manager

Software version:

5.1

Operating system(s):

All Platforms

Reference #:

1229684

Modified date:

2011-01-02

Translate my page

Machine Translation

Content navigation