This discussion is archived
13 Replies Latest reply: Nov 11, 2013 10:56 PM by PLIM RSS

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

PLIM Newbie
Currently Being Moderated

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 Pro
    Currently Being Moderated

    Hi,

     

    can you paste error log please?

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

    ** 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 Pro
    Currently Being Moderated

    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 Expert
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Pro
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Expert
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points