Extracting Data from On-premises Data Sources to the Target EPBCS Application fails with "Error: 3335"/ Duplicate columns
(Doc ID 2885411.1)
Last updated on AUGUST 10, 2022
Applies to:
Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Not able to create data integration from an on-premise database to Target EPBCS Application
While creating data integration from an on-premise database, Data management replaces all dimension members with the member name from the first column of the SQL query /data file generated by the EPM Integration Agent.
ERROR
-----------------------
INFO [AIF]: -------START EXPORT STEP-------
INFO [AIF]: EssbaseService.exportData - START
INFO [AIF]: Creating data file: XYZ.dat
INFO [AIF]: Data file creation completed: 2
INFO [AIF]: Saved rule file to essbase server
INFO [AIF]: EssbaseService.exportData - END (true)
INFO [AIF]: Executing the following script: BefLoad.py
INFO [AIF]: No business rules found for load id:151
INFO [AIF]: EssbaseService.loadData - START
INFO [AIF]: Starting executeDataRuleFile...
INFO [AIF]: Loading data into cube using data file...
INFO [AIF]: Load data encountered the following errors:
| Error: 3335 | DsNone | "DsNone","DsNone","DsNone","DsNone","DsNone","FCW_01","FY22","TP1","EUR",111111|
| Error: 3335 | DWH Load | "DWH Load","DWH Load","DWH Load","DWH Load","DWH Load","FCW_01","FY22","TP1","EUR",222222 |
INFO [AIF]: Load data failed.
ERROR [AIF]: Load data failed.
INFO [AIF]: EssbaseService.loadData - END (false)
FATAL [AIF]: Error in CommData.loadData
Traceback (most recent call last):
File "", line 2430, in loadData
RuntimeError: false
FATAL [AIF]: Error in COMM Load Data
INFO [AIF]: FDMEE Process End, Process ID: 151
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |