-
Title
'ODBC Error (07001,FFFE7961) - [IBM][CLI Driver] CLI0100E Wrong number of parameters'. -
Description
User tried to use Benchmark Factory for Database(BMF) for Load with ODBC connection profile. User got error: 'ODBC Error (07001,FFFE7961) - [IBM][CLI Driver] CLI0100E Wrong number of parameters'.
Loading table C_History ( 1000 (3.33%) rows completed )
Started loading table C_Order_Line.
ODBC Error (07001,FFFE7961) - [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001
Started loading table C_Item.
Started loading table C_District.
Completed loading table C_District.
Started loading table C_New_Order.
Loading table C_History ( 2000 (6.67%) rows completed )
Loading table C_Item ( 1000 (1.00%) rows completed )
Loading table C_History ( 3000 (10.00%) rows completed )
Loading table C_Item ( 2000 (2.00%) rows completed )
ODBC Error (07001,FFFE7961) - [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001
ODBC Error (07001,FFFE7961) - [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001
Loading table C_History ( 4000 (13.33%) rows completed )
.....
.....
Loading table C_Stock ( 99000 (99.00%) rows completed )
Loading table C_Stock ( 100000 (100.00%) rows completed )
Completed loading table C_Stock.
Test cancelled due to errors.
** Job finished.
Total Time to perform the job:
-
Resolution
Apply a hotfix below:
1. Shutdown BMF & Agent, if lanuched.
2. Backup the orignal TPCC_ODBC.dll, default locate is:C:\Program Files\Quest Software\Benchmark Factory for Databases\bin.
3. Download CTPCC_ODBC.zip from attachment and replace TPCC_ODBC.dll with the newest one.
4. Launch BMF and run the test again.