After applying Analytics Provider Services Patch Prepare Update (PSU) eleven.1.2.4.006 we can no longer perform an adhoc analysis to an Essbase application. The post-obit error is thrown within of Microsoft Excel with the Smart View add together-in:Error:---------------------------Oracle Smart View for Role---------------------------com/essbase/services/olap/grid/EssGGridOption.setOptionSingleMbrPov(Ljava/lang/Boolean;)5---------------------------OK---------------------------Screen Shot of Error:
To confirm if in that location is an effect with the Provider Services (APS) patch you can run a exam to confirm the version details for the Provider Services JAPI:http://:13080/aps/TestThe version of Analytic Provider Services should match the JAPI version. Our exam showed a discrepancy:Analytic Provider Services - Release 11.one.two.4.006.003 , JAPI xi.i.two.three.4408 
This issue is existence caused by the ess_japi.jar file being a "Read-Only" file. When the new patch was applied information technology could not update this file. To correct the event, use the post-obit procedure: Shut downwardly ALL Oracle EPM/Hyperion services or processes. If you don't take a system wide end/start script, check out our earlier post on creating this such item! How To Create Microsoft Windows EPM/Hyperion Start and Stop ScriptsOnce all services are down, locate and modify the file system properties at the EssbaseJavaAPI folder level, right-click and deselect "Read-Merely."
De-select "Read-simply" and click "Apply."
Click "OK"
Click "OK"
Open up an Administrator Windows command prompt (cmd.exe using right-click "Run as Ambassador").And so you desire to rollback the Analytic Provider Services (APS) Patch: eleven.1.2.iv.006:For case:
opatch.bat rollback -id 22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jdk F:OracleMiddlewarejdk160_35
Blazon "y" when prompted and press <enter>.
This would be an appropriate time to become dorsum and ostend that the ess_japi.jar is no longer set to "Read-But." If it is, re-apply the aforementioned steps noted higher up for irresolute the parent binder and all sub folders/items to be "not-read merely."Open an Administrator Windows command prompt (cmd.exe using right-click "Run every bit Administrator").Re-apply the Analytic Provider Services (APS) Patch xi.1.two.iv.006:
opatch.bat apply F:OracleMiddlewareEPMSystem11R1OPatch22204266 -oh F:OracleMiddlewareEPMSystem11R1 -jre F:OracleMiddlewarejdk160_35
Type "y" and press <enter>.
Delete all of the contents of the tmp and enshroud directories for the APS server(s) under the WebLogic Domain. Exercise NOT remove thetmp andcache folders themselves, just delete the contents.Sample locations:
F:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0tmpF:OracleMiddlewareuser_projectsdomainsEPMSystemserversAnalyticProviderServices0cache
Restart All Oracle EPM/Hyperion Organisation services.***Note***The in a higher place procedures should be performed on ALL servers which are hosting Analytics Provider Services (APS) within the afflicted Oracle EPM /Hyperion Arrangement environs(south).Exam your Analytics Provider Services (APS) URL again:http://:13080/aps/TestThe version of Analytic Provider Services should now match the JAPI version.Analytic Provider Services - Release eleven.1.2.4.006.003 , JAPI 11.1.2.4.006.003 
Re-test the Smart View connection and perform an adhoc connection to an Essbase awarding. The error should no longer be present and the query should work.
We at iArch Solutions hope yous found this web log helpful. Is in that location a question yous desire answered in a blog? Send us your questions, comments and feedback. Applicable VERSIONS: 11.ane.2.0, eleven.i.2.1, 11.ane.2.two, 11.1.2.three, 11.one.2.4
0 Response to "How To Register Essbase Server In Aps Provider Services"
Post a Comment