This discussion is archived
2 Replies Latest reply: Oct 11, 2012 8:25 PM by EddyLau RSS

ERPI cannot import data from application

EddyLau Newbie
Currently Being Moderated
Hi, I encountered the following error when executing write back rule from planning application to EBS R12.

Error msg:
com.essbase.api.base.EssException: Cannot calculate. Essbase Error(1012089): Syntax Error in DATAEXPORTCOLHEADER option. Please provide a valid dense dimension name to be used as the column header
ERPI Process Start, Process ID: 113
ERPI Logging Level: DEBUG (5)
ERPI Log File: C:\Users\EPMAdmin\AppData\Local\Temp\2\/aif_501_113.log
Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)
[Java HotSpot(TM) 64-Bit Server VM (Sun Microsystems Inc.)]
Java Platform: java1.6.0_33
Call Servlet - START
Call Servlet - END
ERPI Process End, Process ID: 113

Furthermore, the below are the error msg shown in the ERPI agent when I execute the write back rule:

2012-10-05 15:55:58.388 ERROR ODI-1217 Session COMM_GL_WRITEBACK_BALANCES (16050
1) fails with return code 7000.
2012-10-05 15:55:58.876 ERROR ODI-1134 Agent ERPI_AGENT encountered an error: OD
I-1217: Session COMM_GL_WRITEBACK_BALANCES (160501) fails with return code 7000.
Caused by: ODI-1226: Step Set Process Failure fails after 1 attempt(s).

Please advise how to solve the problem

Edited by: EddyLau on Oct 5, 2012 1:02 AM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points