8 Replies Latest reply on May 11, 2015 1:35 PM by Francisco Amores

    FDMEE - unable to load an erronous file

    981699

      Hello,

       

      I created an HFM and FDMEE application.

      I was able to load a flat file, whose dimensions' values were identical to the metadata.

       

      I tried loading a file with values that are not in metadata, to see a validation report, but I keep getting this:

       

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

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

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

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

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

      SKIP FIELD.............. SKIP field value was found

      NULL ACCOUNT VALUE.............. Account Field is null

      SKIP FROM SCRIPT.............. Skipped through Script

       

       

       

       

      [TC] - [Amount=NN]   L 0 1 0 8 1 4 0 1 4 0 , 1 1 1 0 1 0 0 0 , [ I C P   N o n e ] , [ N o n e ] , [ N o n e ] , [ N o n e ] , B a s e , 2 0 0 0 0 0 0

      [BLANK] 

      [TC] - [Amount=NN]  L 0 1 0 8 1 4 0 1 4 0 , 4 2 0 0 1 1 0 1 , [ I C P   N o n e ] , [ N o n e ] , l i l , [ N o n e ] , B a s e , - 2 0 0 0 0 0 0

      Rows Loaded: 0

      Rows Rejected: 3

       

       

      2015-03-11 13:03:35,929 INFO  [AIF]: ERPI-105011:EPMERPI- ARCHIVE MODE: null

      2015-03-11 13:03:35,929 INFO  [AIF]: ERPI-105011:EPMERPI- Start archiving file:

      2015-03-11 13:03:35,929 INFO  [AIF]: ERPI-105011:EPMERPI- Archive file name: 6720141231.txt

      2015-03-11 13:03:35,929 INFO  [AIF]: ERPI-105011:EPMERPI- Deleting the source file: Testload4.txt

      2015-03-11 13:03:35,929 INFO  [AIF]: ERPI-105011:EPMERPI- File not deleted: \\Hfmap01\fdm\FRUTDEV\Testload4.txt

      2015-03-11 13:03:35,945 INFO  [AIF]: ERPI-105011:EPMERPI- ImportTextData - End

      2015-03-11 13:03:35,945 INFO  [AIF]: ERPI-105011:EPMERPI- Total time taken for the import in ms = 31

      2015-03-11 13:03:36,085 INFO  [AIF]:

      Import Data from Source for Period 'Dec 2014'

      2015-03-11 13:03:36,101 INFO  [AIF]: Generic Data Rows Imported from Source: 0

      2015-03-11 13:03:36,101 INFO  [AIF]: Total Data Rows Imported from Source: 0

      2015-03-11 13:03:36,990 INFO  [AIF]:

      Map Data for Period 'Dec 2014'

      2015-03-11 13:03:37,006 ERROR [AIF]: Error: No records exist for Period 'Dec 2014'

      2015-03-11 13:03:37,037 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

      Traceback (most recent call last):

        File "<string>", line 1775, in updateTDATASEG_T_TDATASEGW

      RuntimeError: Error: No records exist for Period 'Dec 2014'

       

       

      2015-03-11 13:03:37,037 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

      Traceback (most recent call last):

        File "<string>", line 1982, in updateTDATASEG_T_TDATASEGW

      RuntimeError: [u"Error: No records exist for Period 'Dec 2014'"]

       

       

      2015-03-11 13:03:37,115 FATAL [AIF]: Error in COMM Map Data

      2015-03-11 13:03:37,115 INFO  [AIF]: FDMEE Process End, Process ID: 67

       

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


      Not sure what it means and how I can test the mapping.


      Please advise..


      Thanks

      Laila

        • 1. Re: FDMEE - unable to load an erronous file
          SH_INT

          The issue here is that FDMEE is telling you that the field you have associated to the Amount contains non numeric values and it is therefore rejecting each line of data leaving you with no imported records. Make sure the fieild in your file you have specified as the Amount field contains numeric values.

          • 2. Re: FDMEE - unable to load an erronous file
            981699

            Thanks for the quick response.

             

            The flat file I load contained 2 rows (it was a test load).

            The correct file, that I was able to import, validate and export to HFM included these 2 rows:

             

            L0108140140,11101000,[ICP None],[None],[None],[None],Base,2000000

            L0108140140,42001101,[ICP None],[None],[None],[None],Base,-2000000

             

            The erroneous file that I wasn't even able to import included these 2 rows:

             

            L0108140140,11101000,[ICP None],[None],[None],[None],Base,2000000

            L0108140140,42001101,[ICP None],[None],lil,[None],Base,-2000000

             

            The only difference is in one of the dimensions lil instead of [None].

            I wanted the system to show me that the value wasn't mapped so it cannot proceed in the export to HFM.

             

            Any ideas?

             

            Thanks.

            • 3. Re: FDMEE - unable to load an erronous file
              SH_INT

              The answer is still the same as what I told you previously, FDMEE thinks that there are non-numeric values in your account field in the submitted file. Is everything else the same apart from the content of the file i.e. are you using the same Data Load Rule, Import Format etc

              • 4. Re: FDMEE - unable to load an erronous file
                981699

                Yes, everything is the same.

                • 5. Re: FDMEE - unable to load an erronous file
                  SH_INT

                  Well from the information you have provided, I can't see why there would be a problem, but FDMEE is telling you what it thinks the problem is. You will be better off pursuing this with Oracle support.

                   

                  One last thing to check is that the encoding on both the files is the same.

                  • 6. Re: FDMEE - unable to load an erronous file
                    Francisco Amores

                    Hi,

                     

                    looking at the log:

                    [TC] - [Amount=NN]   L 0 1 0 8 1 4 0 1 4 0 , 1 1 1 0 1 0 0 0 , [ I C P   N o n e ] , [ N o n e ] , [ N o n e ] , [ N o n e ] , B a s e , 2 0 0 0 0 0 0

                    [BLANK]

                    [TC] - [Amount=NN]  L 0 1 0 8 1 4 0 1 4 0 , 4 2 0 0 1 1 0 1 , [ I C P   N o n e ] , [ N o n e ] , l i l , [ N o n e ] , B a s e , - 2 0 0 0 0 0 0

                    Rows Loaded: 0

                    Rows Rejected: 3

                     

                    i can see weird white spaces for your data. That's probably due to you are not selecting the correct encoding file in FDMEE.

                     

                    You can use any editor like notepad++ to know the encoding type of your file.

                     

                    FDMEE uses UTF-8 by default. You can change that in System/application/user settings

                     

                    akafdmee.blogspot.com/2014/11/importing-files-with-different-file.html

                     

                    Hope that helps

                    • 8. Re: FDMEE - unable to load an erronous file
                      Francisco Amores

                      Did it make the trick?

                       

                      If so, please mark this question as correct/answered so others can see its feedback

                       

                      Regards