Forum Stats

  • 3,759,061 Users
  • 2,251,495 Discussions
  • 7,870,477 Comments

Discussions

FDMEE - unable to load an erronous file

981699
981699 Member Posts: 62
edited May 11, 2015 9:35AM in Financial Data Management

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

Tagged:
ThinkFDM

Answers

  • SH_INT
    SH_INT Member Posts: 3,187 Bronze Crown
    edited Mar 11, 2015 9:07AM

    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.

  • 981699
    981699 Member Posts: 62
    edited Mar 11, 2015 9:13AM

    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.

  • SH_INT
    SH_INT Member Posts: 3,187 Bronze Crown
    edited Mar 11, 2015 10:08AM

    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

  • 981699
    981699 Member Posts: 62
    edited Mar 11, 2015 10:09AM

    Yes, everything is the same.

  • SH_INT
    SH_INT Member Posts: 3,187 Bronze Crown
    edited Mar 11, 2015 10:20AM

    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.

  • Francisco Amores
    Francisco Amores Member Posts: 1,693 Bronze Crown
    edited May 11, 2015 8:28AM

    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

    ThinkFDM
  • 981699
    981699 Member Posts: 62
    edited May 11, 2015 8:44AM
  • Francisco Amores
    Francisco Amores Member Posts: 1,693 Bronze Crown
    edited May 11, 2015 9:35AM

    Did it make the trick?

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

    Regards

This discussion has been closed.