Hyperion Essbase (MOSC)

MOSC Banner

MaxL Script ERROR - 1242021 - (1) Syntax error near ['"']

edited Feb 7, 2019 12:21PM in Hyperion Essbase (MOSC) 5 commentsAnswered ✓

I'm having issues with a MaxL script to load data from a SQL Table when the MaxL file uses an encrypted password in EPM 11.1.2.4

The following script run through maxl when logged in to essbase directly without encryption.

I have tried multiple scenarios with and without double quotes but got similar error every time.

Any suggestions would be helpful.

=====================================================================================================================

MAXL> login 'User_Name' 'Password' on 'localhost:1423';

OK/INFO - 1051034 - Logging in user [Automation_Functional@Native Directory].

OK/INFO - 1241001 - Logged in to Essbase.

MAXL> import database 'CGI_PLAN'.'Plantool' data connect as 'EPM_EXTANALYTIC' identified by 't*4y2*6Q*ACDr*erd*AC' using server rules_file  'SQLAdj' on error write to '/essbkp/scripts/CGI_PLAN/logs/AdjfromHFM_error.txt';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center