When running standard tests with Benchmark Factory (BMF), the user receives these types of errors:
"Could not find stored procedure 'C_SP_New_Order"
"Could not find stored procedure 'C_SP_Payment"
"Could not find stored procedure 'C_SP_Delivery"
The benchmark database objects does not exist on the server that is being tested.
To generate the benchmark database objects, make sure to have "Create objects for [AS3AP, TPC-B | TPC-C | TPC-D]" exists in your benchmark job. This will ensure that the necessary benchmark objects will be created in the target database before the transaction mix is executed. If "Create objects for [AS3AP, TPC-B | TPC-C | TPC-D]" is not listed in your benchmark tab, please follow these steps to add it.
1) Go to the "Project" tab in BMF.
2) Right click any of your jobs and select "Add Create/Delete Benchmark objects".
3) This will open the Benchmark Objects Wizard. Click "Next" in the initial window.
4) In the "Benchmark selection window", select the standard benchmark scale that you are trying to run (i.e. TPC-B, TPC-C, etc.) and click "Next".
5) Set the benchmark scale the size you wish to use and click "Next".
6) Make sure you select the option: "Create Benchmark Objects". It's optional to select "Delete objects before creation". This basically allows BMF to delete existing benchmark objects before it recreates them. Click "Next" when ready.
7) Click "Finish" in the last screen to successfully add the "Create objects for [AS3AP, TPC-B | TPC-C | TPC-D]" line in your benchmark job.
