- Newest
- Most votes
- Most comments
By default DMS maps DATETIMEOFFSET to STRING (a), so if DMS replicates the [ALTER TABLE .. ADD LastUpdateDate DATETIMEOFFSET] it will create it on PostgreSQL as [LastUpdateDate VARCHAR(##)].
I understand that, after the DDL [ALTER TABLE .. ADD LastUpdateDate DATETIMEOFFSET] operation, when you DELETE a record from the source table DMS is logging an UPDATE exception in the awsdms_apply_exceptions table with an error message like "..source column(s) contain data that exceed(s) the size limit of the corresponding target column ... source column is 35 characters while target column is 34 characters" even though the DELETE is successfully replicated.
The behavior seems like a bug and I have raised a bug report with the Service team. For now, you can safely ignore this specific exception in the awsdms_apply_exceptions table.
Relevant content
- asked 7 months ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 6 months ago
Thank you for the reply and raising the bug.