Qlik replicate connect kafka time out.

[zhangsq24]

Qlik replicate connect kafka time out. the detail message and Diagnostics Package as follow:

00004319: 2022-01-28T18:54:51 [SORTER ]I: Final saved task state. Stream position 41;637789640822053300;20220124164622019746, Source id 640511, next Target id 2508109, confirmed Target id 2508105, last source timestamp 1643367267203815 (sorter.c:770)

00004329: 2022-01-28T18:55:43 [SOURCE_UNLOAD ]E: RetCode: SQL_ERROR SqlState: HY008 NativeError: -952 Message: [IBM][CLI Driver][DB2/LINUXX8664] SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014

Line: 426 Column: -2 [1022502] (ar_odbc_stmt.c:3360)

00004329: 2022-01-28T18:55:43 [SOURCE_UNLOAD ]W: Error encountered while FETCH-ing data from table 'SAPEHD.AUFM' (db2luw_endpoint_unload.c:315)

00004328: 2022-01-28T18:59:02 [TARGET_LOAD ]E: Reached Time out while waiting for acks from kafka. [1020401] (queue_utils.c:158)

[SwathiPulagam · Accepted solution]

Hi,

Seems like the issue is with your Kafka broker server performance.

Please add the below internal parameters to your kafka endpoint:

set internal parameter resultsWaitMaxTimes=1000 and resultsWaitTimeoutMS=20000

Thanks,

Swathi