DMS issue resolved:
=================
DMS task Endpoint setting for data type error : by default DMS migration number data type with precision , to avoid
This error we need to setup endpoint with below extra connection (source : Oracle Database target: Aurora PostgreSQL)
In cloudWatch log, you will see like this -
[TARGET_LOAD ]E: Command failed to load data with exit error code 0 and exitwhy 1. Please check target database logs for more information.
Cause of this issue- mismatch in data types or precision between your source and target databases. When columns defined as numeric data types without specified precision or scale. In this senerio DMS won’t able migrate without below extra endpoint setting.
For source endpoint: Oracle SE 2
===============
DMS —> Migrate or replicate. —> Endpoints
select Use endpoint connection attributes then
Endpoint setting : Extra connection attributes
NumberDatatypeScale=-2;
For Target endpoint: Aurora PostgreSQL (Engine version 17.4)
===============
DMS —> Migrate or replicate. —> Endpoints
select Use endpoint connection attributes then
Endpoint setting : Extra connection attributes
MapUnboundedNumericAsString=true;
Addition info for DMS task setting for this migration:
Because DMS by default migrate all names as Upper case for PostgreSQL or Mysql so, if you need lower-case then set up this rules
Schema Name: HALIM
Table mappings
==============
Selection rules
where schema name is like 'HALIM' and table name is like '%', include
Transformation rules
where schema name is like 'HALIM' , convert-lowercase # for schema
where schema name is like 'HALIM' and table name is like '%' , convert-lowercase. # For Tables
where schema name is like 'HALIM' and table name is like '%' and column name is like '%' , convert-lowercase. # For Columns
