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

Your time is valuable!

By | Best Practices, Tips and Tricks, EPM Hyperion Technical Infrastructure Services, EPM Presentations, Error Messages, New Releases, Press Releases, Troubleshooting, Uncategorized | No Comments

  It happens all the time.  You have a deadline looming and your Hyperion financial system starts to throw you error messages. Don’t you wish you had someone 24 hours a day, 7 days a week to alleviate this headache? Look no further than your experts at iArch Solutions.  Our expert team of infrastructure engineers are here to be your go-to people for these…

Read More

Oracle EPM 11.1.2.4 New Error Message Guides

By | Best Practices, Tips and Tricks, EPM System Installation and Configuration, Error Messages, New Releases, Oracle Hyperion Enterprise Performance Management - EPM | No Comments

   A Big Shout out to Torben Hein at Oracle for posting once again another absolutely essential blog entry on how to survive Oracle EPM/Hyperion troubleshooting dilemma in your Enterprise Performance Management deployments. Check out Torben’s post on the “New Error Message Guides in EPM 11.1.2.4” at the Business Analytics – Proactive Support page. https://blogs.oracle.com/proactivesupportEPM/entry/self_service_made_easy_new Thanks again Torben and team!

Read More

SQR: Failed to run job. 1003400

By | Error Messages, Oracle Hyperion Enterprise Performance Management - EPM, SQR Production Reporting (SQR) Errors | No Comments

ISSUE: When running a report with a large output in Oracle Hyperion SQR Production Reporting, the following error is returned.  Other smaller reports continue to run and produce output properly. ERROR MESSAGE DETAILS: Error Failed to run job. 1003400 Detailed Message: The HTML output is zipped but there isn’t a SPF Security File.  Unable to store job output. Recommended Action: Contact…

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