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

[Nanda_Ravindra]

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

1. Go to Settings 
2. Open Character substitution
3. In Unsupported source characters by character set, configure:
   
   Character set: UTF-8
   Substitute character: U+ 20
   
   
4. Click OK
5. Reload the task

Environment

• Qlik Talend Cloud Data Integration