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!
Posted by at
Labels: , , , , ,

8 comments:

  1. Karin AungerJanuary 30, 2020 at 6:42 AM

    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. Dave ShayJanuary 30, 2020 at 9:37 AM

      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. Dave ShayJanuary 30, 2020 at 9:39 AM

      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. Karin AungerJanuary 31, 2020 at 3:59 AM

      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
  2. Francisco Amores (@akafdmee)May 4, 2020 at 10:30 AM

    Hello,
    Good stuff. Testing adapters in in my To-DO list.
    ODI is now 12c so adapters must be reconfigured as well.
    Will keep you posted.
    Thanks

    ReplyDelete
  3. E13elApril 21, 2021 at 7:57 AM

    Plan is to upgrade to 11.2, using JDE adapter as described above. Can anyone confirm that the adapter works in the latest version of 11.2 by copying over the adapters and redeploying?
    Thanks!

    ReplyDelete
    Replies
    1. Dave ShayApril 27, 2021 at 1:34 PM

      Deleted this by accident, so re-posting.

      Hi! I've learned the upgrade process for FDMEE+ODI is extremely customer-specific. Some have been flawless, and others required rebuilding ODI from scratch.

      The SQL-to-SQL adapter is especially problematic. Oracle posted a knowledge base article about it just within the past 2 weeks. Here's the main bit to be aware of:

      If your FDMEE process uses a filter in the Parameter column in the Source Adapter, ODI 12c does not like if the Parameter name is exactly the same as the table column name. You have to manually wipe it out, and recreate it with a different Parameter name.

      For example, suppose your source table has a column named ENTITY and your FDMEE source adapter has a parameter in 11.1.2.4 that was named Entity and it always worked..... guess what you get to do in 11.2 / ODI 12.c. You delete it and recreate the parameter name as Entity_P or something like that.

      Delete
  4. ShivaApril 28, 2021 at 4:05 AM

    Hi,

    Nice blog. We are upgrading Hyperion 11.1.2.4 to Hyperion 11.2.x and also standalone ODI from 11.1.1.7 to 12c. Oracle said that any version of ODI is not supported for Hyperion 11.2 versions and to use FDMEE.

    In the current process, metadata and data comes to Hyperion through ODI. From Hyperion data goes to OBIEE through ODI. Our client don't want to completely cutoff ODI. Hence, we are looking for a way to use the current data flow. Like, using an adapter for FDMEE to connect to ODI to bring in metadata and data from ODI and to send data to ODI.

    It would be great if you can suggest a way to achieve this.

    Thanks

    ReplyDelete

Thank you very much for your interest in this blog! I hope you're finding it helpful.

Please keep comments relevant to the topic in the post, as this blog is not a free-for-all substitute for Oracle Support or traditional consulting. If you have many questions unrelated to the specific topic at hand, consider contacting me on LinkedIn (https://www.linkedin.com/in/daveshay) so we may discuss the possibility of consulting.

Commenting on posts older than 90 days unfortunately goes into moderation, thanks to spammers who've been hitting this blog. Please have patience, and thanks for your understanding!

Comments including URLs linking back to gambling or other things unrelated to Oracle EPM will be deleted on sight. If you're an EPM consultant and are offering me constructive criticism or a tip, go ahead and DO link back to your blog or firm's website if you so desire.

Thanks again for reading!

Subscribe to: Post Comments (Atom)