topic Re: Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database in Qlik Replicate

Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database

ag072023 — Fri, 01 Mar 2024 13:28:00 GMT

I have a qlik replicate task that replicate data from i-series as source endpoint to SQL server as target endpoint.

I am seeing following message in log files. Tasks keep waiting for 20-30 mins before it starts replicating data. I am not able to figure out why it is waiting for 20-30 mins before replicating data.

Qlik replicate version : May 2023

[SORTER_STORAGE ]V: Updating transaction storage status, iNonDummyForwardedTransactions = 0 (transaction_storage.c:6632)
[SORTER_STORAGE ]V: Finding oldest transaction in memory, #TransactionBuffers = 0, #ForwardedTransactionBuffers = 0, #TableBuffers = 0 (transaction_storage.c:2904)

Re: Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database

john_wang — Fri, 01 Mar 2024 14:09:18 GMT

Hello @ag072023 ,

Thanks for reaching out to Qlik Community!

Seems in some DB2i system, the journal validation or other system tables access take long time. Would you please turn on "Skip Journal Validation" and try again?

BTW, you may turn of one of the option, Full Load, or Change Processing to know the issue occurs in which stage.

If the problem persists, please open a support ticket with SOURCE_UNLOAD/SOURCE_CAPTURE to Verbose and attach the Diag Package, we will check for you.

Hope this helps.

John.

Re: Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database

ag072023 — Fri, 01 Mar 2024 14:04:26 GMT

Option 'Skip journal validation' is already turned off. changing it into FULL load runs fine. However, stopping and resuming task waits for 20-25 mins to read from memory.

Re: Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database

john_wang — Fri, 01 Mar 2024 14:08:45 GMT

Hello @ag072023 ,

I've got other articles about the same issue, see:

Qlik Replicate DB2 iSeries Source: Task takes a long time to start

qlik replicate - unable to proceed from main loop execution

Good luck,

John.

Re: Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database

john_wang — Fri, 01 Mar 2024 14:13:11 GMT

Hello @ag072023 ,

Option 'Skip journal validation' is already turned off

The option should be ticked to enable 'Skip journal validation'.

Any clue in task log file if set to Verbose?

thanks,

John.

Re: Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database

ag072023 — Fri, 01 Mar 2024 14:31:29 GMT

Let me enable 'Skip journal validation' and test it.

task log file is not set to Verbose.

Re: Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database

ag072023 — Fri, 01 Mar 2024 15:35:57 GMT

Thanks @john_wang . enabling 'Skip Journal validation' resolved the issue.

Re: Replicate task keeps waiting for first 20-25 mins before starting to read journal from source endpoint i-series database

john_wang — Fri, 01 Mar 2024 15:44:37 GMT

Glad to hear that @ag072023 , thank you so much for the feedback!

Do you mind to mark "Accept as Solution" to help other users to find the answer easier.

Have a nice weekend,

John.