Toad World® Forums

OCIStmtExecute


#1

Started test TPC-C Transaction Mix

Agent(solc-dell04) Error: Order Status : Statement ByName OCIStmtExecute

Test completed with errors.

From the error log,

** File Opened at: (2/10/2010 10:44:19 AM)
Benchmark Factory Agent
Version: 6.1.1
Build: 228
Copyright © Quest Software 2009

Hi,
After running TPC-C with userload=100 and scale factor = 10, I’ve got the error below.
Please advise.

From the Messages console,


Order Status : Statement ByName OCIStmtExecute
No new orders to deliver
No new orders to deliver
Order Status : Statement ByName OCIStmtExecute
Order Status : Statement ByID OCIStmtExecute
Payment : Statement ByName OCIStmtExecute
Payment : Statement ByName OCIStmtExecute


#2

Judging from the errorlog I would say you need to re-load your TPC-C database. The TPC-C test is a read/write test, so in order to obtain realistic, reliable, and repeatable results you need to reload/reinitialize the TPC-C database between runs.


#3

Yes, after I turned on the option “Always delete objects before create”.

I just notice that it was mentioned in the Best Practice guide too, only if I read it first before asking.

Thanks for helping.


#4

Sorry, forget to mention that option did fix the error.