My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.

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:
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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.