Qlik Replicate processing tables with LOB Columns in transactional apply mode

Bill_Steinagle — Wed, 24 Jan 2024 14:01:07 GMT

A Qlik Replicate task is running and is continuing to have Target Apply Latency against an Oracle Target. The table is applying the data via transactional apply mode even though the table is set up in Batch Optimized mode.

Resolution

Disable Unlimited Lob on the Task setting > Metadata > Target Metadata tab:
On the table level, verify that no override is set in its Task Settings.
1. In Designer, double-click the table from the table list.
2. Click Lob Column Handling
3. As with the Task Settings before, verify that Unlimited LOB size is not set on table level and that no other setting overrides the Task Settings as this should not be overridden at the Table Level with Unlimited Lob Support

Cause

The Unlimited LOB size will process the Table in transactional apply mode as it will not see the Table with a Primary Key. With this being set this is causing Replicate not to recognize the Primary Key / Unique Index on the Table.

Internal Investigation ID(s)

QB-24483

article Qlik Replicate processing tables with LOB Columns in transactional apply mode in Official Support Articles

Qlik Replicate processing tables with LOB Columns in transactional apply mode

Resolution

Cause

Related Content

Internal Investigation ID(s)

Environment