topic Re: Cannot refresh source table in Qlik Replicate

Cannot refresh source table

harsh2 — Tue, 28 Nov 2023 14:11:34 GMT

Hi Qlik support,

Got an error while running task Source is IBM DB2 for i series and target is google big query & the table name LACTDTA'.'SALHPF got errored (not even go in loading state).

Got Following Error and Warnings

Warning: Table 'LACTDTA'.'SALHPF' (subtask 1 thread 0) is suspended. converter 836 not found; Cannot refresh source table (1) metadata

Error: Cannot refresh source table (1) metadata
converter 836 not found

Attaching Task logs also

Thanks & regards

Harsh Patel

Re: Cannot refresh source table

john_wang — Tue, 28 Nov 2023 15:46:22 GMT

Hello @harsh2 ,

Thanks for reaching out to Qlik Community!

Please set the Override CCSID to Character Set Mapping in IBM DB2 for iSeries source endpoint, map the CCSID 836 to 935, see the first line in below sample:

Run the task again and let me know if it works.

Regards,

John.

Re: Cannot refresh source table

harsh2 — Wed, 29 Nov 2023 06:38:09 GMT

Hi @john_wang

Thanks A lot for This Help

Thanks & regards

Harsh Patel

Re: Cannot refresh source table

john_wang — Wed, 29 Nov 2023 07:00:24 GMT

Hi @harsh2 ,

Glad to hear that! thanks for your update.

Regards,

John.