Table row count truncation during CDC

[MoeE]

Hi,

A client just explained that they are experiencing some odd behaviour for one table only. They say that randomly during CDC, the target table is entirely truncated, and replaced with the rows that are inserted.

e.g. Target and Source tables both have 200,000 rows. An insert of 88 records occurs, then the target has only 88 records and not 200,088 records. The source table count updates correctly.

This issue only occurs intermittently around once or twice in two to three weeks. It can be reloaded to fix it but then it happens again a week or two later. This is the first time im hearing about an issue like this. Sounds very odd.

The task is Oracle logstream to sql server target. QR is 2023.11.0.468 

Currently I've requested that the table be separated into its own task so that I can monitor it individually.

Just wondering, has anyone come across an issue like this?

Regards,

Mohammed

[sureshkumar]

Hello @MoeE 

We never come across this kind of issue, please open a support case to analyze further.

CDC is Apply changes or Store changes?

Regards,

Suresh

[john_wang]

HI Mohammed @MoeE ,

Seems we never experienced such an issue. Please set source_capture/target_apply to TRACE and monitor the behavior. Let's trace it from trace level.

Regards,

John.

[john_wang]

HI Mohammed @MoeE ,

Seems we never experienced such an issue. Please set source_capture/target_apply to TRACE and monitor the behavior. Let's trace it from trace level.

Regards,

John.

[MoeE]

Hi John,

All is okay. Customer mentioned some sort of process running on the tables on the target which is very likely the cause.

Regards,

Mohammed 

[john_wang]

Thank you for your excellent support @MoeE !