AWS DMS Validation Pending for Some Tables

While running an AWS DMS task for migrating on-premise Oracle to AWS PostgreSQL RDS, some tables records are fully loaded into target database. From Table Statistics, it shows some tables validations are pending forever without progressing at all.

Check “Migration task logs”, it just says :

[TASK_MANAGER]I:All tables are loaded.waiting for validation to finish... 
                                     (replicationtask.c:1234)

RESOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

2 thoughts on “AWS DMS Validation Pending for Some Tables”

Gustavo Andres says:

August 14, 2019 at 11:43 pm

DMS no se debe usar con el usuario ADMIN?, ya que no me deja dar grant desde ADMIN a ADMIN

LikeLike

Reply
1. dbalifeeasy says:
  
  August 15, 2019 at 4:45 pm
  
  any user should do as long as having required privileges as per https://docs.aws.amazon.com/dms/latest/sbs/CHAP_Oracle2PostgreSQL.Steps.ConfigureOracle.html
  
  good luck !
  
  LikeLike
  
  Reply

Leave a reply to dbalifeeasy Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.