1 Reply Latest reply: Jun 14, 2013 3:34 AM by PeakIndicators_Alastair RSS

    CDC - Consistent Set 'Start Journal' step ends in error.

    989049

      Hi,

       

      As part of enabling CDC logic,

      1. I have added the model to CDC (Consistent Set - JKM Oracle 10i Consistent (Streams))

      2. Added subscriber sunopsis

      3. Clicked on Start Journal

      On starting journal, the session errored at 'Check Apply process' step with the error

       

      ODI-1228: Task ORACLE_CS_STAGING_CDC_TEST (Journalizing) fails on the target ORACLE connection ORACLE_CSSTAGING_DEV.

      Caused By: java.sql.SQLException: ORA-26665: Streams process ODI_CDC_A already exists

      ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 380

      ORA-06512: at "SYS.DBMS_APPLY_ADM", line 663

      ORA-06512: at line 12

       

       

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

        at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)

        at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

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

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

        at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

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

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

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

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

       

      Please advise, whats the issue and how to correct the same.

        • 1. Re: CDC - Consistent Set 'Start Journal' step ends in error.
          PeakIndicators_Alastair

          Have you tried to start this journal before and this is the second time? Check any failed or warning steps in the operator log - this might give a clue.

           

          Try Stopping the journal to remove the existing streams process (confirm it is gone from the source database) before starting again.

           

          If that fails, you can rip it direct out of the database to reset the environment (outside of ODI)  you just need to rip the code out of the ODI operator on the stop.

          Check out the Oracle Streams documentation and also look at the DBMS_CDC packages as they call Streams routines beneath them.