Essbase patch update


    Hi All,


    I got below error when trying to zoom in a column in smart view.

    Essbase error (1013295) .Server request fails with error code 1 .

    Looks like I need to install a patch for this as per oracle . (Patch for Analytical service provider)

    I am on version.

    The read me suggests that I need to update Essbase as well.

    Can someone please help me here what are the things I need to install and the procedure.


    I will be doing this very first time , so please help me here.


    - Many Thanks

      • 1. Re: Essbase patch update

        You need to download the patches (for your operating system) from Oracle Support which I assume you have already done. Detailed instructions for applying the patch (using the opatch utility) are contained in the patch ReadMe file.


        If this is a production environment make sure you have a good backup.

        • 2. Re: Essbase patch update

          If you are applying patches then each of the Essbase products should be on the same patch version unless started otherwise in the readme.

          If you want a list of the latest Essbase product patches you should apply then go to

          The readme should be clear enough on the process you should follow.





          • 3. Re: Essbase patch update



            As John Suggested, the Read me doc should be sufficient. However, before you proceed Stop all the EPM Services and take a back up of OPatch folder.      


            Also confirm if this a distributed environment.

            • 4. Re: Essbase patch update



              Yes it's a distributed environment. One server for Essbase and another for Foundation services.



              • 5. Re: Essbase patch update

                Compile a list of the required patches, I have provided a link to the Essbase related ones, go through the ReadMe of each patch carefully and carry out all steps.

                If your have a two servers then then the simplest way is to apply the patches to both servers, if the patch is not required it will not apply.

                • 6. Re: Essbase patch update



                  Although its not mandatory it is always recommended to have EAS, APS and ESSBASE on the same patch level.


                  As you are saying distributed installation,


                  If EAS is installed on a different server than Essbase you need to apply ESSBASE RTC patch on EAS server as well.

                  • 7. Re: Essbase patch update

                    Ok, thank you all for helping me on this.

                    So I will apply this patch on Essbase, EAS, APS as per below oracle link.


                    I have downloaded the patch for Essbase and on Read me I found the below.


                    The section includes important information about applying this patch for Essbase.


                    Patch ID

                    Essbase Client MSI (Windows)


                    Essbase Client (OPatch)


                    Runtime Client


                    Essbase Server



                    I have a little doubt here.What does this Essbase client(OPatch) means . Do I need to to install this as well.

                    My environment is Windows server 2012.



                    Appreciate for any help.

                    Thank you !

                    • 8. Re: Essbase patch update

                      If you are going to apply patches then I recommend considering the latest set which is as lots have bugs have been addressed between 013 and 023.

                      Don't worry about the client, focus on Essbase Server, RTC, APS and EAS, Studio (if you have it)

                      • 9. Re: Essbase patch update

                        Thank you so much John, I will accept you recommendation and apply the latest patch only.

                        What are the things I need to take back up before I apply the patch.



                        -Many Thanks

                        • 10. Re: Essbase patch update

                          I assume you are already taking backups as part of a backup strategy, make sure you have backups of the Essbase apps, sec file, such as a file system backup.

                          1 位用户发现它有用
                          • 11. Re: Essbase patch update

                            Hi John,


                            I found some issues in .23 patch (In Essbase Read me) which we use in our Applications.

                            Can you please suggest any stable release.


                            - Many Thanks



                            Dim build setting "allow move" is not allowed

                            Dim build setting "allow move" (for moving a member to another parent) is
                            not allowed, regardless of the uniqueness defined at the generation level.


                            Issue with @PARENTVAL() Function

                            When a calculation formula associated with sparse member assigns a dynamic parent value to a stored child member through @PARENTVAL it may produce a #Missing result. To get the correct result the formula needs to be executed attaching to a dense member.


                            Essbase Administration Services Server Can Terminate Abnormally After Updating the Outline

                            If EAS server crashes upon "Update Outline" and if the JRE used is jrockit, add the option -Xss1m in at< EPM_ORACLE_INSTANCE>/bin/deploymentScripts>.
                            The default size of a thread stack in jrockit is 320K for win64 and 1M for linux64. So, set the -Xss value accordingly. 


                            • 12. Re: Essbase patch update

                              There are always going to be issues with any patch release, that is the way it goes.

                              Usually patches are installed to a dev/test environment first and regression testing is carried out before deciding to apply to a prod environment.

                              Patches can always be rolled back.

                              The choice is yours which patch release you go for.

                              • 13. Re: Essbase patch update



                                Please check the read me of the lower patches, if the known issues of Patch .023v are concerning to your environment.


                                However, as suggested it is always better to be on the higher patch version of any component.

                                As you are on distributed environment, please let us know, what component is installed on which server.  We can suggest you if required.


                                - Adding on  -

                                If you have to apply the patches on more than one servers then apply the patches servers, if the patch is not required on server it will not apply on that server.


                                OPatch is the mainly the folder to be backed up. The read me contains the details of How to Roll back the applied patch please check.






                                • 14. Re: Essbase patch update

                                  Hi John,


                                  After going through all patch Read me docs I decided to choose patch .013.

                                  When I read the EAS patch doc , it's written that .11 is not supported and I am  on version.

                                  I went through all patch docs but did not find any EAS patch supporting EAS .11.


                                  Can you please suggest or  am I doing something wrong .


                                  Supported Paths to this Patch

                                  You can apply this patch to the following releases:

                                  1 2 3 上一个 下一个