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