Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
FDMEE Error: No records exist for Period

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
-
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
-
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
-
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.
-
Good.
regards