article Qlik Talend Cloud Data Integration: Data load error while replicating data from Oracle source to Snowflake target table in Official Support Articles

Qlik Talend Cloud Data Integration: Data load error while replicating data from Oracle source to Snowflake target table

Nanda_Ravindra — Thu, 20 Feb 2025 15:09:18 GMT

The following error is thrown in a full load when replicating data from Oracle source to Snowflake target in Qlik Talend Cloud Data Integration:

[TARGET_LOAD ]E: RetCode: SQL_ERROR SqlState: 22000 NativeError: 100144 Message: Invalid UTF8 detected in string '?*��?&??9?ʏ"?'

Cause

The columns datatype in Oracle is defined as Varchar(64) and has hash data. This causes replication to fail.

Resolution

Set the character set to UTF-8 to U+20 to resolve the issue

Go to Settings
Open Character substitution
In Unsupported source characters by character set, configure:

Character set: UTF-8
Substitute character: U+ 20
Click OK
Reload the task

Environment

Qlik Talend Cloud Data Integration