CDC for Attunity Status Aborted and Update CDC Error in CDC Designer

John Minihan 1 Reputation point
2021-08-16T22:36:18.17+00:00

Hi, CDC for Oracle by Attunity connected to SQL Server 2017 CU21. (Same issue after applying CU25)

Intermittently (3 times in a month?) generates "Error: Service <CDC Service name>:  ORACDC205E: The Oracle CDC instance <CDC Instance name> was aborted. Usually recovers automatically. From yesterday morning, error occurs but does not recover.

Adjusting properties on CDC Designer, an Update CDC Error error dialog is displayed Error occurred while updating CDC Capture tables - The given key was not present in the dictionary. The error is in UpdateCaptureTables.

Where do I even start?

123728-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,593 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 37,671 Reputation points
    2021-08-17T04:01:12.853+00:00

    Hi @John Minihan ,

    You may collect diagnostics to gather logs for more details to troubleshooting the error.

    resolutions-with-cdc-for-oracle-attunity

    Here is a same issue kb4500595-fix-cdc-source-preview-fails-with-the-given-key-was-not-present-in-the-dictionary-error which has been fixed in SQL Server 2017 CU15, so it is really strange about your issue.

    I'd like suggest that you submit the issue at https://feedback.azure.com/forums/908035-sql-server.

    If the issue mentioned by customers for many times, the product team may help deal with it. Your feedback is valuable for us to improve our products and increase the level of service provided.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October


  2. John Minihan 1 Reputation point
    2021-08-17T16:43:40.887+00:00

    Hi Zoe, Thanks for your response...

    There is very little info in the Diagnostics log:

    123920-image.png

    I first received the Update CDC Error issue when trying to configure the CDC Designer to generate more useful diagnostics!

    What is strange is that there is, presumably, an issue updating the CDC capture Tables, while the cdc.xdbcdc_state table is correctly updated to ABORTED status...!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.