Qlik Replicate Db2i Source: E: Error parsing

[Bill_Steinagle]

Replicating more than 300 Tables from DB2i fails, and the task is set into recovery mode. The problem may be first seen after an upgrade from Qlik Replicate 2022.5 to 2023.5.

The error logged:

[SOURCE_CAPTURE ]E: Error parsing [1020109] (db2i_endpoint_capture.c:652)
[TASK_MANAGER ]I: Task error notification received from subtask 0, thread 0, status 1020109

Resolution

The default of Max number of Tables In Journal Filter passed to DB2i is set to 300. This value must be increased if you have more than 300 tables in the task. An Internal Parameter can be set to increase the value.

To increase Max number of Tables In Journal Filter:

1. Go to the  DB2i Source Endpoint connection
2. Switch to the Advanced tab
3. Click Internal Parameters
4. Enter '!' in the Parameter drop-down list and select MaxTablesInJournalFilter
5. Add the Value as required if your task has more than 300 tables
   
   

Cause 

The default of Max number of Tables In Journal Filter passed to DB2i is set to 300.

Internal Investigation ID(s) 

QB-21170

Environment

Qlik Replicate 2023.5