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

How to use the Smart View Diagnostics tool

By | Best Practices, Tips and Tricks, Smart View Errors, Tips and Tricks, Troubleshooting, Utilities | No Comments

The Smart View Diagnostic tool is an invaluable piece of your troubleshooting abilities.  It allows the end user the ability to easily gather the necessary technical information to assist in solving difficult Smart View issues which might arise.  Once the information is obtained, it can then be sent to Oracle Technical Support for further analysis and hopefully lead to quick response and solution….

Read More

Internet Explorer’s low default time out setting for obtaining data from Essbase

By | Best Practices, Tips and Tricks, EPM System Installation and Configuration, Smart View Errors | No Comments

Ever get the “request timed out” error message and there is not anyone available to help you fix it?  Read below and find a step by step guide on how you can adjust your settings and not slow down your uptime. ERROR: Oracle Smart View for Office The request timed out. Contact your Smart View client system administrator to extend…

Read More

Oracle Smart View Error 1935

By | Best Practices, Tips and Tricks, Smart View Errors | No Comments

ISSUE: When attempting installation of Smart View 11.1.2.5.400 on 32-bit or 64-bit version of Microsoft Office 2013 the following error occurred while running it as a standard user: ERROR MESSAGE DETAILS: Oracle Smart View 32-bit for Office Error 1935. An Error occurred during the installation assembly component {9BAE13A2-E7AF-D6C3-A01F-C8B3B9A1E18E}. HRESULT: 0x80070005. OK SCREEN SHOTS: Oracle Smart View 32-bit for Office Oracle…

Read More

Cannot connect to the provider. Make sure it is running in the specified host/port. Error (503)

By | Error Messages, Oracle Hyperion Enterprise Performance Management - EPM, Provider Services (APS) Errors, Smart View Errors | No Comments

ISSUE: When running a large query in Oracle Hyperion Smart View, 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 Cannot connect to the provider.  Make sure it is running in…

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