Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
ruili
Contributor II
Contributor II

Handling LOB columns w/o PK

I'm trying to replicate a table from MS SQL Server to SF, and setting the task to be Full Load only. This table has an LOB column and it has no PK.

Per the post attached below: "A full load-only task can get around a limitation with LOB columns that are in a table with no primary key.", I followed the post to set the task so that "Full Load Processing is ON", but the LOB column is still skipped when loading.
https://community.qlik.com/t5/Official-Support-Articles/An-Introduction-to-Qlik-Replicate-Tasks-Full...

Could you please kindly advise if this is not a valid walkaround, and the only solution is to add PK to the source table? 

Labels (1)
12 Replies
Heinvandenheuvel
Specialist III
Specialist III

>>> So looks like it is the change processing set to ON which triggers the LOB column loading issue?

Yes, as was indicated in every single reply thus far.

Hein.

 

ruili
Contributor II
Contributor II
Author

Understand.
And as a follow up, will change processing work properly for both of the conditions below:
1. PK is available for the table with LOB columns

2. MS SQL Server CDC enabled for the table with LOB columns but without PK

john_wang
Support
Support

thank you so much for your great support! @ruili 

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