8 Replies Latest reply: Oct 4, 2012 2:14 PM by 952514 RSS

    Can not run business rule with bat file

    user13029084
      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
          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_
            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
              Hi,
              Thanks your answer,it's work!!

              Cheers!
              • 4. Re: Can not run business rule with bat file
                user13029084
                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
                  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
                    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
                      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
                        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