Toad World® Forums

TPC-C errors during transaction mix execution


#1

Hi All,

We are using the Benchmark Factory 6.5 Trial version. We are running into many errors like the ones below when executing the transaction mix.

Could we get your advice please

Payment : Statement ByName OCIStmtExecute
ORA-06550: line 1, column 7:
PLS-00201: identifier ‘C_SP_PAYMENT_NAME’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

ORA-06550: line 1, column 7:
PLS-00201: identifier ‘C_SP_NEW_ORDER’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

New Order Timed Out after 10 tries
ORA-06550: line 1, column 7:
PLS-00201: identifier 弸眹ߐ’C_SP_NEW_ORDER’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

New Order Timed Out after 10 tries
Order Status : Statement ByName OCIStmtExecute
ORA-06550: line 1, column 7:
PLS-00201: identifier ‘C_SP_ORDER_STATUS_NAME’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

ORA-06550: line 1, column 7:
PLS-00201: identifier ‘C_SP_NEW_ORDER’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

New Order Timed Out after 10 tries


#2

It looks like the required database objects where not created. Did you run the job with the step “Create object for TPC-C” using the same profile you are using to run the test? Did it complete without errors?