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
Resolution
Set the client encryption using an internal parameter on the source endpoint, "afterConnectScript" to a value of: SET client_encoding 'SQL_ASCII'