Blog Details Page

  • Date: May 4, 2016
  • Article by: Joe Malewicki

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:

Pic1

 

To confirm if there is an issue with the Provider Services (APS) patch you can run a test to confirm the version details for the Provider Services JAPI:

http://:13080/aps/Test

The version of Analytic Provider Services should match the JAPI version.  Our test showed a discrepancy:

Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.3.4408

Pic2

This issue is being caused by the ess_japi.jar file being a “Read-Only” file. When the new patch was applied it could not update this file.

 

To correct the issue, use the following procedure:

 

Shut down ALL Oracle EPM/Hyperion services or processes.  If you don’t have a system wide stop/start script, check out our earlier post on creating this such item!  How To Create Microsoft Windows EPM/Hyperion Start and Stop Scripts

Once all services are down, locate and change the file system properties at the EssbaseJavaAPI folder level, right-click and deselect “Read-Only.”

Pic3

De-select “Read-only” and click “Apply.”

Pic4

Click “OK”

Pic5

Click “OK”

Pic6

Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).

Then you want to rollback the Analytic Provider Services (APS) Patch: 11.1.2.4.006:

For example:

opatch.bat rollback -id 22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jdk F:OracleMiddlewarejdk160_35

Type “y” when prompted and press <enter>.

Pic8

Pic9

This would be an appropriate time to go back and confirm that the ess_japi.jar is no longer set to “Read-Only.”  If it is, re-apply the same steps noted above for changing the parent folder and all sub folders/items to be “non-read only.”

Open an Administrator Windows command prompt (cmd.exe using right-click “Run as Administrator”).

Re-apply the Analytic Provider Services (APS) Patch 11.1.2.4.006:

opatch.bat apply F:OracleMiddlewareEPMSystem11R1OPatch22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jre F:OracleMiddlewarejdk160_35

Pic10

Type “y” and press <enter>.

Pic11

Pic12

Delete all of the contents of the tmp and cache directories for the APS server(s) under the WebLogic Domain.  Do NOT remove the tmp and cache folders themselves, just delete the contents.

Sample locations:

F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0tmp

F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0cache

Restart All Oracle EPM/Hyperion System services.

***NOTE***

The above procedures should be performed on ALL servers which are hosting Analytics Provider Services (APS) within the affected Oracle EPM /Hyperion System environment(s).

Test your Analytics Provider Services (APS) URL again:

http://:13080/aps/Test

The version of Analytic Provider Services should now match the JAPI version.

Analytic Provider Services – Release 11.1.2.4.006.003 , JAPI 11.1.2.4.006.003

Pic13

Re-test the Smart View connection and perform an adhoc connection to an Essbase application.  The error should no longer be present and the query should work.

Pic14

 

 

We at iArch Solutions hope you found this blog helpful. Is there a question you want answered in a blog? Send us your questions, comments and feedback.

 

APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

 

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: April 4, 2016
  • Article by: Joe Malewicki

 

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 unfortunate events.

Our Technical Managed Services support offerings provides you the freedom and confidence that you are receiving the most from your Oracle EPM and BI system.  With state of the art systems and our proven methodology we are able to proactively monitor and maintain your critical financial system.  That way, it is ALWAYS there when you need it.

Wouldn’t it be nice to have the answer to your questions, just a phone call away?  With guaranteed SLA’s and 100% on-shore staff ready to assist you, we will be answering the phone whenever you need us.  Give us a call and see how we can help you.

Learn more about iArch Solutions Oracle EPM/Hyperion Technical Managed Services

iArch Solutions Managed Services

 

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: February 9, 2015
  • Article by: Joe Malewicki

OPAS_log   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!

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: December 5, 2013
  • Article by: Joe Malewicki

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 your corporate technical support.

OK

SCREEN SHOT:

sqr-1003400-error

SOLUTION:  In the sqr.ini file for the SQR Production Reporting Engine being utilized add if missing or modify the Java Virtual Machine (JVM) memory parameters for the [Environment:Oracle] to be a greater value than the current setting.  You must restart the Reporting & Analysis Framework Services for the new setting to take effect.

In our example the user was running a report in Oracle Hyperion SQR Production Reporting which create a very large output (3000+ rows).  The settings were missing for the SQR Production Reporting engine being utilized and the report was unable to complete.

The sqr.ini file can be found on the Oracle Hyperion SQR production Reporting server for your implementation at the following location:

*** NOTE *** The example below is for a deployment using the Oracle Database for the Oracle Hyperion SQR Production Reporting engine.  Modify the path and sqr.ini file for your applicable engine.

On a Microsoft Windows platform:

C:OracleMiddlewareEPMSystem11R1productsbiplusbinSQRServerOraclebin

On a LinuxUnix platform:

/<your install location>/Oracle/Middleware/EPMSystem11R1/products/biplus/bin/SQR/Server/Oracle/bin

  1. Shutdown all of the Reporting & Analysis services or processes.
  2. Backup the current sqr.ini file.
  3. Add/modify the parameters for the [Environment:Oracle] properties:
    1. SQR_JRE_FLAGS=-XX:PermSize=256M -XX:MaxPermSize=256M -Xmn128M -Xms256M -Xmx1024M
    2. SQR_USEJVM=False
  4. Reporting & Analysis services or processes

sqr-1003400-fix

APPLICABLE VERSIONS: 11.1.1.x, 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: November 10, 2013
  • Article by: Joe Malewicki

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 the specified host/port.  Error (503).

OK

SCREEN SHOT:

smart-view-error-503

SOLUTION:  In the mod_wl_ohs.conf file add if missing or modify the parameters for the WLIOTimeoutSecs and WLSocketTimeoutSecs to be a value greater than the time needed for the query to complete.  You must restart the Oracle HTTP Server (OHS) and the WebLogic managed server for the Analytic Provider Services (APS) server for the new setting to take effect.

In our example the user was running a query in Smart View which took longer than 5 minutes to complete.  The settings were missing for the APS location handler and the Smart View query was unable to complete.

The mod_wl_ohs.conf file can be found on the WebLogic Managed server for your implementation of Analytic Provider Services (APS) at the following location:

*** NOTE *** Starting with EPM System 11.1.2.3 it is possible to use a “Shared Location” for your Oracle HTTP Server configuration.  If this is being utilized in your implementation you should check in that “Shared Location” for the mod_wl_ohs.conf file instead.

On a Microsoft Windows platform:

C:OracleMiddlewareuser_projectsepmsystem<#>httpConfigohsconfigOHSohs_component

On a LinuxUnix platform:

/<your install location>/Oracle/Middleware/user_projects/epmsystem<#>/httpConfig/ohs/config/OHS/ohs_component

  1. Shutdown the Provider Services (APS) server service or process.
  2. Backup the current mod_wl_ohs.conf file.
  3. Add/modify the parameters for the “WLIOTimeoutSecs” and “WLSocketTimeoutSecs” properties within the location section for APS:
    1. <Location Match ^/aps>
    2. SetHandler weblogic-handler
    3. WeblogicCluster <aps-server-name>:13080
    4. WLIOTimeoutSecs 1800
    5. WLSocketTimeoutSecs 1800
    6. </LocationMatch>
  4. Restart the Oracle HTTP Server and the WebLogic Managed server service or process for APS.

APPLICABLE VERSIONS: 11.1.1.x, 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: November 10, 2013
  • Article by: Joe Malewicki

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 (1024016): Request [<some-report-name>] from user [<some-user@provider-name>] was terminated since it exceeded the time limit.

OK

SCREEN SHOT:

essbase-error-1024016

SOLUTION: In the ESSBASE.CFG file remove or modify the parameter for the QRYGOVEXECTIME to be a value greater than the time needed for the query to complete.  You must restart the Essbase server for the new setting to take effect.  In our example the user has the setting currently at QRYGOVEXECTIME 45 (45 seconds) and the Smart View query was unable to complete in that requested in that amount of time.

*** Note*** This setting can be configured as an Essbase server wide setting or can be configured for individual applications.

The ESSBASE.CFG file can be found on the Essbase server:

On a Microsoft Windows platform:

C:OracleMiddlewareuser_projectsepmsystem<#>EssbaseServeressbaseserver1bin

On a LinuxUnix platform:

/<your install location>/Oracle/Middleware/user_projects/epmsystem<#>/EssbaseServer/essbaseserver1/bin

  1. Shutdown the Essbase server service or process.
  2. Backup the current ESSBASE.CFG file.
  3. Comment out or modify the following parameter:
    1. QRYGOVEXECTIME 180
  4. Restart the Essbase server service or process.

APPLICABLE VERSIONS: 9.3.x, 11.1.1.x, 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More

Blog Details Page

  • Date: November 8, 2013
  • Article by: Joe Malewicki

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:

essbase-error-1020051

SOLUTION: In the ESSBASE.CFG file add or modify the parameter for the SSPROCROWLIMIT to be a value greater than the maximum rows being requested.  You must restart the Essbase server for the new setting to take effect.  In our example the user has the setting currently at 500,000 rows and the Smart View query was trying to return 502,615 rows.

The ESSBASE.CFG file can be found on the Essbase server:

On a Microsoft Windows platform:

C:OracleMiddlewareuser_projectsepmsystem<#>EssbaseServeressbaseserver1bin

On a LinuxUnix platform:

/<your install location>/Oracle/Middleware/user_projects/epmsystem<#>/EssbaseServer/essbaseserver1/bin

  1. Shutdown the Essbase server service or process.
  2. Backup the current ESSBASE.CFG file.
  3. Add or modify the following parameter:
    1. SSPROCROWLIMIT 600000
  4. Restart the Essbase server service or process.

APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

Share me

Oracle Cloud Infrastructure Foundations 2020 Certified Associate Issued to Joe Malewicki, Jr.

  • Date: Jul 07, 2020
  • Article by: Elysha Daly
Read More

Oracle EPM 11.2.2 Dropped

  • Date: Jun 30, 2020
  • Article by: Joe Malewicki
Read More