DMS failing to find table awsdms_full_load_exceptions but table not listing in documentation

Question

I have an error with DMS finding a table to create exception information during a full load:

```
Last Error Endpoint initialization failed. Task error notification received from subtask 1, thread 1 [reptask/replicationtask.c:2883] [1020401] Cannot get special table's id for owner : comqagateway, name : awsdms_full_load_exceptions; Cannot create Full Load Exception table; Error executing data handler; Stream component failed at subtask 1, component st_1_WCIYTILZC4TE2T54E6ONKFXVNPXH7BODCIR4LBA; Stream component 'st_1_WCIYTILZC4TE2T54E6ONKFXVNPXH7BODCIR4LBA' terminated [reptask/replicationtask.c:2891] [1020401] Stop Reason FATAL_ERROR Error Level FATAL
```

But the table layout isn't listed at https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.ControlTable.html so I don't know how to create the table.

Help?

Answer

Hello,

awsdms_full_load_exceptions table gets created automatically. Can you please ensure the user configured in the endpoint has required privileges to create the table (CREATE ANY TABLE in case of Oracle as target or any equivalent privilege in case of other engine).

DMS failing to find table awsdms_full_load_exceptions but table not listing in documentation

Relevant content