I've problem with using *.bat file to run business rule. My Essbase version is 18.104.22.168 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:
call CmdLnLauncher -SWILSON -Usynadmin -P1111111 -r0004_COPYDATA
Is there something wrong? If anyone know about this problem, please help,thanks!!
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.
Edited by: JohnGoodwin on Apr 30, 2010 8:17 AM
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.
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.
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..
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