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

OWSM Blog Part 1 – Installation and Configuration of DRM Web Services API with Oracle EPM 11.2

  • Date: Nov 18, 2020
  • Article by: Brad Spelman
Read More

October Patch Updates Breaks Shared Services. 11.1.2.4.x

  • Date: Oct 28, 2020
  • Article by: Jeff Henkel
Read More