11 Replies Latest reply: Sep 11, 2013 9:22 AM by JeffJon RSS

    FDM Import error from ERPI

    dwhpc

      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

          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

            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

              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

                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

                  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

                    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

                      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

                        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


                          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

                            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

                              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.