By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

0

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<UNIQUE constraint failed: events.identifier, events.eventType, events.detailMessage> What is causing this error? We dont know if the replication is going well

Topics
Migration & ModernizationDatabase
Tags
Migration & ModernizationAWS Database Migration ServiceMicrosoft SQL Server
Language
English
AWS-User-2803279
asked 2 years ago803 views
1 Answer
0

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.

AWS
D-Rao
answered 2 years ago
  • D-Rao
    2 years ago

    Did this work for you?

  • Dylan_Delport
    2 years ago

    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

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content