Error: F_JT0736: Capture Encountered DDL Statement To Create the Table, but Table Is Already Enrolled

Issue

The following errors appear, despite not having AdaptDDL enabled for the channel:

F_JT0736: Capture encountered DDL statement to create the table but table is already enrolled.

F_JT1492: Previous error occurred during a create_table operation for table [dbo.customer] at SEQ 0x20f9e60307bcc00 and LSN 0020f9e6:000c1ef3:0018 with timestamp [2019-10-25T03:20:11-04:00\]. To report this to Technical Support a backup transaction file will be needed,but such a file does not yet exist.

Environment

HVR 5

Resolution

This error occurs when a table exists in a target location but is dropped and re-created on the source side.

When a table is dropped and re-created on the source, it will have a new object id. The object id is recorded in the HVR enrollment file and differs from the target table id.

To resolve this issue, do the following:

1. Select only the following options:
   • Scripts and Jobs
   • Table Enrollment - Replace Old Enrollment
2. Click Initialize

A new enrollment will be created and the affected table will contain the updated object id.