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

[Ashs]

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

[john_wang · Accepted solution]

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:

1. Open DB2i source endpoint
2. Go to the Advanced tab
3. Go to the Additional ODBC connection properties
4. 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.

[Ashs · Accepted solution]

Thanks John for your suggestions. It worked!! 

[Ashs · Accepted solution]

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).  

[mr73]

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

[john_wang]

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.

[Dana_Baldwin]

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

[mr73]

Hi Dana. Wonderful tip.

Thanks a lot.

Bye

Marco