Is your Oracle Hyperion Essbase patched to date?

By | Blogs We Love, New Releases, Oracle Hyperion Enterprise Performance Management - EPM, Patching | No Comments

Did you hear the news?  Our good friend Tanya over at Oracle recently updated the Oracle Proactive Support Blog with the news that the Hyperion Product Management team has released a new Patch Set Update (PSU) for Oracle Hyperion Essbase 11.1.2.4.x. Looking for someone to patch your system?  The infrastructure experts at iArch Solutions are your answer.  Contact us today to plan…

Read More

Your path to your OPatch inventory

By | Best Practices, Tips and Tricks, Oracle Hyperion Enterprise Performance Management - EPM, Patching | No Comments

Ever wonder what patches have already been applied to a given server or Oracle EPM/Hyperion environment? The opatch.bat lsinventory command is a good place to start to answer this question. Newer versions of the Oracle EPM System may not require any switches in order to run the OPatch lsinventory command, but in older versions they are likely needed. How to…

Read More

Another great EPM blog is now online!

By | Best Practices, Tips and Tricks, Blogs We Love, Oracle Hyperion Enterprise Performance Management - EPM | No Comments

Check out this new technical Oracle Enterprise Performance Management/Hyperion blog, “Hacking Hyperion” by one of Oracle’s former most respected technical engineers.  Todd is a rock star in the EPM/Hyperion technical community!  I’m looking forward to reading his entries as often as he can post them!  Great job Todd and keep it up. http://hackinghyperion.blogspot.com  

Read More

New Oracle EPM Documentation Library Look & Feel

By | EPM System Installation and Configuration, New Releases, Oracle Hyperion Enterprise Performance Management - EPM | No Comments

Oracle has updated the Enterprise Performance Management (EPM) Documentation Library for 11.1.2.4 to the new standard format used amongst the rest of the Business Intelligence and Fusion Middleware stack.  Check out the updated docs for this new release as well as the new look and feel. http://docs.oracle.com/cd/E57185_01/index.htm The majority of the documentation is now available in PDF, mobi and ePub formats for download.  …

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

Oracle Data Integrator (ODI) 12c Release

By | New Releases, Oracle Data Integrator - ODI, Oracle Hyperion Enterprise Performance Management - EPM | No Comments

Oracle Data Integrator (ODI) 12c Release Oracle has recently released a new and greatly improved version of Oracle Data Integrator (ODI). There are a ton of new features, product enhancements and architectural improvements (performance and scalability as a couple we love) to this new release. You can get more details on this new version as well as access to the…

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