Skip to Content
author's profile photo Former Member
Former Member

Run procedure in Application Server from the command line

Hi

I created a procedure (VARKPI and placed in C:\Program Files\SAP BusinessObjects\Strategy Management\ApplicationServer\home) to call another procedure (VAR_CRE, this is created in the model). Nothing is happening and no error message also.

This is the code of my VARKPI procedure which i placed in home directory.

TRACE both 'batchload1.txt'
 
SUP KILL CONN TO CPM
USE CPM EXC
job VAR_CRE
trace both off
exit clear

My VAR_CRE in CPM model contain very simple queries to create measures.

Then i went to Run->CMD and to the directory ApllicationServer.Used the below command to run the job

PASAdmin.exe -j varkpi -u admin -p <pwd>

I only see that wkadmin file is shown in the Home directory whenever i run the procedure but the measures are not created in the CPM model. What could have been wrong?

Please suggest.

Thanks

Praveen

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 05, 2010 at 02:11 PM

    Hi Praveen,

    try to put the full path of the procedure in the command line.

    from PAS help:

    Note: When specifying a path location of an external file, use single quotes around the full path. For example, -j 'c:\temp\test';ext.

    Regards

    Pedro

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Praveen,

      The other thing that you will likely need to do is specify the model that you want the procedure to be executed from unless you want to run it from the default model specified for the user in question. For example, if you run the job as ADMIN, then that will try and execute the procedure from JUICE by default. If you want to change this, you need to do something like:

      PASAdmin.exe -u admin -j test;PROCLIB 

      or

      PASAdmin.exe -u admin -j test;&USEDATABASE 

      which will execute the procedure from your use database.

      However, unless you're making sure you use RETAIN keywords when switching between models, what usually makes much more sense as it avoids issues with model locking which can occur if you're executing the procudure from a model, is to make sure your job is run from an external file. For example:

      PASAdmin.exe -u admin -j test;ext 

      or

      PASAdmin.exe -u admin -j 'test.pro';ext

      Hope this helps,

      Robert

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.