Toad World® Forums

Error: CT-LIBRARY Server Message #2812 - Stored procedure 'A_SP_IR_1' not f


#1

I have just downloaded the Benchmark Factory for Sybase (Trial) and started to run the standard AS3AP benchmark

I am getting this error - Can someone assist me or point me in the right direction

AS3AP Job
Job Started
Checking for existing objects…
Objects already exists.
Started test Create Objects for AS3AP
Test completed successfully.
Started test AS3AP Information Retrieval(IR) Test
Agent(nycsyswks025) Error: CT-LIBRARY Server Message #2812 - Stored procedure ‘A_SP_IR_1’ not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

Agent(nycsyswks025) Error: Could not logon to the server!
Test cancelled due to errors.
** Job finished.
Total Time to perform the job:
Start Time: 4/8/2008 12:40:47 PM
End Time : 4/8/2008 1:13:39 PM
Elapsed : 0 Days 00:32:51.901


#2

The create benchmark objects step in the job checks to see if the benchmark objects all ready exist by checking for the benchmark tables. If the tables already exist the step will not create the objects. Unfortunately the check does not include the stored procedures. So to re-create everything you will need to check the always delete objects first check box in the Create objects step (see attached image) of the job and re-submit the job.

Kevin
Checkbox.jpeg


#3

Thanks - I am trying this now