6 Replies Latest reply on Oct 12, 2012 2:07 PM by 967984

    ODI 11g CDC error

    967984
      Hi experts,

      I want to do simple CDC example on ODI 11g.

      Firstly I added a table to CDC(HR.Countries table). Then start journal.

      But I am taking an error on step "Create JV$ view." :

      ODI-1228 Task COUNTRIES (Journalizing) fails on the target ORACLE connection MYLOCALDB. Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist.
      .....

      Then here is the steps generated code :


      create or replace view STG.JV$COUNTRIES /* This view is created in the work physical schema of the current Data server */
      as
      select decode(TARG.ROWID, null, 'D', 'I') JRN_FLAG,
      JRN.JRN_SUBSCRIBER JRN_SUBSCRIBER,
      JRN.JRN_DATE JRN_DATE,
      JRN.COUNTRY_ID COUNTRY_ID,
      TARG.COUNTRY_NAME COUNTRY_NAME,
      TARG.REGION_ID REGION_ID
      from (
      select L.JRN_SUBSCRIBER JRN_SUBSCRIBER,
      L.COUNTRY_ID COUNTRY_ID,
      max(L.JRN_DATE) JRN_DATE
      from STG.J$COUNTRIES L
      where L.JRN_CONSUMED = '1'
      group by L.JRN_SUBSCRIBER,
      L.COUNTRY_ID
      ) JRN,
      HR.COUNTRIES TARG
      where JRN.COUNTRY_ID = TARG.COUNTRY_ID (+)


      I am using "STG" work schema for HR phsyical schema.

      If I use "HR" work schema for HR phsyical schema, evrything is ok. But when I use "STG", I am taking this error.

      Pls help me experts. Thanks