FDMEE Error: No records exist for Period

Sarahlizy

I have FDMEE setup to import data from a flat file which is comma delimited, I have one location setup which I can successfully load data from a flat file into HFM. I've been setting up a new location and a new import format but for some reason I can't get it to load correctly, I always get the import process failing and the Process steps showing the first "Import balance data from file <filename> for Period jan 16" with a tick and then the "Transform and stage balance data to export for period jan 16" as cross (fail). When I look at the logs from "show" the errors are as follows:

2014-04-14 13:03:13,127 ERROR [AIF]: Error: No records exist for Period 'jan 16'

2014-04-14 13:03:13,127 DEBUG [AIF]: Comm.updateProcessDetail - START

2014-04-14 13:03:13,127 DEBUG [AIF]:

    UPDATE AIF_PROCESS_DETAILS

    SET STATUS = 'FAILED'

    ,RECORDS_PROCESSED = CASE

      WHEN RECORDS_PROCESSED IS NULL THEN 0

      ELSE RECORDS_PROCESSED

    END + NULL

    ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

    ,LAST_UPDATED_BY = CASE

      WHEN ('sarah.young' IS NULL) THEN LAST_UPDATED_BY

      ELSE 'sarah.young'

    END

    ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

    WHERE PROCESS_ID = 169

    AND ENTITY_TYPE = 'PROCESS_BAL_TRANS'

    AND ENTITY_NAME = 'jan 16'

   

2014-04-14 13:03:13,127 DEBUG [AIF]: Comm.updateProcessDetail - END

2014-04-14 13:03:13,127 DEBUG [AIF]: CommData.updateWorkflow - START

2014-04-14 13:03:13,127 DEBUG [AIF]:

        UPDATE TLOGPROCESS

        SET PROCESSENDTIME = CURRENT_TIMESTAMP

       

        ,PROCESSSTATUS = 2

          ,PROCESSIMP = 0

          ,BLNWCDIRTY = 0

          ,BLNLOGICDIRTY = 0

          ,BLNVALDIRTY = 0

          ,PROCESSIMPNOTE = 'Import Error'

        WHERE PARTITIONKEY = 7

        AND CATKEY = 1

        AND PERIODKEY = '2016-01-31'

        AND RULE_ID = 15

       

2014-04-14 13:03:13,143 DEBUG [AIF]: CommData.updateWorkflow - END

2014-04-14 13:03:13,143 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 'jan 16'

2014-04-14 13:03:13,143 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 'jan 16'"]

2014-04-14 13:03:13,143 DEBUG [AIF]: Comm.executeScript - START

2014-04-14 13:03:13,143 DEBUG [AIF]: The following script does not exist: \\Dev-HFM-DB\EPMDATA\FDM\TYMANREP/data/scripts/event/AftProcMap.py

2014-04-14 13:03:13,143 DEBUG [AIF]: Comm.executeVBScript - START

2014-04-14 13:03:13,143 DEBUG [AIF]: The following script does not exist: \\Dev-HFM-DB\EPMDATA\FDM\TYMANREP\data\scripts\event\AftProcMap.vbs

2014-04-14 13:03:13,143 DEBUG [AIF]: Comm.executeVBScript - END

2014-04-14 13:03:13,143 DEBUG [AIF]: Comm.executeScript - END

2014-04-14 13:03:13,174 DEBUG [AIF]: Comm.finalizeProcess - START

2014-04-14 13:03:13,174 DEBUG [AIF]: CommData.updateRuleStatus - START

2014-04-14 13:03:13,174 DEBUG [AIF]:

    UPDATE AIF_BALANCE_RULES

    SET STATUS = CASE 'FAILED'

      WHEN 'SUCCESS' THEN

        CASE (

          SELECT COUNT(*)

          FROM AIF_PROCESS_DETAILS pd

          WHERE pd.PROCESS_ID = 169

          AND pd.STATUS IN ('FAILED','WARNING')

        )

        WHEN 0 THEN 'SUCCESS'

        ELSE (

          SELECT MIN(pd.STATUS)

          FROM AIF_PROCESS_DETAILS pd

          WHERE pd.PROCESS_ID = 169

          AND pd.STATUS IN ('FAILED','WARNING')

        )

        END

      ELSE 'FAILED'

    END

    WHERE RULE_ID = 15

   

2014-04-14 13:03:13,174 DEBUG [AIF]: CommData.updateRuleStatus - END

2014-04-14 13:03:13,174 FATAL [AIF]: Error in COMM Map Data

2014-04-14 13:03:13,174 DEBUG [AIF]: Comm.updateProcess - START

2014-04-14 13:03:13,174 DEBUG [AIF]: Comm.updateProcess - END

2014-04-14 13:03:13,174 DEBUG [AIF]: The fdmAPI connection has been closed.

2014-04-14 13:03:13,174 INFO  [AIF]: FDMEE Process End, Process ID: 169

I must have missed some vital step in the setup but I just can't find what is missing, can anyone suggest a solution?

Thanks,

Francisco Amores

Hi,

RuntimeError: Error: No records exist for Period 'jan 16'

so no rows were imported.

- Set log level to 5

- Review if records were rejected (search for Processing Codes in the log file)

- Check if the delimiter is correct

- Check if your location has the correct import format

Francisco Amores

Hi,

RuntimeError: Error: No records exist for Period 'jan 16'

so no rows were imported.

- Set log level to 5

- Review if records were rejected (search for Processing Codes in the log file)

- Check if the delimiter is correct

- Check if your location has the correct import format

Sarahlizy

Thank you, checking the processing codes let me see that there was a problem with my amount column, turns out two of the columns had been mapped the wrong way around in the import format. Thanks for your help.

Francisco Amores

Good.

regards