3 Replies Latest reply on Oct 3, 2008 3:06 PM by 662108

    Unable to import data in FDM

    662108
      We are trying to load data into FDM and resulting in error : An error occurred importing the file . The view log is as follows what am i missing
      ** Begin FDM Runtime Error Log Entry [2008-09-26-19:08:59] **
      -------------------------------------------------------------
      ERROR:
      Code......................................... 2012
      Description.................................. File [C:\WINDOWS\TEMP\tWhyperi817271807466-SL.log] does not exist!
      Procedure.................................... clsImpProcessMgr.fLoadAndProcessFile
      Component.................................... upsWObjectsDM
      Version...................................... 931
      Thread....................................... 7180

      IDENTIFICATION:
      User......................................... hyperiondcom
      Computer Name................................ SGDHYPEAPW01
      App Name..................................... FDMDEV
      Client App................................... WebClient

      CONNECTION:
      Provider..................................... ORAOLEDB.ORACLE
      Data Server..................................
      Database Name................................ devhypsg
      Trusted Connect.............................. False
      Connect Status.. Connection Open

      GLOBALS:
      Location..................................... ORACLEGL
      Location ID.................................. 749
      Location Seg................................. 3
      Category..................................... ACTUALFDM
      Category ID.................................. 13
      Period....................................... Jan - 2008
      Period ID.................................... 1/31/2008
      POV Local.................................... False
      Language..................................... 1033
      User Level................................... 1
      All Partitions............................... True
      Is Auditor................................... False

      the user trying to do the job is from administrator group so i do not think it is a rights issue. not sure what am i missing
        • 1. Re: Unable to import data in FDM
          629764
          Hi - Here are couple of things we can check.

          1. Check if the Import Format of the location and Load File are synch.
          2. Can you tell us what is the adaptor that you are using? You can also try downloading the new adaptor and copy the content of Load Action and paste into your current adaptor.
          • 2. Re: Unable to import data in FDM
            657263
            Hello,

            Unfortunately I do not agree with the statement made by SatyaK. Importing of data into FDM has nothing to do with the adapter and the Load actions.

            What I would suggest to do is the following:

            1. Clear the User Error Log (Tools -> Clear Error Log)
            2. Reproduce the issue.
            3. View the User Error Log (Tools -> View Error Log)

            The reason is that it is sometimes 'filled' with information that might not be relevant, and you might not be looking at the very first error in the workflow. So therefore you could be looking at something totally irrelevant.

            Secondly .... I would suggest to do this as well.... review the Import Log
            1. Import Fish (should be white)
            2. View Options Tab
            3. View Log button

            As you go through the log, it will tell you how many records it found, how many it was told to skip, etc. Sometimes when this error occurs it is because the total number of 'valid' records, was zero. Therefore there was nothing to insert into the database. If this is the case, then you will need to update your import format accordingly.

            Thank you.
            • 3. Re: Unable to import data in FDM
              662108
              Thanks for the help, the problem is resolved. In our case there were 2
              oracle homes and our application server Oracleias was pointing to a
              oracle home where sqlldr was not installed. We changed this and that
              resolved the issue.