Database migration service error DATA_STRUCTURE:SQLite general error. Code

Question

Hello:
---

We have 18 DMS replicate tasks with origin endpoints from SQL server databases on premises to target ec2 SQL server endpoints. Same database versions.
All tasks are replicating with this red status: "Running with errors". we have 2 x r5.2xlarge replication instances.
cloudwatch logs are reporting always the same error.

[DATA_STRUCTURE]E:SQLite general error. Code <19>, Message
What is causing this error?
We dont know if the replication is going well

Answer

You can ignore the SQLite errors.

If your task(s) are in "Running with errors" flag, it implies that the DMS task is running fine, but some of its table(s) have failed.

To find that out, check the "Table Statistics" on the Task page of the DMS Console and see which table(s) are flagged as failed/error there. Then, go to the DMS task logs and search for the table name and you should see the reason why those table(s) failed.

Database migration service error DATA_STRUCTURE:SQLite general error. Code <19>

Hello:

相關內容