Sample Header Ad - 728x90

What does MISSING_TARGET means on Amazon DMS (Database Migration Service) validation?

1 vote
1 answer
2142 views
I'm running Amazon DMS from RDS to Aurora, the error when full restarting (never been successful before) from awsdms_validation_failures_v1 tables are:
[
  {
    "TASK_NAME": "TPPHLQOQH3WTSU27DVRVWS2BAXTQ7E7DYITWJCQ",
    "TABLE_OWNER": "public",
    "TABLE_NAME": "fraud_info",
    "FAILURE_TIME": "2021-10-20 13:20:13.031174",
    "KEY_TYPE": "Row",
    "KEY": "{\n\t\"key\":\t[\"9990\"]\n}",
    "FAILURE_TYPE": "MISSING_TARGET"
  }
]
when I query from information schema on target database, it does exists
SELECT *
FROM information_schema.columns
WHERE table_schema = 'public'
	AND table_name   = 'fraud_info'
;
What does it means?
Asked by Kokizzu (1403 rep)
Oct 20, 2021, 01:40 PM
Last activity: Mar 8, 2025, 01:07 AM