This discussion is archived
11 Replies Latest reply: Sep 11, 2013 7:22 AM by JeffJon RSS

FDM Import error from ERPI

dwhpc Journeyer
Currently Being Moderated

Hi All,

 

While importing data from FDM-->Import, i am getting below error. Please suggest me to move forward. I have granted full access control to FDM application folder, still i am getting below error.

 

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

*** clsGetFinData.ExecuteCOMJNI @ 9/10/2013 3:34:58 PM ***

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

System.NullReferenceException: Object variable or With block variable not set.

   at Oracle.Erpi.ErpiFdmCommon.InitializeEx()

   at fdmERPIfinE1.clsGetFinData.ExecuteCOMJNI(String CurrentUser)

 

 

CurrentUser = admin

m_strSSOToken = HfhntJ+rYdQcv4z41ffRyKbQBSDJ/pXcX2+JanMwXODpCUciLmw4QZ8c6jp9LkVs4XMWEKxMZroc

YIxCSmZnEUkcxZ8e6+YCH/rc1yfJAU5Vwklk28c6UZApQU0M+C3UuPQWVXshhMJ1OPY4HXXkucIo

mq010xIVSf7SPuuBBJiXJO04ZG2t5N8ZGWZnCAQcDOT2TAAP/TX3IlpjsuQyzPujFAxPVZzbXAuR

aHMMdncgqyiY7XxkYBFG6ci6BLWCWZCts8cUscvSxVoVitk36HsuUNp+20WuAOc/d2dtid+EkX3p

44oRTve7b+zXDu1axug1JuW8Ght0YoAo8cl4Ew==

m_ERPIdbConnString =

m_ERPIdbUserID =

m_ERPIdbPassword.Length = 0

  • 1. Re: FDM Import error from ERPI
    JeffJon Expert
    Currently Being Moderated

    What shows in the import screen in FDM when the import is ran?

     

    Based on the log, it looks like the adapter may not be properly registered/configured.

     

    Was the ERPi-Fin-E1.dll and .tlb placed in the same directory and registered successfully?    

  • 2. Re: FDM Import error from ERPI
    dwhpc Journeyer
    Currently Being Moderated

    Hi JeffJon,

     

    Thank you for your prompt reply.

     

    Yes, i kept both the files on the below directory and registered the same.

     

    D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents

     

    FDM Import Error:

     

    Error: Import failed. Invalid data or Empty content.

     

     

     

    Connect failed. See adapter log.

     

    Adapter Log:

     

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

    *** clsGetFinData.ExecuteCOMJNI @ 9/10/2013 3:34:58 PM ***

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

    System.NullReferenceException: Object variable or With block variable not set.

       at Oracle.Erpi.ErpiFdmCommon.InitializeEx()

       at fdmERPIfinE1.clsGetFinData.ExecuteCOMJNI(String CurrentUser)

     

     

    CurrentUser = admin

    m_strSSOToken = HfhntJ+rYdQcv4z41ffRyKbQBSDJ/pXcX2+JanMwXODpCUciLmw4QZ8c6jp9LkVs4XMWEKxMZroc

    YIxCSmZnEUkcxZ8e6+YCH/rc1yfJAU5Vwklk28c6UZApQU0M+C3UuPQWVXshhMJ1OPY4HXXkucIo

    mq010xIVSf7SPuuBBJiXJO04ZG2t5N8ZGWZnCAQcDOT2TAAP/TX3IlpjsuQyzPujFAxPVZzbXAuR

    aHMMdncgqyiY7XxkYBFG6ci6BLWCWZCts8cUscvSxVoVitk36HsuUNp+20WuAOc/d2dtid+EkX3p

    44oRTve7b+zXDu1axug1JuW8Ght0YoAo8cl4Ew==

    m_ERPIdbConnString =

    m_ERPIdbUserID =

    m_ERPIdbPassword.Length = 0

     

    Thanks,

    Prakash

  • 3. Re: FDM Import error from ERPI
    JeffJon Expert
    Currently Being Moderated

    How many FDM application servers exist in the environment?

     

    Has the ERPi Data Load Rule been populated in "Integratino Option 1" in the location being used to run the import?

    Has the adapter options been set as required?    

  • 4. Re: FDM Import error from ERPI
    dwhpc Journeyer
    Currently Being Moderated

    Thank you for your prompt reply.

     

    Yes, only one application. I have migrated the same from PROD to UAT.

     

    Integrated Option 1 - 3000

    Adapter Option - ERPI_1

     

    Thanks,

    Prakash

  • 5. Re: FDM Import error from ERPI
    JeffJon Expert
    Currently Being Moderated

    At this point I would need to look at the environment to have a better idea.

     

    You will need to open a service request with Oracle Support.    

  • 6. Re: FDM Import error from ERPI
    dwhpc Journeyer
    Currently Being Moderated

    I have open the SR and had the webex session. They are looking into the issues.

     

    I will keep you posted, once i have get the solution from ORACLE.

     

    Thanks,

    Prakash

  • 7. Re: FDM Import error from ERPI
    dwhpc Journeyer
    Currently Being Moderated

    ERPI - 11.1.2.2.300

    Source System : SAP

     

    We have kept FDM and ERPI in a different server, would like to know is there any addition setting is required to move forward. I did the additional configuration(created DB link and Synonyms - as per latest patch document)

     

    In my current scenario, ERPI Staging table(TDATASEG) holding the data, while importing the same to FDM, we are getting the above error.

     

    Thanks,

    Prakash

  • 8. Re: FDM Import error from ERPI
    dwhpc Journeyer
    Currently Being Moderated

    Hi Gurus,

     

    Is there any clue or suggestions? For testing purpose, i have tried to import the flat file to FDM, but it throws the below error.

     

    FDM Flat file Import Error:

              Error: Import failed.Invalid data or Empty content.

     

    2013-09-11 18:40:31

     

     

    User ID........... admin

    Location.......... E210000

    Source File....... D:\FDMApplications\FDMUAT\Inbox\E210000\xxxxx.dat

     

     

    Processing Codes:

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

    BLANK............. Line is blank or empty.

    ESD............... Excluded String Detected, SKIP Field value was found.

    NN................ Non-Numeric, Amount field contains non numeric characters.

    RFM............... Required Field Missing.

    TC................ Type Conversion, Amount field could be converted to a number.

    ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.

     

     

     

     

     

    Excluded Record Count..............11

    Blank Record Count.................2

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

    Total Records Bypassed.............13

    Valid Records......................0

    Total Records Processed............13

     

     

    Begin Oracle (SQL-Loader) Process (0): [2013-09-11 18:40:31]

     

     

    Oracle (SQL-Loader) Log File Contents:

     

     

     

     

    SQL*Loader: Release 11.2.0.1.0 - Production on Wed Sep 11 18:40:31 2013

     

     

    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

     

     

    Control File:   C:\Users\EPM\AppData\Local\Temp\tWadmin891290003830.ctl

    Character Set UTF16 specified for all input.

    Using character length semantics.

    First primary datafile C:\Users\EPM\AppData\Local\Temp\tWadmin891290003830.tmp has a

    little endian byte order mark in it.

     

     

    Data File:      C:\Users\EPM\AppData\Local\Temp\tWadmin891290003830.tmp

      Bad File:     C:\Users\EPM\AppData\Local\Temp\tWadmin891290003830.bad

      Discard File:  none specified

     

    (Allow all discards)

     

     

    Number to load: ALL

    Number to skip: 0

    Errors allowed: 50

    Continuation:    none specified

    Path used:      Direct

     

     

    Load is UNRECOVERABLE; invalidation redo is produced.

     

     

    Table TWADMIN891290003830, loaded from every logical record.

    Insert option in effect for this table: APPEND

    TRAILING NULLCOLS option in effect

     

    Thanks,

    Prakash

  • 9. Re: FDM Import error from ERPI
    JeffJon Expert
    Currently Being Moderated


    Every record in the source file is being skipped

     

    Excluded Record Count..............11

    Blank Record Count.................2

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

    Total Records Bypassed.............13

    Valid Records......................0

    Total Records Processed............13

     

    This would indicate that your import format is not correct for the source file.

  • 10. Re: FDM Import error from ERPI
    dwhpc Journeyer
    Currently Being Moderated

    Hi JeffJon,

     

    Thank you for your prompt reply.

     

    Thank you for your clue, i have mentioned the wrong delimiter between the Source file and Import format. After correcting that, we can able to import the flat file in to FDM. But still we are getting error while import the data from ERPI to FDM.

     

    Thanks,

    Prakash

  • 11. Re: FDM Import error from ERPI
    JeffJon Expert
    Currently Being Moderated

    I would recommend re-registering the ERPi-Fin-E1 adapter in the FDM application and re-creating the import format for the location with the adapter assigned.    

Legend

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