1 2 Previous Next 17 Replies Latest reply on Aug 25, 2010 3:53 PM by 773959

    essmsh error: Parse error near

    639696
      Hello All,
      When I run each command line by line it runs fine. But when i run this as
      essmsh test.mxl
      I am using this on Unix Platform

      I get this "essmsh error: Parse error near"

      essmsh test.mxl
      Analytic Services MaxL Shell - Release 7.1.6 (ESB7160B096)
      (c) Copyright 2000-2006 Hyperion Solutions Corporation.
      All rights reserved.

      MAXL> login xxxxxx identified by xxxxxxxx on xxxxxxxx ;

      OK/INFO - 1051034 - Logging in user [xxxxxxx].
      WARNING - 1051287 -
      Essbase license will expire on: 12/31/10.
      OK/INFO - 1051035 - Last login on Friday, May 16, 2008 8:46:23 AM.
      OK/INFO - 1241001 - Logged in to Essbase.

      MAXL>
      2> alter system load application AAAAAA;

      essmsh error: Parse error near

      MAXL>
      2> alter application AAAAAA load database AAAAAAA;

      essmsh error: Parse error near

      MAXL>
      2> alter database AAAAAA.AAAAAA unlock all objects;

      essmsh error: Parse error near

      ---------------------------------------
      For Trouble shooting purpose i have reduced the script to below

      cat test.mxl
      login xxxxxxx identified by xxxxxxxxx on xxxxxxxxxxxx;
      alter system load application AAAAAA;
      alter application AAAAAA load database AAAAAAA;
      alter database AAAAA.AAAAA unlock all objects;

      Any Suggestions ?
        • 1. Re: essmsh error: Parse error near
          602610
          It looks like you are using a variable that you pass to the MaxL statements. If yes, try to use it as a parameter in a batch file and pass it to your MaxL file.
          • 2. Re: essmsh error: Parse error near
            GlennS_3
            try putting single quotes around your application name
            • 3. Re: essmsh error: Parse error near
              Dhanjit Giri
              I am also getting the same problem on MaxL script which is running on Aix
              I have used ' properly like
              ex
              login 'user' 'password' on 'server'
              // after this line i am getting parse error

              Any Idea
              • 4. Re: essmsh error: Parse error near
                602610
                you may have used a wrong name of server/username/ password to get the parse error.
                you can put these parameters in the .mxl / .msh file or pass them when you call that file from teh shell:
                ex:

                essmsh 'load_data.msh' 'testuser' 'testpwd' 'prodServer'
                • 5. Re: essmsh error: Parse error near
                  624081
                  Try setting your variables within your MaxL script to test.

                  set app1=your_app;
                  set db1=your_db;

                  alter system load application '$app1';

                  Brian Chow
                  • 6. Re: essmsh error: Parse error near
                    Dhanjit Giri
                    Thanks for your help
                    but I have checked properly nothing is wrong even I have changed all variable and shorten my code but still getting parse error after login

                    I am just giving my MaxL file to you below is username/passwords to understand you better

                    ************************************
                    username dhanjit
                    password dhanjit#06
                    server name hyp.olap.com
                    application name IdBs
                    database name db
                    sql user: hyper
                    sql password :hyper123
                    ***********************************************
                    here is MaxL file
                    ***********************************************

                    login 'dhanjit' 'dhanjit#06' on 'hyp.olap.com';
                    alter system load application 'IdBs';
                    alter application 'IdBs' load database 'db';

                    echo "************** Building dimension ADJ **********";

                    import database 'IdBs'.'db' dimensions connect as 'hyper' identified by 'hyper123' using server rules_file 'DB_ADJ.rul' on error write to 'DBADJ.log';

                    logout;
                    exit;


                    (my MaxL is published on workspace as a job)and getting error

                    //MaxLScript.stdout

                    MAXL> login 'dhanjit' 'dhanjit#06' on 'hyp.olap.com';

                    OK/INFO - 1051034 - Logging in user [dhanjit].
                    OK/INFO - 1051035 - Last login on Thursday, May 29, 2008 11:22:15 AM.
                    OK/INFO - 1241001 - Logged in to Essbase.

                    MAXL> alter system load application 'IdBs';

                    MAXL> alter application 'IdBs' load database 'db';
                    ...

                    ....
                    MAXL> logout;

                    User dhanjit is logged out


                    MaxL Shell completed

                    and error is in following file

                    MaxLScript.stderr

                    sparse error near
                    sparse error near
                    sparse error near




                    I am not getting where is problem

                    could you suggest something
                    • 7. Re: essmsh error: Parse error near
                      GlennS_3
                      remove the echo statement. IT is a DOS command not an MaxL command
                      • 8. Re: essmsh error: Parse error near
                        624081
                        I disagree.

                        Echo is a MaxL command.

                        You might have to turn spool on to have any effect.

                        spool on to 'output.txt';

                        echo "************** Building dimension ADJ **********";

                        spool off;

                        Brian Chow
                        • 9. Re: essmsh error: Parse error near
                          GlennS_3
                          Brian,
                          You are correct. One of those things never noticed. There is so much packed in, I am amazed as to how much I learn all the time.
                          • 10. Re: essmsh error: Parse error near
                            634466
                            I think you have created the MAXL script in windows comp, and then copied it into the essbase server (UNIX) using Putty or something similar.

                            Try re-creating the MAXL in the UNIX vi-editor.
                            • 11. Re: essmsh error: Parse error near
                              Dhanjit Giri
                              Thanks Brian

                              I have used "spool on" also but it didn't work.
                              I have reduced code to understand better and find error quickly


                              so once I tried to merge two line in one then its working fine,
                              so I merged all the different line in one and it was fine.



                              Actually I have written this MaxL script in Vi editor using putty and then transfered MaxL to window machine using FTP and published this MaxL to hyperion workspace. every change that I have made in window machine was not acceptable to MaxL in AIX machine. It was giving sparse error.

                              Thanks for your support

                              Message was edited by:
                              Dhanjit
                              • 12. Re: essmsh error: Parse error near
                                Dhanjit Giri
                                Yes, I have done almost the same.
                                Now I create this script in MaxL and try again
                                • 13. Re: essmsh error: Parse error near
                                  634466
                                  It is the character-set incompatibility in Windows and non-windows environment. The "carriage-return" character usually causes problems.
                                  • 14. Re: essmsh error: Parse error near
                                    624081
                                    Finally I get one on GlennS, Booya.

                                    Dhanjit you have to be careful with VI editor.

                                    If you have a windows desktop and UNIX server, there's a tool called MKS.
                                    It let's you develop UNIX on your desktop with minimal conversion issues.

                                    Brian Chow
                                    1 2 Previous Next