WebTracker Error - SQL0302N with SQLSTATE=22001

Technote (troubleshooting)


Problem(Abstract)

An error message is found in the sastderr.txt trace file: SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001

Resolving the problem

An error message such as this is found in the sastderr.txt trace file:

[04.05.19 21:29:54:084 CEST] 59ec3b0c com.ibm.sa.admin.accessmgr.ejbs.SiteCollectionBean ERROR [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
This error should not be a concern if it does not appear more than once or twice a day.

This error could be caused by an older version of a browser loading a WebTracker enabled page.

In satrace.txt one will find the value "ULtestundefined" for the flags being tracked.

Example: sawt_project=ULtestundefined

Since only one hit is lost this error may be discovered while looking for other problems. This error may then be thought to be part of the actual problem under investigation. An infrequent occurrence of this error message should not be a problem.

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Web Site Analyzer
WebTracker

Software version:

4.0 or later

Operating system(s):

Platform Independent

Reference #:

1170654

Modified date:

2011-03-30

Translate my page

Machine Translation

Content navigation