This discussion is archived
8 Replies Latest reply: Oct 4, 2012 12:14 PM by 952514 RSS

Can not run business rule with bat file

user13029084 Newbie
Currently Being Moderated
Hi all,
I've problem with using *.bat file to run business rule. My Essbase version is 11.1.1.3 and the syntax within
*.bat is simple, but I always got the Usage message and can not execute the rule.

The error result as blow(I already execute the syntax in command panel directly):

C:\Hyperion\products\Essbase\eas\console\bin>CmdLnLauncher -SWILSON -Usynadmin -P111111 -r0004_COPYDATA
Usage: CmdLineLauncher [-p:<passwordFile>] -Sservername -Uusername [-rBusiness R
ule Name | -sSequence Name] [-fRun Time Prompts file] [-validate]

My *.bat file content as below:

cd c:\Hyperion\products\Essbase\eas\console\bin
call CmdLnLauncher -SWILSON -Usynadmin -P1111111 -r0004_COPYDATA

Is there something wrong? If anyone know about this problem, please help,thanks!!
  • 1. Re: Can not run business rule with bat file
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    Hi,

    Here is a brief overview on how to use the command line launcher.

    You can create a file and put the following information into it filling in the servername,app name and db name

    ExecDB::"Planning/servername/appname/dbname"

    Save it as .xml file (don’t think it has to be an xml, could be .txt), so something like connect.xml

    Then when you run your command line do exactly like before Cmdlnlauncher -Sservername -Uusername -p:password.txt -rrule -fconnect.xml

    If you have variables in your rule you can

    In EAS right click over the rule and select "Automate Launch Variables", fill in the details and then save it is as an xml.

    You just need to reference the xml in the batch script as described above using the -f parameter, for sequences remove -rrule and use –sSequence

    update password.txt to the name of your password file.

    Cheers

    John
    http://john-goodwin.blogspot.com/

    Edited by: JohnGoodwin on Apr 30, 2010 8:17 AM
  • 2. Re: Can not run business rule with bat file
    _RahulS_ Guru
    Currently Being Moderated
    Hi Thr,

    I believe "1111111" is ur password, but here in -P prompt we need to provide encrypted password file name.

    Cheers...!!!
  • 3. Re: Can not run business rule with bat file
    user13029084 Newbie
    Currently Being Moderated
    Hi,
    Thanks your answer,it's work!!

    Cheers!
  • 4. Re: Can not run business rule with bat file
    user13029084 Newbie
    Currently Being Moderated
    Hi,
    Thanks! Yes,it have to use password file. So it can not key in password directly anyway?
  • 5. Re: Can not run business rule with bat file
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    If you dont include -p:passwordfile then it may prompt for the password.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 6. Re: Can not run business rule with bat file
    729786 Newbie
    Currently Being Moderated
    Hello John,

    I would like to know if it is possible to refernce an xml file with a sequence?
    I don't know why, but when I launch this command line:

    CmdLnLauncher -Sservername -Uusername -p:password.txt -ssequence -fvariables.xml

    It doesn't interpret the xml file. Have you ever encountered this problem? Do you have any clue to batch a sequence?

    Thank you a lot for your help and your advices.

    Cheers
  • 7. Re: Can not run business rule with bat file
    935873 Newbie
    Currently Being Moderated
    Hi All,

    I am trying to use cmdlnLauncher.bat to schedule few rules and sequences.
    I was able to do it for rules however for sequences, I am getting error.

    My syntax:
    cmdlnLauncher.bat -p:password -S<server name> -Uadmin -sAct2011

    Error: "Connect String missing or has an invalid format. Please specify a valid connect string (Server/App/DB)"

    As the -f<rtp file> is ignored for sequences, I am not sure how to pass connection string to the wizard.

    Any suggestions please..

    Kind regards,
    Ankit
  • 8. Re: Can not run business rule with bat file
    952514 Newbie
    Currently Being Moderated
    Hi phnx, I had the same problem that your.

    The "-f<rtp file>" is ignored for the sequences and I also could not pass the connection string to the wizard.

    So I specified all the "Business Rules" of the sequence. Like this:

    call CmdLnLauncher.bat -p:password.txt -Sserver -Uuser -rrule1 -fstringconnect.xml
    call CmdLnLauncher.bat -p:password.txt -Sserver -Uuser -rrule2 -fstringconnect.xml
    call CmdLnLauncher.bat -p:password.txt -Sserver -Uuser -rrule3 -fstringconnect.xml

    I hope that helps

    Regards,

    Well

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points