Return
-
Title
Error: CLI Error (22002,FFFE7961) - [IBM][CLI Driver] CLI0110E Invalid output or indicator buffer -
Description
Getting the error below when running a custom load scenario test against a DB2 database.
Example:
Creating new test as new load scenario | test SQL for Scalability | Add SQL Statement | Generate SQL transaction.
Error :
New Job
Job Started
Started test Custom Scalability Load Scenario
Agent(ISCDS001W003060) Error: CLI Error (22002,FFFE7961) - [IBM][CLI Driver] CLI0110E Invalid output or indicator buffer specified. SQLSTATE=22002 -
Cause
The SQL statement returns Nulls which this causes the problem.
-
Resolution
WORKAROUND 1:
Change the SQL statement so no NULL values are returned and the problem is not experienced.
WORKAROUND 2:
You can also change to an ODBC driver for the DB2 connectivity.
STATUS:
Waiting for fix in a future release of Benchmark Factory for Databases. -
Defect ID
ST45888