3 Replies Latest reply: Aug 16, 2013 4:21 AM by PaulWAtMacmillan RSS

    Executing a calc script in MAXL

    PaulWAtMacmillan

      "Heaven to murgatroid" this has completely defeated me today so all help will be gratefully accepted.

       

      I have an Essbase application (NPG3BK) with 4 databases (BMR, Detail, Main & Workforce)  - 3 are Planning Types and a fourth is added for reporting.

      I have 1 Essbase Calc script at application level - the calc script is called ExBinAll. It verifies perfectly and I can run it manually against any of the databases.

       

      I have a MAXL script to run the calculation against each of the databases under NPG3BK. The relevant piece of code is...

       

      alter system load application 'NPG3BK';

      execute calculation NPG3BK.'ExBinAll.csc' on database BMR;


      However when the batch runs I get this message...

      ERROR - 1012500 - The requested calc script [ExBinAll.csc] not found.

       

      Environment: Win2008 R2

      Essbase: 11.1.2.1.600

      Logged on to Win2008 with a server administrator ID.

      Logged into Essbase/MAXL with an Hyperion administrator ID.

       

      I have checked the application name and calc script name SO many times through EAS and Windows Explorer. It's there!!

       

      Can anyone out there resolve this for me?

       

      Many thanks for your help

      PW

        • 1. Re: Executing a calc script in MAXL
          Celvin Kattookaran

          Try this one

          execute calculation 'NPG3BK'.'ExBinAll' on database BMR;


          Regards

           

           

          Celvin

          http://www.orahyplabs.com


          • 2. Re: Executing a calc script in MAXL
            PaulWAtMacmillan

            Celvin, many thanks - unfortunately that didn't work either..

             

            I've tried..

            execute calculation 'NPG3BK'.'ExBinAll' on database BMR;

            execute calculation 'NPG3BK'.'ExBinAll' on database 'BMR';

            execute calculation 'NPG3BK'.'ExBinAll.csc' on database BMR;

            execute calculation 'NPG3BK'.'ExBinAll.csc' on database 'BMR';  and ALL got the same error code 1012500

             

            So I decided to try store the calcscript ExBinAll under the database NPG3BK.BMR and run it with the following syntax ..

            execute calculation NPG3BK.BMR.'ExBinAll.csc';   gives      ERROR - 1012864 - Calculation script name [ExBinAll.csc] is longer than [8] characters.

            execute calculation NPG3BK.BMR.'ExBinAll';   gives      the original (1012500) error.

            execute calculation 'NPG3BK'.'BMR'.'TEST.csc';    gives      the original (1012500) error.  {ERROR - 1012500 - The requested calc script [TEST] not found.}

             

            Any other ideas from anyone?

            • 3. Re: Executing a calc script in MAXL
              PaulWAtMacmillan

              AARGH - I've found it....

               

              Way back in the code the admin ID was logging into a completely different server!!

               

              Silly, silly me.

               

              Sorry everyone (SO embarrassed!!!)