13 Replies Latest reply on Nov 12, 2013 6:56 AM by PLIM

    File not found: esbapin At Line: 124 but after successful loads

    PLIM

      Hi all

       

      I know this is a common error people are getting with FDM, but the issue I am facing is a bit different to the ones I have found on the forum / KB / community websites.

       

      We have just upgraded to 11.1.2.2 from 11.1.1.3 via a fresh install / migration, and we are getting the File not found: esbapin At Line: 124 error. However, the difference for us is that we get it after we have run some successful loads. Sometimes we can get in a few single period loads, or a multi load, but without fail, usually after the server idles for a while, the next load we do gives us this error. Its not consistent either, it fails regularly after one successful multiload, but not all the time. Running single period loads keeps the server stable for longer. Yesterday I managed to get 4 successful multiloads before it failed. And the only way I can get it to work again is to reboot the FDM server.

       

      I have tried:

      1) checking and setting the environment variables based on all the articles / forum listings. So that is with and without the ARBORPATH variable, with and without user variables for ARBORPATH and ESSBASEPATH, we have set the path (and re-registered the adapter) to the D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0 folder, we have also set it to the D:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient-32 folder. We have adjust the Path variable too, and changed the order of it based on the different articles. All with server reboots after the change.

      2) we have reinstalled the essbase 32 client on the machine

      3) we have tried the upsES11XG4K and upsES11XG4J adapter

      4) we have been able to make the error occur through FDM web, FDM Task Manager and upsshell batch calls. We have also ensure FDM Task Manager service is not started when we run upsshell batch.

      5) Seemingly no related errors are coming through the system logs (application / system)

      6) We get this error on both the DEV and TEST environments

       

      In all cases, prior to the first load, I always go into Workbench and go to the Adapter and make sure that I can browse the target dimension and I go into the FDM Web Control Tables and make sure I can browse members. After the error occurs, when trying to go to the Control Tables again, we get the "Unable to retrieve system data" error. We only have 1 FDM server so its not related to load balancing etc.

       

      I'm really pulling my hair out for this one, and our decision to go live with this upgrade happens next week. Just wondering if anyone has experienced this before, or has any suggestions on what to try?

       

      Thanks!

        • 1. Re: File not found: esbapin At Line: 124 but after successful loads
          Francisco Amores

          Hi,

           

          can you paste error log please?

          • 2. Re: File not found: esbapin At Line: 124 but after successful loads
            PLIM

            ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-11-08-03:15:45] **

            -------------------------------------------------------------

            Error:

            Code..............48

            Description.......File not found: esbapin

            Procedure.........clsHPConnection.fConnect

            Component.........upsES11XG4K

            Version...........100

            Thread............4868

             

             

            Identification:

            User..............admin

            Computer Name.....MELMD0090

             

             

            Essbase Connection:

            App Name..........BUPA

            DB Name...........Consol

            Server Name.......MELMD0091

            Connect Status.... No Connection Open

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-11-08 03:15:45] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 48

            Description...................................... File not found: esbapin

            At Line: 124

            Procedure........................................ clsBlockProcessor.ActConnect

            Component........................................ upsWBlockProcessorDM

            Version.......................................... 1112

            Thread........................................... 2184

             

             

            IDENTIFICATION:

            User............................................. admin

            Computer Name.................................... MELMD0090

            App Name......................................... BupaCon

            Client App....................................... BatchEngine

             

             

            CONNECTION:

            Provider......................................... ORAOLEDB.ORACLE

            Data Server......................................

            Database Name.................................... HPFDMD01

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... PEOPLESOFTGL_BAL

            Location ID...................................... 757

            Location Seg..................................... 8

            Category......................................... ACTUAL

            Category ID...................................... 12

            Period........................................... Jan - 2013

            Period ID........................................ 1/31/2013

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-11-08 03:15:46] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 48

            Description...................................... File not found: esbapin

            At Line: 124

            Procedure........................................ clsBlockProcessor.ActLoad

            Component........................................ upsWBlockProcessorDM

            Version.......................................... 1112

            Thread........................................... 2184

             

             

            IDENTIFICATION:

            User............................................. admin

            Computer Name.................................... MELMD0090

            App Name......................................... BupaCon

            Client App....................................... BatchEngine

             

             

            CONNECTION:

            Provider......................................... ORAOLEDB.ORACLE

            Data Server......................................

            Database Name.................................... HPFDMD01

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... PEOPLESOFTGL_BAL

            Location ID...................................... 757

            Location Seg..................................... 8

            Category......................................... ACTUAL

            Category ID...................................... 12

            Period........................................... Jan - 2013

            Period ID........................................ 1/31/2013

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

             

             

             

             

            ** Begin FDM Runtime Error Log Entry [2013-11-08 03:15:46] **

            -------------------------------------------------------------

            ERROR:

            Code............................................. 48

            Description...................................... File [21102013~PEOPLESOFTGL_BAL~Actual~Jan-2013~RR.txt] Caused Error: (File not found: esbapin

            At Line: 124)

            Procedure........................................ clsBatchLoader.mFileCollectionProcessML

            Component........................................ upsWBatchLoaderDM

            Version.......................................... 1112

            Thread........................................... 2336

             

             

            IDENTIFICATION:

            User............................................. admin

            Computer Name.................................... MELMD0090

            App Name......................................... BupaCon

            Client App....................................... WebClient

             

             

            CONNECTION:

            Provider......................................... ORAOLEDB.ORACLE

            Data Server......................................

            Database Name.................................... HPFDMD01

            Trusted Connect.................................. False

            Connect Status.. Connection Open

             

             

            GLOBALS:

            Location......................................... PEOPLESOFTGL_BAL

            Location ID...................................... 757

            Location Seg..................................... 8

            Category......................................... ACTUAL

            Category ID...................................... 12

            Period........................................... Jan - 2013

            Period ID........................................ 1/31/2013

            POV Local........................................ False

            Language......................................... 1033

            User Level....................................... 1

            All Partitions................................... True

            Is Auditor....................................... False

            • 3. Re: File not found: esbapin At Line: 124 but after successful loads
              Francisco Amores

              After the error occurs, if you log off from FDM and log on again, is the error happening again?

               

              Are you using unified or global logon method? is your machine profile setup with any user?

               

              Are you drilling-through after loading data?

              • 4. Re: File not found: esbapin At Line: 124 but after successful loads
                JeffJon

                Has the Essbase Adapter .exe been registered in the same location as the esbapin.dll file

                 

                Should be Oracle\Middleware\EPMsystem11R1\Common\EssbaseRTC\11.1.2.0\bin    

                 

                if it is not registered in this location, it should be copied to this location and re-registered.    

                • 5. Re: File not found: esbapin At Line: 124 but after successful loads
                  PLIM

                  Hi F.Amores

                   

                  Yes this does not seem related to whether I am logged on or not. Once I receive the error (whether through FDM web, upsshell batch or FDM task manager), I can keep getting the error with any other method.

                   

                  I am using the global logon method with the admin account enter, and the machine profile is using the same login.

                   

                  No we have not set up drill through, and this option is disabled in the adapter config.

                   

                  Thanks

                  • 6. Re: File not found: esbapin At Line: 124 but after successful loads
                    PLIM

                    Hi JeffJon

                     

                    Yes the essbase adapter has been registered to the same location as the esbapin.dll file. The two locations we have used are D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0 folder, we have also set it to the D:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient-32 folder. Each time, we re-register the adapter to the correct location, and update the environment variables to reflect this change as well. And then we reboot to ensure the environment variables have been set properly.

                     

                    Thanks

                    • 7. Re: File not found: esbapin At Line: 124 but after successful loads
                      user10757003

                      Is FDM or Essbase (or both) on clustered servers? If FDM is clustered, then (from memory) the adaptor needs to be registered on each server in the cluster. (I had a similar issue loading to HFM earlier this year).

                      • 8. Re: File not found: esbapin At Line: 124 but after successful loads
                        PLIM

                        Hi user10757003

                         

                        Thanks for the suggestion but no, neither server is clustered.

                        • 9. Re: File not found: esbapin At Line: 124 but after successful loads
                          Francisco Amores

                          Try to use unified method, remove logon details from machine profile.

                           

                          Then try to reproduce the issue with admin user.

                           

                          Rgds

                          • 10. Re: File not found: esbapin At Line: 124 but after successful loads
                            PLIM

                            Thanks F.Amores. I changed the settings, and still got the error using the admin logon. 

                            • 11. Re: File not found: esbapin At Line: 124 but after successful loads
                              JeffJon

                              You want to register the adapter in this location:

                               

                              D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin folder

                               

                              Also, this should be done on each FDM application server in the environment.      

                              • 12. Re: File not found: esbapin At Line: 124 but after successful loads
                                PLIM

                                Thanks JeffJon, I can confirm that its set to this location for both environments already.

                                • 13. Re: File not found: esbapin At Line: 124 but after successful loads
                                  PLIM

                                  Just an update to this - it seems that when we get the error, the way to rectify this is to restart the Planning service, which resides on the same server as FDM.

                                   

                                  In older releases, I know that it is mentioned to keep FDM separate from Planning (because of Weblogic), but in 11.1.2 documentation it does not exist. Our implementer says that this co-existence issue was resolved in System 11. He also said that Oracle recommend a product based architecture with System 11.1.2 rather than a tiered architecture. So our current architecture is:

                                  Web server:

                                  Foundation

                                  Reporting & Analysis Framework

                                  Calc Manager

                                   

                                  App server:

                                  EAS

                                  APS

                                  FDM

                                  Planning

                                   

                                  DB server:

                                  Essbase

                                   

                                  To separate FDM from Planning will require more time and messing around, so before we tried this, I am wondering can anyone confirm whether it IS a problem to have FDM and Planning on the same server? Our plan is to move Planning to the Web Server.