Database migration service error DATA_STRUCTURE:SQLite general error. Code <19>
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_STRUCTUREE:SQLite general error. Code <19>, Message<UNIQUE constraint failed: events.identifier, events.eventType, events.detailMessage> What is causing this error? We dont know if the replication is going well
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.
Did this work for you?
Any idea why these warnings are thrown in the first place? I've got Cloudwatch Alarms monitoring a metric for any errors/warnings so would like to have a better understanding before adjusting my metric to ignore SQLite text
Is it possible to use AWS RDS SQL Server as an AAG target from on premise primary?asked 7 months ago
Database migration service error DATA_STRUCTURE:SQLite general error. Code <19>asked 4 months ago
Oracle Migration from on-premises using DMS and RmanAccepted Answerasked 2 years ago
Phantom Update on Aurora Postgres from AWS DMS Replication from SQL Server Sourceasked 3 months ago
What happens to a DMS job when a SQL Server AG fails over?Accepted Answerasked 2 years ago
Change SQL Server from Bring Your Own License (BYOL) to License Included without migrationAccepted Answerasked 5 years ago
Error loading metadata using AWS SCT against an RDS SQL Server Instanceasked 5 months ago
DMS to migrate SQL Server from RDS to EC2asked 2 years ago
TEXT columns from Source SQL Server database are not being replicated to targetasked 12 days ago
Is there a service to move a database from MSSQL to MySQL (both hosted on AWS)asked 4 months ago