Redshift error: String contains invalid or unsupported UTF8 codepoints Bad UTF8 hex sequence

Help Studio
, ,
1

Hello everyone. I’m building an automation that gets data from SAP and uploads to a database using a Run Query activity. It worked fine a few times but last time I have tried, it returns this error: String contains invalid or unsupported UTF8 codepoints Bad UTF8 hex sequence: b4 (error 3). There is something wrong with my workflow, my database or the data from SAP? Thanks

2

@Mateus_Snk

Looks like an issue with the data that came from sap…

Please verify the data that failed and see what is the difference

Cheers

1 Like
3

Hi @Mateus_Snk

The error message you encountered suggests that there is an issue with the UTF-8 encoding of the data you are trying to upload from SAP to your database. It can be caused by the data you are retrieving from SAP might contain characters or symbols that are not supported by the UTF-8 encoding. These unsupported characters can cause the error when you try to upload the data to the database.

Thanks!

Thanks!!

4

Do you know if I there’s an activity to replace those invalid characters or I need to make a change in my database?

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.