2 Replies Latest reply: Oct 11, 2012 10:25 PM by cwlau RSS

    ERPI cannot import data from application

    cwlau
      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
      Thanks.

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