Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
harsh2
Partner - Contributor III
Partner - Contributor III

Cannot refresh source table

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

1 Solution

Accepted Solutions
john_wang
Support
Support

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:

john_wang_0-1701186341582.png

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

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

3 Replies
john_wang
Support
Support

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:

john_wang_0-1701186341582.png

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

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
harsh2
Partner - Contributor III
Partner - Contributor III
Author

Hi @john_wang 

Thanks A lot for This Help 

Thanks & regards 

Harsh Patel

john_wang
Support
Support

Hi @harsh2 ,

Glad to hear that! thanks for your update.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!