Qlik Replicate: Invalid Byte Sequence for Encoding UTF8 Error PostgreSQL Source

[Dana_Baldwin]

Received the following error during Replicate full load Cannot init table workspace for Tableid- '5' RetCode: SQL_ERROR SqlState: 22021 NativeError: 1 Message: ERROR: invalid byte sequence for encoding "UTF8": 0xa0; Error while executing the query

Environment

• Qlik Replicate 

Resolution

Set the client encryption using an internal parameter on the source endpoint, "afterConnectScript" to a value of: SET client_encoding 'SQL_ASCII'