Constraint error - Connect_CDC - connect_cdc_mimix_share - 6.x

You may receive an error like the following when running a Copy request overnight:

ERROR:Error executing statement 'alter table qatest.dbo.DTT1 drop constraint

The generated index name has probably changed, for example, it has been regenerated overnight, and the last one from a Catalog Refresh will be out of date. Solve this error using these steps:

1. Refresh the table in Connect CDC Director.

2. Recommit the model in Connect CDC Director.

3. Do a Model Update in Connect CDC MonCon.

4. Rerun the request in Connect CDC MonCon.