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

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.

주제

마이그레이션 및 현대화 데이터베이스

태그

AWS 데이터베이스 마이그레이션 서비스 PostgreSQL 데이터 추출, 변환 및 로드

언어

English

rePost-User-4380538

질문됨 2년 전6161회 조회

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

burdettg

답변함 2년 전

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

rePost-User-4380538

답변함 2년 전

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

관련 콘텐츠