I am using Change Data capture for Oracle by Attunity and got stuck on Logger detailed status. Please help

Help Needed 0 Reputation points
2023-03-14T18:49:20.2833333+00:00

With Change Data Capture for Oracle Attunity, I am connecting to Oracle and pulling the result on SQL server. It was working ok and for some reason, the status changed to Logger and I could not find a solution to fix this issue. The error it is returning is as follow.

ORACDC508E:Oracle method OCIStmtFetch failed with error: OCI_NO_DATA from table xdbcdc_trace.

May I get someone to help on this.

In case this help the two files I used is AttunityOracleCdcDesigner.msi and AttunityOracleCdcService.msi. I am not using Oracle Golden Gate for this process.

Thanks

Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,388 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Limitless Technology 43,966 Reputation points
    2023-03-16T14:54:34.88+00:00

    Hello

    Thank you for your question and reaching out. I can understand you are having query\issues related to Change Data Capture for Oracle Attunity stuck.

    I would like to invite you to visit below links for Oracle

    Change Data Capture Service for Oracle by Attunity : https://learn.microsoft.com/en-us/sql/integration-services/change-data-capture/change-data-capture-service-for-oracle-by-attunity?view=sql-server-ver15

    Known errors and resolutions with change data capture for Oracle by Attunity : https://learn.microsoft.com/en-us/sql/integration-services/change-data-capture/known-issues-resolutions-with-cdc-for-oracle-attunity?view=sql-server-ver15

    0 comments