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

  • 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 Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

How to use the Smart View Diagnostics tool

  • Date: February 29, 2016
  • Article by: Elysha Daly

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.
The Smart View Diagnostic Tool is a newer addition to Smart View release 11.1.2.3+ product line.  As each new version of Smart View is released, the abilities of the diagnostics tool often enhanced.  Consult your Smart View product ReadMe for more details on each version’s actual use of this feature.  For this article, we are demonstrating its usage with relate 11.1.2.5.520 Smart View.
You will first need to find and display the Diagnostics tools. To perform this function, once in Smart View, select “options.”  Then under Advanced > Logging, check the box “Show Diagnostic group on Smart View ribbon” and click OK.
Pic1
 
The Diagnostic tools will then be available in the menu ribbon as seen below.
Pic2
 
Your next step will be to left click on the “Start Diagnostics” option in the menu. You will be prompted to restart Office. This is highly recommended by Oracle because it allows for all the actions involved in a particular issue to be recorded from the very beginning. It is better to give them too much information rather than too little. At this point, click OK and restart Office.
Pic3
 
Now, you will see that when you restart Office, the option has changed to “Stop Diagnostics.”
Pic4
You can use the “Take Screenshot” Option at various important points during your session. Simply click “Take Snapshot.” Something to keep in mind when taking snapshots is that it takes a picture of your entire screen not just Smartview itself. Any open applications not pertaining to your issue will be captured.
The next option is “Save Document.” This should be used a few times during the diagnostic process to provide more information about your issue to Oracle. Each time the document is saved it will add a different suffix to the saved file. This prevents overwriting.
The files are saved each time to a current diagnostics session folder (see example below).  This setting can be adjusted within the Smart View options menu:
C:Usersusername.domainAppDataRoamingOracleSmartViewDiagnostics
This is a sample screen capture of the path to the folder and what you might expect to find there.
Pic4b
 
 
When you have successfully demonstrated the issue at hand, you can now create an archive. The Create Archive dialog box will be displayed when you select “Create Archive.”
 
C:UsersepmadminDocumentsSmartView_Diagnostics_2822016
Pic5
 
This is an example of the path and location of the Archived file.
Below is the standard name given to the file by default.
SmartView_Diagnostics_ddmmyyyy.zip
Pic5b
 
This diagnostic zip file is what Oracle wants to see. Make sure to add this file to your Service Request.
There is the ability to clean up your files after sending your information to Oracle. If you still have the diagnostic tool running then you can click “Clear Diagnostics Folder.” This will clear all diagnostic sessions except for the one you are currently running. When you click “Clear Diagnostic Folders” this dialog box will be displayed.
Pic6
By using the “Stop Diagnostics” option and then closing all office applications, you can now restart Smart View. Now open any Office application and use the “Clear Diagnostics Folder” to clear all diagnostic sessions including your most recently opened one.
 
APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4
 
We at iArch Solutions hope you found this blog helpful.  Is there a question you want answered in a blog?  Send us your questions at info@iarchsolutions.com.

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

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

  • Date: February 1, 2016
  • Article by: Elysha Daly

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 your windows internet explorer time out settings (ReceiveTimeout, KeepAliveTimeout, and ServerInfoTimeout).
image002
Solution:
In order to for SmartView to connect to Analytic Provider Services(APS) it uses Internet Explorer (IE).  Generally IE can have a low default time setting for obtaining the necessary data. It will display the above error message.
Enter Registry settings and increase the time allotted.

  1. Go to “Start” and Select “Run…”

image004

  1. Type “regedit” and select “OK”

image006
3.Navigate to Computer > HKEY_CURRENT_USER > Software > Microsoft > Windows > Current Version > Internet Settings
image008

  1. Select Edit > New > DWORD (32-bit) Value.

image010

  1. Right click on “New Value #1” and change it to “ReceiveTimeout”

image012
image014

  1. Right click on ReceiveTimeout and select “Modify”

image016

  1. Using the Decimal option, please enter “480000.” This corresponds to 480000 milliseconds which is equal to 8 minutes.

 
Newpic
Newpic2
 
 
image022

  1. Follow the same steps to add the parameters “ServerInfoTimeout” and “KeepAliveTimeout”  as well. For the value of the latter two parameters enter “180000.” This Decimal term is equal to 180000 milliseconds or 3 minutes.

image024
9.Close the registry window and restart services.
We hope this step by step process was helpful to you. Should you have any questions on this, or any of our other blogs, please feel free to give us a call. Check back next week with another helpful tip to keep your system stable and ensure maximum uptime.**Please note you might require local administrative privileges to perform these steps.
 
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 Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

Oracle Smart View Error 1935

  • Date: January 6, 2016
  • Article by: Joe Malewicki

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:
error
Oracle Smart View 32-bit for Office
Oracle Smart View 32-bit for Office Setup failed.
OK
error2 Continue reading

Share me

Oracle Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

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

  • 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 Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

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

  • 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 Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More

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

  • 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 Security Alert for CVE-2021-44228: Part Four

  • Date: Dec 16, 2021
  • Article by: Mike Turner
Read More

Oracle Security Alert for CVE-2021-44228: Part Three

  • Date: Dec 15, 2021
  • Article by: Jeff Henkel
Read More