One of the replication CDC tasks from SQL server to Kafka has a data error. This data error/exception details should be part of Kafka topic ATTREP_APPLY_EXCEPTIONS.
We created a consumer to read messages from this topic to analyze the root cause of this error, but no messages found in it.
Since messages retention period is 7 days to this topic, we tried to consume messages the very next day of this error occurred.
Does anyone have similar experience?
We are also planning on a solution to consume error messages from Kafka topic to persistent storage to closely track these errors. I would appreciate if there are any other ideas.
