- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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.
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata un anno fa
Thank you for the reply and raising the bug.