Oracle Hyperion Essbase and EAS Master Note [Video] (Doc ID 1328972.1)

Oracle Hyperion Essbase and EAS Master Note [Video] (Doc ID 1328972.1) APPLIES TO: Hyperion Essbase Administration Services - Version 9.3.0.0.00 to 11.1.2.3.000 [Release 9.3 to 11.1] Information in this document applies to any platform. Added New Content on 01-Apr-2014 PURPOSE The purpose of this document is to serve as a quick reference for Essbase and Essbase Administration Services (EAS). SCOPE This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Hyperion Essbase Administration Services environments. This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest. This includes the following categories: EAS Server Issues EAS Console Issues SQL Load Issues Essbase Issues Web Browser Issues Business Rule Issues Planning Issues Analytic Provider Services (APS) Server Issues How To Articles DETAILS The Oracle EPM and BI Support Newsletter Current Edition (Document 1347131.1) is available; released quarterly it provides proactive support information on numerous product topics. The following articles will assist in troubleshooting issues with Essbase and EAS. EAS Server Issues Document 1592931.1 Externally Authenticated User Cannot Login to EAS when Password is Due to Expire Document 1467673.1 Administration Services (EAS) Fails to Start: "Failed to initialize the application eas_datasource due to error weblogic.application.ModuleException" Document 1339633.1 Essbase Administration Services (EAS) Deployment is Failing on the Second Server in a Clustered Environment Document 1083714.1 Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) Document 888704.1 Error Connecting To Essbase Administration Services (EAS) Installed on a Windows 64-bit Server "EAS Server is not responding" Document 1315512.1 Essbase Administration Services (EAS) Server Is Crashing Intermittently on a Unix Server Document 1290761.1 Opening Small Outline in Essbase Administration Services (EAS) Console Returns Warning "EAS Server has -1695 MB available memory, and estimated memory needed to open the outline is 0 MB" Document 948652.1 Error When Logging in to Essbase Administration Server (EAS) From the EAS Console "Could not connect Administration Server. Client and server are different versions." Document 1223357.1 Migrating an Aggregate Storage (ASO) Outline Crashes the Essbase Administration Services Server (EAS) When Using 64 bit Installation Document 1064352.1 Substitution Variables Do Not Display in Essbase Administration Services (EAS) Document 1512957.1 Unable to Connect to the Essbase Administration Services (EAS) Server, Server Not Starting Video - EAS_RDA (02:33) Trouble seeing this video? EAS Console Issues Document 1594567.1 Essbase Administration Services (EAS) v11.1.2.3 Console Does Not Work With Java 7 Update 45 Document 1484136.1 Opening an Essbase Outline or Calc Script in the Essbase Administration Services (EAS) Console is Extremely Slow and May Crash Document 1479726.1 Essbase Administration Services (EAS) Console Displays Strange/Garbage Characters in Properties Document 1342779.1 Essbase Administration Services (EAS) v11.1.2.x: Unable to Change Essbase Database Properties, Save/Verify/Close/Help Buttons are Disabled Document 1328740.1 Essbase Server Crashes When Expanding Essbase Database in Essbase Administration Services (EAS) Console Document 1151474.1 Special Characters Are Not Shown Correctly in the Essbase Administration Services Console (EAS) Outline as Seen Previously Without Byte Order Mark (BOM) Encoding Document 1142474.1 Calculation Scripts Submitted From Essbase Administration Services (EAS) Console Fail With Error: Server Returned Http Response Code: 500 Document 1157266.1 Opening Calc Script in Essbase Administration Services (EAS) or Query with Large SmartList Crashes Application Document 1323193.1 Error."Analytical Services user [%s] Authentication Fails against the Shared Services@ with Error [EPMCSS-251014: Invalid token]" if Connecting Essbase Server via EAS Console Using SSO Option Document 1317100.1 Essbase Administration Services (EAS) Console Does Not Remember the EAS Server Name in the Login Box Document 972348.1 Java Web Start Error When Launching the Essbase Administration Services (EAS) Console Via a Web Browser "Unable to load resource: http://easserver:10080/easconsole/eas_client. Document 1061868.1 Cannot Open Shared Services User Management Console from EAS Console Document 1312810.1 Essbase Client and Essbase Administration Services (EAS) Console v11.1.1.3 Do Not Work On Windows 7 Document 1064352.1 Substitution Variables Do Not Display in Essbase Administration Services (EAS) Document 875814.1 Essbase Agent Hangs When Doing a View Session in the Essbase Administration Services (EAS) Console Document 1197963.1 Windows Non-Administrator User Cannot Edit Essbase Filters or Calc Scripts in the Essbase Administration Services (EAS) Console Document 1293757.1 Unable To Connect To Essbase Administration Services (EAS) from Console. Error: "Cannot Connect to Essbase Administration Server" Document 787079.1 Error "1090004: Unable to open file" When Trying to Open Data File on Shared Network Drive Via the Essbase Administration Services Console Document 1510195.1 Essbase Administration Services (EAS) Online Help Link Fails with "Error 404--Not Found" Document 1520339.1 MaxL Script Editor in Essbase Administration Services (EAS) Does Not Accept Command for Multiple SQL Data Loads, Error: "{Rulename} does not exist" SQL Load Issues Document 1202533.1 "Error 408 [DataDirect][ODBC SQL Server Driver][SQL Server]A constant expression was encountered in the ORDER BY list, position 1" When Trying To View Table Data In Essbase Integration Services Console Document 1205065.1 SQL Retrieve in Essbase Administration Services (EAS) Dimension Build Clears Field Information and Does Not Allow Subsequent Validation Essbase Issues Document 1270220.1 Essbase is Hanging When Essbase Administration Services (EAS) is Used to Create an Application Document 1062514.1 Cannot Use Function List to Create Essbase Filter in Essbase Administration Services (EAS) Console Document 844320.1 EAS 9.3.1 Error message error: "109: MAXL API instance is not active" Video - ESS_RDA (04:24) Trouble seeing this video? Web Browser Issues Document 1074209.1 Errors in eas.log When Launching Essbase Administration Services Console (EAS) via a Web Browser Document 779329.1 "easconsole.jnlp" Error When Launching Essbase Administration Services (EAS) Console via a Web Browser Document 1141766.1 Unable To Launch the Essbase Administration Services (EAS) Web Client v9.3.1.x From Internet Explorer 8 (IE8) Document 1170773.1 Error When Launching Essbase Administration Services (EAS) Console v11.1.2 Via Web Browser "Unable to load resource: http://servername:80/easconsole/eas_client.jar " Document 1438928.1 Calcscript Run via Essbase Administration Services (EAS) Webconsole Returns Errors 1042070 & 1013080 & Times Out After 5 Minutes Despite Conf Changes to WebLogic Document 1293608.1 Essbase Administration Services (EAS) Connection Issues when Using the Web Console Business Rules Issues Document 1082284.1 Not Able to View the Business Rules in Essbase Administration Services Console: "Error (1051514) Essbase failed to get roles for users and groups for applications during refresh/login sync/user sync" Document 1297976.1 Unable to see Business Rules Node in Essbase Administration Services (EAS) Document 1328483.1 Error: "Error connecting to Essbase server EssbaseCluster-1" When Trying to Connect Business Rules to Essbase Planning Issues Document 1274440.1 Unable To See Planning Servers When Creating Business Rule In Essbase Administration Services EAS Console Document 1233363.1 Unable To Select a Planning Outline "Error Connecting between The EAS Server and The Planning Server" Document 1297825.1 War Files are Getting Deleted On Restart of Essbase Administration Services (EAS) on Planning Server Analytic Provider Services (APS) Server Document 1314669.1 Fail to Connect to Analytic Provider Service (APS) from Essbase Administration Services (EAS) Console in 11.1.2.0 Document 1083714.1 Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) Document 1127083.1 Unable To Connect To Essbase Administration Services (EAS) and Analytic Provider Services (APS) in a Distributed Environment in Version 11.1.2 How To Articles Document 968836.1 Increase the Java Heap Memory Size For Essbase Administration Services (EAS) on Unix Deployed with Weblogic 8.1 Document 1305927.1 Increasing the Java Heap Setting for Essbase Administration Services (EAS) v11.1.1.x for Unix Environments Document 1286018.1 Increase the Java Heap Size For Essbase Administration Services (EAS) v11.1.2. Document 968961.1 How to Create a Successful Connection to SAP R/3 from Essbase Administration Services (EAS) for Essbase Document 1136095.1 How to Pass the Value for the Substitution Variable in a MaxL Script and Display it with Quotes in Essbase Administration Services (EAS) Console Document 751857.1 Set the Essbase Administration Services (EAS) Session Timeout Interval Document 1175294.1 How To Change the Essbase Administration Services (EAS) ESSLANG setting in EPM v11.1.2 (Doc ID 1175294.1) Document 1338020.1 How To Change The Default Timeout Period For Essbase Administration Services (EAS) Sessions? Document 974043.1 How To Set/Increase the Essbase Administration Services (EAS) Debug Level Document 763070.1 Re-externalize Essbase Administration Services (EAS) Users Lifetime support policy: http://www.oracle.com/us/support/lifetime-support/index.html EPM Certification/Compatibility Matrix: http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html To discuss this information further with Oracle Experts and industry peers, we encourage you to review, join or start a discussion in the related Essbase Communities. Oracle Essbase in communities.oracle.com Essbase in forums.oracle.com REFERENCES NOTE:972348.1 - Java Web Start Error When Launching the Essbase Administration Services (EAS) Console Via a Web Browser "Unable to load resource: http://easserver:10080/easconsole/eas_client.jar" NOTE:974043.1 - How To Set/Increase the Essbase Administration Services (EAS) Debug Level NOTE:1290761.1 - Opening Small Outline in Essbase Administration Services (EAS) Console Returns Warning "EAS Server has -1695 MB available memory, and estimated memory needed to open the outline is 0 MB" NOTE:1297825.1 - .War Files are Getting Deleted On Restart of Essbase Administration Services (EAS) on Planning Server NOTE:888704.1 - Error "EAS Server is not responding" When Connecting To Essbase Administration Services (EAS) on Windows 64-bit Server NOTE:948652.1 - Error When Logging in to Essbase Administration Server (EAS) From the EAS Console "Could not connect Administration Server. Client and server are different versions." NOTE:844320.1 - EAS 9.3.1 Error Message Error: "109: MAXL API instance is not active" NOTE:968836.1 - Increase the Java Heap Memory Size For Essbase Administration Services (EAS) on Unix Deployed with Weblogic 8.1 NOTE:968961.1 - How to Create a Successful Connection to SAP R/3 from Essbase Administration Services (EAS) for Essbase NOTE:1323193.1 - Error."Analytical Services user [%s] Authentication Fails against the Shared Services@ with Error [EPMCSS-251014: Invalid token]" if Connecting Essbase Server via EAS Console Using SSO Option NOTE:1328483.1 - Error: "Error connecting to Essbase server EssbaseCluster-1" When Trying to Connect Business Rules to Essbase NOTE:1082284.1 - Unable to View the Business Rules in Essbase Administration Services Console: "Error (1051514) Essbase failed to get roles for users and groups for applications during refresh/login sync/user sync" NOTE:1347131.1 - Oracle Business Analytics Support News Current Edition - Volume 11 : March 2014 NOTE:1315512.1 - Essbase Administration Services (EAS) Server is Crashing Intermittently on a Unix Server NOTE:1136095.1 - How to Pass the Value for the Substitution Variable in a MaxL Script and Display it with Quotes in Essbase Administration Services (EAS) Console NOTE:1274440.1 - Unable To See Planning Servers When Creating Business Rule In Essbase Administration Services EAS Console NOTE:1286018.1 - Increase the Java Heap Size For Essbase Administration Services (EAS) v11.1.2 NOTE:1233363.1 - Unable To Select a Planning Outline "Error Connecting between the EAS Server and the Planning Server" NOTE:1270220.1 - Essbase is Hanging when Essbase Administration Services (EAS) is Used to Create an Application NOTE:1061868.1 - Cannot Open Shared Services User Management Console from EAS Console NOTE:1083714.1 - Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) NOTE:1297976.1 - Unable to see Business Rules Node in Essbase Administration Services (EAS) NOTE:1170773.1 - Error When Launching Essbase Administration Services (EAS) Console v11.1.2 Via Web Browser "Unable to load resource: http://servername:80/easconsole/eas_client.jar " NOTE:1314669.1 - Fail to Connect to Analytic Provider Service (APS) from Essbase Administration Services (EAS) Console in 11.1.2.0 NOTE:1317100.1 - Essbase Administration Services (EAS) Console Does Not Remember the EAS Server Name in the Login Box NOTE:1205065.1 - Column Headers Defined in Data Load Rules Files Are Changing or Lost when Retrieving from a SQL Data Source NOTE:1312810.1 - The Essbase Administration Services (EAS) Console 11.1.1.3 Does Not Work on Windows 7 NOTE:1062514.1 - Cannot Use Function List to Create Essbase Filter in Essbase Administration Services (EAS) Console NOTE:779329.1 - "easconsole.jnlp" Error When Launching Essbase Administration Services (EAS) Console via a Web Browser NOTE:1338020.1 - How To Change The Default Timeout Period For Essbase Administration Services (EAS) Sessions? NOTE:1339633.1 - Essbase Administration Services (EAS) Deployment is Failing on the Second Server in a Clustered Environment NOTE:1142474.1 - Calculation Scripts Submitted From Essbase Administration Services (EAS) Console Fail With Error: Server Returned Http Response Code: 500 NOTE:1151474.1 - Special Characters Are Not Shown Correctly in the Essbase Administration Services Console (EAS) Outline as Seen Previously Without Byte Order Mark (BOM) Encoding NOTE:1202533.1 - "Error 408 [DataDirect][ODBC SQL Server Driver][SQL Server]A constant expression was encountered in the ORDER BY list, position 1" When Trying To View Table Data In Essbase Integration Services Consol NOTE:1157266.1 - Opening Calc Script in Essbase Administration Services (EAS) or Query with Large SmartList Crashes Application NOTE:1064352.1 - Substitution Variables Do Not Display in Essbase Administration Services (EAS) NOTE:1074209.1 - Errors in eas.log When Launching Essbase Administration Services Console (EAS) via a Web Browser NOTE:1342779.1 - Essbase Administration Services (EAS) v11.1.2.x: Unable to Change Essbase Database Properties, Save/Verify/Close/Help Buttons are Disabled NOTE:1141766.1 - Unable To Launch the Essbase Administration Services (EAS) Web Client v9.3.1.x From Internet Explorer 8 (IE8) NOTE:751857.1 - Set the Essbase Administration Services (EAS) Session Timeout Interval NOTE:1386679.1 - How to Set the Session Timeout Interval for Essbase Administration Services(EAS) 11.1.2.1