Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Load Rule failed to import after data extraction from source.

User_9D3SLApr 7 2021

My apologies if I did not give enough information. Our org recently acquired this EPBCS software and would welcome any assistance in troubleshooting. We have a Data Load rule that was working a month ago and is now failing with the following error when attempting to import after successfully extracting data from the source system. Import Format uses Multi Column All Data Type and Comma File Delimiter. Please let me know if any further information is needed to assist in troubleshooting.
Log Details
2021-04-06 22:28:38,528 DEBUG [AIF]: Script- getRuleInfo
2021-04-06 22:28:38,530 DEBUG [AIF]: Period dimension not defined
2021-04-06 22:28:38,532 DEBUG [AIF]: header row for text data: "Person Number","Person First Name","Person Last Name","Person Full Name","Hire Date","Gender","Employment Category","Employment Category Name","
2021-04-06 22:28:38,532 DEBUG [AIF]: Header:"Person Number","Person First Name","Person Last Name","Person Full Name","Hire Date","Gender","Employment Category","Employment Category Name","
2021-04-06 22:28:38,535 DEBUG [AIF]: HeaderRow:"Person Number","Person First Name","Person Last Name","Person Full Name","Hire Date","Gender","Employment Category","Employment Category Name","
2021-04-06 22:28:38,535 DEBUG [AIF]: HEADER_ROW_NUM:1
2021-04-06 22:28:38,553 DEBUG [AIF]: EPMFDM-140274:Message - Datasource Column Position in header: Person Number -> 1
2021-04-06 22:28:38,554 ERROR [AIF]: EPMFDM-140274:Message - null
2021-04-06 22:28:38,556 ERROR [AIF]: EPMFDM-140274:Message - null
2021-04-06 22:28:38,558 ERROR [AIF]: Unexpected error: <type 'java.lang.RuntimeException'>
java.lang.RuntimeException
2021-04-06 22:28:38,559 FATAL [AIF]: Error in FileData.importData
Traceback (most recent call last):
File "<string>", line 94, in importData
RuntimeException: java.lang.RuntimeException

Process Details.PNGData Load Rule Details.PNGData Load Rule Details 2.PNG

Comments