4 Replies Latest reply: Mar 12, 2009 7:52 AM by 686473 RSS

    EPMA batch client 11.1.1

    655432
      Hello,

      does anybody work with EPMA batch client 11.1.1?
      I want to run a simple script but I always get an error.

      My bat-script to run the EPMA batch client looks like this:
      REM -----------------------
      set EPMA_DIR=%HYPERION_HOME%\products\Foundation\BPMA\EPMABatchClient
      set EPMA_BATCH="%EPMA_DIR%\epma-batch-client.bat"
      set epmaserverurl=http://localhost/hyperion-epma-server;
      set workspaceurl=http://localhost:19000/workspace;

      +%EPMA_BATCH% -C"D:\data\epma_batch\update_proj_struct.txt"+
      REM -----------------------

      The script file "update_proj_struct.txt" looks like this:
      REM -----------------------
      +// login to EPMA+
      login admin,password;

      +// delete member of dimension Project+
      Delete Member
      Properties(ApplicationName, DimensionName, ParentName, MemberName, RemoveChildren)
      Values('applic', 'dim', 'parent', 'member', 'false');

      +// end of script+
      quit;
      REM -----------------------


      I always get the following messages and error:
      <...>: Validating the command file D:\data\epma_batch\update_proj_struct.txt
      <...>: Passed Validation
      <...>: Executing the command file D:\data\epma_batch\update_proj_struct.txt
      <...>: ERROR: Workspace Server URL cant be empty.


      Furthermore I tried the following variances:
      - set the URLs (EPMA- and workspace-URL) in the bat-script (see above) and set the URLs in the script file "update_proj_struct.txt"
      - use single quotes for URL-values
      - use double quotes for URL-values
      - set the variable "workspaceserverurl" instead of "workspaceurl"
      - use servername instead of "localhost"
      - use IP-address instead of "localhost"

      Nothing worked - I always get the error described above (in some of the described cases I get the error: "EPMA server URL cant be empty").

      The EPMA Batch Client User's Guide doesn't help anymore (it's very erroneous...).


      Best regards,
      Nicole
        • 1. Re: EPMA batch client 11.1.1
          JohnGoodwin
          Hi,

          I have never used the client though have you tried put the variables inside your txt script.

          e.g.

          set epmaserverurl=http://localhost/hyperion-epma-server;
          set workspaceurl=http://localhost:19000/workspace;

          login admin,password;

          // delete member of dimension Project
          Delete Member
          Properties(ApplicationName, DimensionName, ParentName, MemberName, RemoveChildren)
          Values('applic', 'dim', 'parent', 'member', 'false');

          // end of script
          quit;

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: EPMA batch client 11.1.1
            655432
            Hello John,

            yes, I tried that. It was one of the described variances and it didn't work...

            Cheers,

            Nicole
            • 3. Re: EPMA batch client 11.1.1
              JohnGoodwin
              Hi,

              It looks like the documentation is incorrect, the parameters for the URLs are case sensitive

              Update your script to

              SET BPMAServerURL ='http://localhost/hyperion-epma-server';
              SET WorkspaceURL ='http://localhost:19000/workspace';

              Now it should get further :)

              Cheers

              John
              http://john-goodwin.blogspot.com/
              • 4. Re: EPMA batch client 11.1.1
                686473
                Is there a Batch Client for version 9? I really need to schedule EMPA jobs using dependencies on other processes in our organization, and I can't see a way to do it in EPMA... Any recommendations?