1 Reply Latest reply on May 15, 2014 3:22 PM by JeromeFr

    ODI Session failling with error SQLException: ORA-12154 in ODI 12c

    user1175240

      Hi Guys,

       

      I installed ODI 12c and created few mappings, when I ran them they are falling with below error.

       

      ODI-1228: Task IKM Oracle Merge (Load ADS) fails on the target ORACLE connection OBIDEV.

      Caused By: java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified.

       

      1. created physical schema, logical schema
      2. created new models for databases and imported data store(tables) by using reverse engineer.
      3. created simple table to table mapping, i am able to view data on source and target tables.
      4. when I ran the session it error out, I created a same mapping earlier and it was successful and was able to load data.

       

      checked even tnsnames.ora file, it is good,am i missing any thing?

       

      Error Message:

      ODI-1217: Session mAP_EBS_BI_2_DS_SESS (64) fails with return code ODI-1298.

      ODI-1226: Step mAP_EBS_BI_2_DS_STEP fails after 1 attempt(s).

      ODI-1298: Serial task "null (40)" failed because child task "null (80)" is in error.

      ODI-1298: Serial task "OBIDEV_DACREPDEV_UNIT (70)" failed because child task "null (80)" is in error.

      ODI-1228: Task IKM Oracle Merge (Load ADS) fails on the target ORACLE connection OBIDEV.

      Caused By: java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified

       

       

        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.T4CStatement.doOall8(T4CStatement.java:202)

        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1110)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2251)

        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2192)

        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:347)

        at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)

        at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:103)

        at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:26)

        at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

        at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:214)

        at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:135)

        at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:856)

        at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2004)

        at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:544)

        at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:709)

        at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:624)

        at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)

        at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:789)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:330)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$2700(StartSessRequestProcessor.java:80)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:957)

        at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:177)

        at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:110)

        at java.lang.Thread.run(Thread.java:744)