Error received repeatedly when executing the TPC-C test:
"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"
and
"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"
'C_SP_ORDER_STATUS_NAME' and 'C_SP_PAYMENT_NAME' stored procedures are not created by TPC-C, but Benchmark Factory is trying to access them.
WORKAROUND:
Download the attached hotfix for this issue (BFCore.dll) and save it to the "C:\Program Files\Quest Software\Benchmark Factory for Databases" directory. Then, execute the TPC-C test again.
STATUS:
Waiting for fix in a future release of Benchmark Factory for Databases.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy