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

AWS DMS table load error at target: invalid byte sequence for encoding UTF8

0

DMS task Source database is RDS Oracle Target database is RDS Aurora PostgreSQL 15.5

2 examples below from 2 separate tasks:

2024-04-16 10:07:09 UTC:10.187.205.159(56962):xxxxxx:[30124]:ERROR: invalid byte sequence for encoding "UTF8": 0xed 0xa1 0x82

2024-04-16 11:04:05 UTC:10.187.205.159(36252):xxxxxxxxxxx:[924]:ERROR: invalid byte sequence for encoding "UTF8": 0xed 0xa1 0x84

Any advice / suggestions welcome. This is the first time I have encountered this. UTF8 is set at the target RDS via parameter group setting i.e. client_encoding UTF8 ty

Topics
Migration & Modernization
Tags
AWS Database Migration Service
Language
English
fran
asked 16 days ago209 views
1 Answer
1
Accepted Answer

Fix found:

For the source endpoint I set a multibyte fix Extra connection attributes Info Use extra connection attributes to define additional endpoint settings for AWS DMS

nlsCharsetId=871

fran
answered 15 days ago
profile picture
EXPERT
Oleksii Bebych
reviewed 11 days 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

Relevant content