1 Reply Latest reply on Feb 11, 2015 1:26 AM by Francisco Amores

    FDMEE Intialize Source System error

    1063612

      Hi I'm getting the below error while trying to initialize source sytem in FDMEE

       

      Log:

       

      2015-02-09 01:50:45,616 INFO  [AIF]: FDMEE Process Start, Process ID: 34,388

      2015-02-09 01:50:45,631 INFO  [AIF]: FDMEE Logging Level: 4

      2015-02-09 01:50:45,631 INFO  [AIF]: FDMEE Log File: \\Fab2crp-nas1\hfmprod\Data\FDMEE\outbox\logs\EBSPRD01_34388.log

      2015-02-09 01:50:45,631 INFO  [AIF]: User:sdammada

      2015-02-09 01:50:45,631 INFO  [AIF]: Location:NA (Partitionkey:null)

      2015-02-09 01:50:45,631 INFO  [AIF]: Period Name:NA (Period Key:null)

      2015-02-09 01:50:45,631 INFO  [AIF]: Category Name:NA (Category key:null)

      2015-02-09 01:50:45,647 INFO  [AIF]: Rule Name:NA (Rule ID:null)

      2015-02-09 01:50:46,864 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

      [Oracle JRockit(R) (Oracle Corporation)]

      2015-02-09 01:50:46,864 INFO  [AIF]: Java Platform: java1.6.0_37

      2015-02-09 01:50:49,516 FATAL [AIF]: Error in Launch EBS Setup Source System

      2015-02-09 01:50:49,594 INFO  [AIF]: FDMEE Process End, Process ID: 34388

       

      ODI:

       

      Session Failed :68091501 : ODI-1217: Session EBS_GL_SETUP_SOURCE_SYSTEM (68091501) fails with return code 1.

      ODI-1226: Step EBS Extract COA Ledgers fails after 1 attempt(s). ODI-1240: Flow EBS Extract COA Ledgers fails while performing a Integration operation. This flow loads target table AIF_COA_LEDGERS.

      ODI-1228: Task EBS Extract COA Ledgers (Integration) fails on the target GENERIC_SQL connection FDMEE_DATA_SERVER.

       

      Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (EPM_FDMEE.AIF_COA_LEDGERS_U2) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539) at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49) at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41) at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92) at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83) at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68) at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:562) at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:516) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324) at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460) at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) ]]>

        • 1. Re: FDMEE Intialize Source System error
          Francisco Amores

          Hi,

          it seems that you are importing duplicate source system id, source ledger name combination.

          You need to troubleshoot in order to see which is the root cause.

          Have you checked table AIF_COA_LEDGERS?

          if you go to ODI operator you will see the SQL query use to insert into AIF_COA_LEDGERS. Can you run this in any SQL tool and see if you have duplicate ledger named returned?

           

          regards