This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,539 Users
  • 2,269,776 Discussions
  • 7,916,824 Comments

Discussions

FDMEE Error: No records exist for Period

Sarahlizy
Sarahlizy Member Posts: 10
edited Apr 14, 2014 11:21AM in Financial Data Management

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,

Best Answer

  • Francisco Amores
    Francisco Amores EPM Data Integration Specialist SPAINMember Posts: 1,694 Bronze Crown
    Answer ✓

    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


Answers

This discussion has been closed.