14 Replies Latest reply on Aug 31, 2017 2:17 PM by Dermott Beverley

    Exception while applying AMOUNT mapping on the row:?? (FDMEE)

    Dermott Beverley

      Hello,

       

      I am having this issue when trying to import data from an EPM planning application to another EPM planning application. FDMEE will not import the data to the location due to the [BLANK] prefix being added to the record as below...

       

      The export created by FDMEE looks exactly right (as per what you would expect if you were to load this through EAS) and there are no leading or trailing spaces on the records. This is the error with the log level turned to level 5:

       

      2017-08-31 10:41:13,324 DEBUG [AIF]: FileData.py: Importing Text data for load id: 5877
      2017-08-31 10:41:13,387 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :\\hypfdmee2\FDMEEdata\\outbox\logs\SHHP2_5877.log
      2017-08-31 10:41:13,389 INFO  [AIF]: EPMFDM-140274:Message - LOADID:PARTKEY:CATKEY:RULEID:CURRENCYKEY:FILEPATH::5877;110:6:218:[NONE]:\\hypfdmee2\FDMEEdata\/data
      2017-08-31 10:41:13,396 INFO  [AIF]: EPMFDM-140274:Message - File CharEncoding as per settings: UTF-8
      2017-08-31 10:41:13,397 INFO  [AIF]: EPMFDM-140274:Message - ImportTextData - Start
      2017-08-31 10:41:13,433 INFO  [AIF]: EPMFDM-140274:Message - Log File Name :\\hypfdmee2\FDMEEdata\\outbox\logs\SHHP2_5877.log
      2017-08-31 10:41:13,441 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=AMOUNT:ImpFieldText=null:StartPos=1:SourceClName=Amount
      2017-08-31 10:41:13,441 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ACCOUNT:ImpFieldText=null:StartPos=1:SourceClName=Account
      2017-08-31 10:41:13,442 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD2:ImpFieldText=null:StartPos=1:SourceClName=Channel
      2017-08-31 10:41:13,442 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD9:ImpFieldText=null:StartPos=1:SourceClName=null
      2017-08-31 10:41:13,442 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=ENTITY:ImpFieldText=null:StartPos=1:SourceClName=Entity
      2017-08-31 10:41:13,442 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD7:ImpFieldText=null:StartPos=1:SourceClName=ICP
      2017-08-31 10:41:13,443 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD5:ImpFieldText=null:StartPos=1:SourceClName=null
      2017-08-31 10:41:13,443 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD3:ImpFieldText=null:StartPos=1:SourceClName=Element4
      2017-08-31 10:41:13,443 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD8:ImpFieldText=null:StartPos=1:SourceClName=Element5
      2017-08-31 10:41:13,444 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=UD1:ImpFieldText=WORKING:StartPos=1:SourceClName=Version
      2017-08-31 10:41:13,445 INFO  [AIF]: EPMFDM-140274:Message - File Name PSHP_5877.dat
      periodKey2017-07-31
      2017-08-31 10:41:13,445 INFO  [AIF]: EPMFDM-140274:Message - dataLoadEngine.getSourceSystemTypeEPM() HPL
      2017-08-31 10:41:13,446 DEBUG [AIF]: EPMFDM-140274:Message - HEADER: ["Years", "Scenario", "Channel", "Element5", "Entity", "ICP", "Element4", "Account", "Version", "Period"]
      2017-08-31 10:41:13,446 DEBUG [AIF]: EPMFDM-140274:Message - ImpFieldName=CURKEY:ImpFieldText=null:StartPos=1:SourceClName=Currency
      2017-08-31 10:41:13,446 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1501","ICPNONE","All_Element4","10100","WORKING",-2468150.72]
      2017-08-31 10:41:13,447 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1901","ICPNONE","All_Element4","13000","WORKING",0.00]
      2017-08-31 10:41:13,475 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1800","ICPNONE","All_Element4","11000","WORKING",-72424.74]
      2017-08-31 10:41:13,475 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1800","ICPNONE","All_Element4","12100","WORKING",-27589.01]
      2017-08-31 10:41:13,475 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1850","ICPNONE","All_Element4","11000","WORKING",-80769.50]
      2017-08-31 10:41:13,476 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1850","ICPNONE","All_Element4","12100","WORKING",-10257.44]
      2017-08-31 10:41:13,476 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1850","ICPNONE","All_Element4","13000","WORKING",0.00]
      2017-08-31 10:41:13,477 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1600","ICPNONE","All_Element4","13000","WORKING",0.00]
      2017-08-31 10:41:13,477 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1310","ICPNONE","All_Element4","13000","WORKING",-3900.00]
      2017-08-31 10:41:13,478 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1311","ICPNONE","All_Element4","13000","WORKING",-9709.98]
      2017-08-31 10:41:13,478 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1312","ICPNONE","All_Element4","10000","WORKING",1109.43]
      2017-08-31 10:41:13,478 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1403","ICPNONE","All_Element4","13000","WORKING",-1052.80]
      2017-08-31 10:41:13,479 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","10000","WORKING",-1346683.11]
      2017-08-31 10:41:13,479 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","10200","WORKING",-658186.04]
      2017-08-31 10:41:13,479 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","11000","WORKING",-16443.73]
      2017-08-31 10:41:13,480 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","12000","WORKING",-59293.71]
      2017-08-31 10:41:13,480 DEBUG [AIF]: EPMFDM-140274:Message - Exception while applying AMOUNT mapping on the row:["FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","13000","WORKING",-31528.94]
      2017-08-31 10:41:13,481 INFO  [AIF]: EPMFDM-140274:Message -  PROCESS ID: 5877
      PARTITIONKEY: 110
      IMPORT GROUP: CODA_FR2
      FILE TYPE: DELIMITED
      DELIMITER: ,
      SOURCE FILE: PSHP_5877.dat
      PROCESSING CODES:
      -----------------------------------------------------------------------------------
      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

      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1501","ICPNONE","All_Element4","10100","WORKING",-2468150.72
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1901","ICPNONE","All_Element4","13000","WORKING",0.00
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1800","ICPNONE","All_Element4","11000","WORKING",-72424.74
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1800","ICPNONE","All_Element4","12100","WORKING",-27589.01
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1850","ICPNONE","All_Element4","11000","WORKING",-80769.50
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1850","ICPNONE","All_Element4","12100","WORKING",-10257.44
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1850","ICPNONE","All_Element4","13000","WORKING",0.00
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1600","ICPNONE","All_Element4","13000","WORKING",0.00
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1310","ICPNONE","All_Element4","13000","WORKING",-3900.00
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1311","ICPNONE","All_Element4","13000","WORKING",-9709.98
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1312","ICPNONE","All_Element4","10000","WORKING",1109.43
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1403","ICPNONE","All_Element4","13000","WORKING",-1052.80
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","10000","WORKING",-1346683.11
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","10200","WORKING",-658186.04
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","11000","WORKING",-16443.73
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","12000","WORKING",-59293.71
      [BLANK] "FY17","FCAST_Q3","TOTCHANNEL","NOPROJECT","DEN1950","ICPNONE","All_Element4","13000","WORKING",-31528.94
      Rows Loaded: 0
      Rows Rejected: 17

       

       

      Any ideas?

       

      Thanks in advance.