Recreate missing base tables on CDC - Store Changes only task

Michael_Litz — Thu, 15 Oct 2020 01:23:12 GMT

CDC - Store Changes only task requires the base table be present in the target. The base tables are used by the task for metadata operations. If the base tables are missing ¹ the following steps are a good way to recreate them without affecting the original task.

In the log file we saw the error:
00004868: 2020-10-06T15:11:27 [TARGET_APPLY ]T: Table 'ATTUNITY'.'My_Target_Table' does not exist, insufficient privileges or no supported columns [1022517] (ar_odbc_conn.c:2183)

These steps should allow you to resume the original task.

1) Stop the original task.

2) Create a separate task with same source and target databases.

3) Set the task to be Full Load only - create tables in target.

4) Run this new task with the advanced run option of metadata only to create the missing tables.

5) Stop this new task when it completes.

6) Resume the original task to pick up where it left off

¹ Without knowing that they are required it is easy to think that base tables are not needed in this type of task and sometimes the target tables will be manually deleted by the user.

article Recreate missing base tables on CDC - Store Changes only task in Official Support Articles

Recreate missing base tables on CDC - Store Changes only task