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

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

トピック

移行と近代化データベース

タグ

移行と近代化 AWS Database Migration Service マイクロソフト SQL サーバー

言語

English

AWS-User-2803279

質問済み 2年前809ビュー

1回答

新しい順
投票が多い順
コメントが多い順

これらの回答は役に立ちましたか？コミュニティがあなたの知識を活用できるように、正解に賛成票を投じてください。

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.

D-Rao

回答済み 2年前

D-Rao
2年前
Did this work for you?
Dylan_Delport
2年前
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

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

Hello:

関連するコンテンツ