DMS load fails from Oracle NUMBER(38) source to Aurora Postgres BIGINT (INT8) target.  Passes premigration assessment.  All values being migrated are below 2,000,000,000 (~BIGINT limit).

The load succeeds if the target datatype is changed to Postgres NUMERIC.  Inserting "102675852.0000000000" manually (using SQL) to the same column defined as BIGINT also works without error.

The full error is "ERROR: 22P02: invalid input syntax for type bigint: "102675852.0000000000" ("LOCATION: scanint8, int8.c:127", "STATEMENT: COPY "(table name)"."(column name)" FROM STDIN WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '\'").  

Could work around by changing datatype after load, but the table is quite large so this takes much too long for our purposes.

All Content tagged with DMA Connect

DMS load from Oracle NUMBER(38) to Aurora Postgres BIGINT fa...