Replicating CLOB

[guilherme-matte]

Hello guys

We are replicating from a Microsoft SQL Server DB to an Azure DB.

Whenever replicating, i receive the following error:

Column 'XXXX' was removed from table definition 'TableName': the column data type is LOB and the table has no primary key or unique index.

Is there any workaround that can be done to get these LOB replicated?

Kind Regards

[SwathiPulagam · Accepted solution]

Hi @guilherme-matte ,

This is a documented limitation:
When replicating a table that has no Primary Key or Unique Index, LOB columns will not be replicated.

Below is the link for your reference:

https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/Introduction/Limitations.htm

Thanks,

Swathi

[guilherme-matte]

Thank you Swathi!

I read about the limitation, but  tried asking because i also found some work around depending on which DB was being used as a source.

Appreciate the answer anyways!

Kind regards

Matte

[Michael_Litz]

Hi,

Just wanted to add that you could load the table with no primary key and lob fields with no issues if he task is full load only. The limitation only applies to CDC enabled tasks.

Thanks,
Michael

[Kaushik]

Hi 
you can  increase the limit of lob in task settings   under metadata in target metadata

[SushilKumar]

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar