Wednesday, January 29, 2020

Having FDMEE 11.2 Adapter Troubles?

Having stood up EPM 11.2.0.0 with HFM, Essbase, Planning, FDMEE and all the trimmings, I'm starting to go crawl through the back-end logs for the various modules and am.... finding things.

Here's one that struck me:

\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\aif\aif-localization.log

[timestamp] Starting import of the adapters.
[timestamp] [erpi] [ERROR] [] [oracle.erpi.localization] [tid: 1] [ecid: 07669c97-8ef1-4a3c-aa80-8e1c25fcd267-00000002,0] Error incountered while importing adapters.[[
java.lang.RuntimeException: Either directory F:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.1.2.4.00\adapters does not exist or is not a directory
    at com.hyperion.aif.install.AdapterImport.main(AdapterImport.java:78)
]]
This entry happens to be the very first thing we see within the log.  The [timestamp] just so happens to correspond with the first-time DB Config and WebLogic deployment of FDMEE.

Bear in mind the configtool's graphical interface did not report any errors here.  Config/Deploy status for FDMEE was given a green checkmark.

Now, does the directory \Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.1.2.4.00\adapters actually exist?  Of course not!  We're installing EPM 11.2.0.0.

And guess what?  Directory \Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.2.0.0\adapters does exist and I see adapter XML files in there for JDE and Open Interface.

So I rolled the dice, created an empty directory \Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.1.2.4.00 and copied 11.2.0.0\adapters to 11.1.2.4.00\adapters.

Just to be on the safe side, I used epmsys_registry.bat command-line options to blow away the FDMEE stuff from the EPM System Registry, so I could return to configtool and run a fresh DB config and deploy for FDMEE.

This time around, no errors in aif-localization.log and the adapter imports were reported as a success:

[new timestamp] [erpi] [NOTIFICATION] [] [oracle.erpi.localization] [tid: 1] [ecid: 29cae779-08ae-4e92-a5c8-df87557c5c15-00000002,0] Starting import of the adapters.
[new timestamp] [erpi] [NOTIFICATION] [] [oracle.erpi.localization] [tid: 1] [ecid: 29cae779-08ae-4e92-a5c8-df87557c5c15-00000002,0] Importing adapter F:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.1.2.4.00\adapters/JDE_Adapter.xml
[new timestamp] [erpi] [NOTIFICATION] [] [oracle.erpi.localization] [tid: 1] [ecid: 29cae779-08ae-4e92-a5c8-df87557c5c15-00000002,0] Finished Importing adapter F:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.1.2.4.00\adapters/JDE_Adapter.xml
[new timestamp] [erpi] [NOTIFICATION] [] [oracle.erpi.localization] [tid: 1] [ecid: 29cae779-08ae-4e92-a5c8-df87557c5c15-00000002,0] Importing adapter F:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.1.2.4.00\adapters/Open_Interface_Adapter.xml
[new timestamp] [erpi] [NOTIFICATION] [] [oracle.erpi.localization] [tid: 1] [ecid: 29cae779-08ae-4e92-a5c8-df87557c5c15-00000002,0] Finished Importing adapter F:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.1.2.4.00\adapters/Open_Interface_Adapter.xml
[new timestamp] [erpi] [NOTIFICATION] [] [oracle.erpi.localization] [tid: 1] [ecid: 29cae779-08ae-4e92-a5c8-df87557c5c15-00000002,0] Finished importing all adapters.
I'm curious to know if anyone out there has tried to use FDMEE 11.2.0.0 yet and ran into trouble using either the JDE or Open Interface adapters.  If so, please post your observations, then try the above and advise our readers if this info helped!

4 comments:

  1. Hi Dave, yes we started testing FDMEE 11.2, not specifically with JDE adapter though. But in our system, we see the correct path and the JDE_Adapter file below it, in D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.2.0.0\adapters
    and we do not have that \odi\11.1.2.4 folder you mention.
    the Open_Interface_Adapter.xml is also there in the above mentioned 11.2.0.0\adapters folder.

    ReplyDelete
    Replies
    1. Hi Karin. Yes, this is exactly what I'm talking about. Please check the top few lines of \Oracle\Middleware\user_projects\\diagnostics\logs\aif\aif-localization.log on your FDMEE server(s) for the error I mentioned.

      The config tool seems to expect the 11.1.2.4 folder to be present, likely due to a bug.

      Best of luck in your testing!

      Delete
    2. Put your EPM Instance name "epmsystem1" or whatever in between user_projects\ and diagnostics\ :) The comment editor didn't like how I noted that in my comment above!

      Delete
    3. thanks Dave. We have actually been testing 11.2 EPM most products (migrated apps/data from .1.2.4) for over 3 weeks now and issues to fix were more of functional nature for data export / scripts.
      I have tracked down/compared the aif localization log steps from .1.2.4 with 11.2 and found that the "importing adapters" did put the JDE and Open.. adapter XMLs and their assocated files correctly into Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.2.0.0\masterrep and Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\odi\11.2.0.0\workrep in the same way for 11.2 as they are present for .1.2.4
      nothing seems to be missing there. Also in ODI studio and console, we were able to see the oracle JDE data server for example.
      Don't think any need for reconfig there.

      Delete