Oracle Smart View Error After Applying Analytic Provider Services (APS) Patch

By | Best Practices, Tips and Tricks, Error Messages, Essbase Errors, Oracle Hyperion Enterprise Performance Management - EPM, Patching, Smart View Errors, Tips and Tricks, Troubleshooting, Uncategorized | No Comments

After applying Analytics Provider Services Patch Set Update (PSU) 11.1.2.4.006 we can no longer perform an adhoc analysis to an Essbase application.  The following error is thrown inside of Microsoft Excel with the Smart View add-in: Error: ————————— Oracle Smart View for Office ————————— com/essbase/services/olap/grid/EssGGridOption.setOptionSingleMbrPov(Ljava/lang/Boolean;)V ————————— OK ————————— Screen Shot of Error:   To confirm if there is an issue with the…

Read More

Essbase Error (1024016): Request from user was terminated since it exceeded the time limit.

By | Error Messages, Essbase Errors, Financial Reports Errors, Oracle Hyperion Enterprise Performance Management - EPM, Smart View Errors | No Comments

ISSUE: When running a query in Oracle Hyperion Smart View, the Essbase Excel-Addin, or any other Reporting and Analysis tools, the following error is returned after an extended period of time.  When this occurs, the user must close Microsoft Excel and then re-open and re-login to continue working. ERROR MESSAGE DETAILS: Oracle Hyperion Smart View for Office, Fusion Edition Essbase Error…

Read More

Essbase Error (1020051): Maximum number of rows processed [500000] exceeded [502615]

By | Error Messages, Essbase Errors, Oracle Hyperion Enterprise Performance Management - EPM, Smart View Errors | No Comments

ISSUE: When running a large spreadsheet refresh or query in Oracle Hyperion Smart View the following error is returned.  When this occurs, the user must close Microsoft Excel and then re-open and re-login to continue working. ERROR MESSAGE DETAILS: Oracle Hyperion Smart View for Office, Fusion Edition Essbase Error (1020051): Maximum number of rows processed [500000] exceeded [502615]. OK SCREEN SHOT:…

Read More