Qlik Replicate processing tables with LOB Columns in transactional apply mode

[Bill_Steinagle]

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

1. Disable Unlimited Lob on the Task setting > Metadata > Target Metadata tab:
   
   
   
   
2. 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.

Related Content 

LOB handling options

Internal Investigation ID(s) 

QB-24483

Environment

Qlik Replicate