topic Re: Unusual Error for large DB2 source tables, and unusual behavior of tasks in Qlik Replicate

Unusual Error for large DB2 source tables, and unusual behavior of tasks

Ashs — Thu, 28 Sep 2023 18:27:54 GMT

Hi Team,

I am seeing some unusual behavior of qlik tasks. When I try to start a task it hangs for long with status 'Starting' and also when I try to stop it, it again takes lots of time. Not sure what the issue is. Also is there any way to handle it from qlikreplicate web console (without going to windows server).

Another issue noticed it while doing a full load, some tables ends in error with message as below

"UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT error encountered while FETCH-ing data from table 'IBMILIB.TABLE'
RetCode: SQL_ERROR SqlState: 07005 NativeError: -227 Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0227 - FETCH not valid, cursor SQL_CUR990BD360 in unknown position."

Could you suggest what is the reason behind it and how it can be resolved?

Thanks

Ash

Re: Unusual Error for large DB2 source tables, and unusual behavior of tasks

john_wang — Fri, 29 Sep 2023 01:42:01 GMT

Hello @Ashs ,

Thanks for reaching out to Qlik Community here!

Another issue noticed it while doing a full load, some tables ends in error with message as below

"UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT error encountered while FETCH-ing data from table 'IBMILIB.TABLE'
RetCode: SQL_ERROR SqlState: 07005 NativeError: -227 Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0227 - FETCH not valid, cursor SQL_CUR990BD360 in unknown position."

There are different reasons that may lead to this error. Let's troubleshoot it by steps:

Open DB2i source endpoint
Go to the Advanced tab
Go to the Additional ODBC connection properties
Add below connection string in the input label:
waitLockTimeout
set its value to 300 (seconds, = 5 minutes)

Try to run the task again to see if the problem disappears. You may adjust the value to fit your environment.

Other options:
How to Filter Table that has heavy updates and locking on iSeries

When I try to start a task it hangs for long with status 'Starting' and also when I try to stop it, it again takes lots of time. Not sure what the issue is.

Looks like Replicate was trying to get some metadata information however the server did not response in time. You may check task log file to understand what operations were doing during the time.

Hope this helps.

Regards,

John.

Re: Unusual Error for large DB2 source tables, and unusual behavior of tasks

Ashs — Mon, 02 Oct 2023 12:58:42 GMT

Thanks John for your suggestions. It worked!!

Re: Unusual Error for large DB2 source tables, and unusual behavior of tasks

Ashs — Mon, 02 Oct 2023 13:03:20 GMT

For the second task hanging in status 'Starting', it was not sure what the error is with it. But I exported that task and imported again by changing name of task and it is working without any issue. I checked both jsons and there is no change between those except second one is having different job name and description (prefix - sample to first one).

Re: Unusual Error for large DB2 source tables, and unusual behavior of tasks

mr73 — Wed, 15 Oct 2025 16:36:47 GMT

I join in on this topic, because I have the same issue.

00298243: 2025-10-15T17:39:15:797645 [TASK_MANAGER ]W: Table 'NTH_DAT'.'REGIS0F' (subtask 1 thread 0) is suspended. RetCode: SQL_ERROR SqlState: 07005 NativeError: -227 Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0227 - FETCH not valid, cursor SQL_CUR0C135B40 in unknown position.; UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT error encountered while FETCH-ing data from table 'NTH_DAT.REGIS0F' (replicationtask.c:3239)

I try to follow your suggestion for set waitLockTimeout but I don't see the Additional ODBC connection properties in my endpoint setting (DB2 for iSeries source).
Qlik version: 2024.11

Thanks.
Marco Riva

Re: Unusual Error for large DB2 source tables, and unusual behavior of tasks

john_wang — Thu, 16 Oct 2025 02:06:08 GMT

Hello Marco Riva, @mr73

Thanks for the follow-up.

You can enter the parameter manually — it will automatically appear as shown below:

(Screenshot from Replicate 2025.5)

Hope it helps.

John.

Re: Unusual Error for large DB2 source tables, and unusual behavior of tasks

Dana_Baldwin — Thu, 16 Oct 2025 16:48:43 GMT

Hi @mr73

Please note, the internal parameters are case sensitive. You also have the option of entering an exclamation point to see a full list so you can scroll down and select it.

General disclaimer: Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.

Setting advanced connection properties | Qlik Replicate Help

Thanks,

Dana

Re: Unusual Error for large DB2 source tables, and unusual behavior of tasks

mr73 — Thu, 16 Oct 2025 20:55:46 GMT

Hi Dana. Wonderful tip.

Thanks a lot.

Bye

Marco