By using AWS re:Post, you agree to the Terms of Use

ERROR: invalid input syntax for type bigint: "95139.81653861178"

1

Using DMS I am migrating data from Oracle to postgres. I am getting errors from DMS, When I have checked the postgres logs I found the below errors.

ERROR: invalid input syntax for type bigint: "95139.81653861178" CONTEXT: COPY compositedata, line 307, column value: "95139.81653861178" :STATEMENT: COPY "toype"."compositedata" FROM STDIN WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE ''

Please let me know If you have any fix for this issue.

2 Answers
2

BIGINT expects and integer and 95139.81653861178 isn't an integer. You'll need a different data type that matches your source data better. You might want to try Schema Conversion Tool to help you. https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.Oracle.ToPostgreSQL.html

answered 2 months ago
1

Thanks for your help. I have changed postgres data type to double precision and it resolved the issue.

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions