topic Re: Getting ERROR when running Logstream Task(DB2 I-series) in Qlik Replicate

Getting ERROR when running Logstream Task(DB2 I-series)

nabeelaslam1994 — Wed, 04 Jan 2023 20:21:37 GMT

Hello All,

I am running a CDC task using a logstream task. I am getting these errors which fails the task and when it fails, It starts itself from beginning and keeps running until it fails again with same errors. This is a DB2-ISeries AS400 task. There are two error that i get at the same time. Any help on this will be greatly appreciated??

Stream component 'st_1_MTD_AS400_MTDDATAF_LOGCDC' terminated
Stream component failed at subtask 1, component st_1_MTD_AS400_MTDDATAF_LOGCDC
Error executing source loop
Endpoint is disconnected
Connection error

RetCode: SQL_ERROR SqlState: 08S01 NativeError: 10054 Message: [IBM][System i Access ODBC Driver]Communication link failure. comm rc=10054 - CWBCO1047 - The IBM i server application disconnected the connection

Thanks,

Nabeel

Re: Getting ERROR when running Logstream Task(DB2 I-series)

Dana_Baldwin — Wed, 04 Jan 2023 20:43:16 GMT

Hi @nabeelaslam1994

1. Is it a brand-new task? Is it a new Endpoint?

2. If not, has anything changed in the environment or the design of the task? Driver update, o/s patch, etc.?

3. What is the full version number of Replicate you are running?

4. Is the network connection between Replicate and the source stable?

Thanks,

Dana

Re: Getting ERROR when running Logstream Task(DB2 I-series)

nabeelaslam1994 — Wed, 04 Jan 2023 20:57:21 GMT

1. YES NEW TASK and a new ENDPOINT.

3. It is Version 7.0

4. There is a VPN tunnel setup between the Qlik Replicate and the Source Database. Initially, there was an issue with VPN where ping was timing-out after some-time and I was seeing the errors above. Now, the VPN is stable and no ping drops but still I am seeing these error popping up.

Thanks,

Nabeel

Re: Getting ERROR when running Logstream Task(DB2 I-series)

Dana_Baldwin — Wed, 04 Jan 2023 21:13:17 GMT

Hi @nabeelaslam1994

What version of DB2 are you running, and what version of the driver is on Replicate? Version 7 supports DB2 7.2, 7.3 & 7.4. Minimum driver version is 12.64 unless Replicate is installed on Windows Server 2016, in that case use the 5733XJ1 IBM i Access Client Solutions instead.

In case you were not aware, patches are no longer being released for version 7 (also known as version Nov 2022). As a general recommendation, please consider upgrading soon.

Qlik Replicate Product Lifecycle - Qlik Community - 1837201

Thanks,

Dana

Re: Getting ERROR when running Logstream Task(DB2 I-series)

john_wang — Thu, 05 Jan 2023 01:38:27 GMT

Hello @nabeelaslam1994 ,

Total agree with @Dana_Baldwin , Replicate 7.0 (new naming is 2020.11 , or "November 2022") had reached its end of support (EOS) date at November 30, 2022, please install the supported versions Qlik Replicate Product Lifecycle . Replicate 2022.5 is highly recommended. V2022.11 is latest major release version right now.

Before start to use the new versions, please check carefully if the source/target DBs versions and the source/target Client Software versions are in Support Matrix.

Regarding the DB2i ODBC Driver, please download IBM i Access ODBC Driver version 13.64.26 (un-install the previous versions). If you still get connectivity issue then you may define an ODBC DSN, and use 3rd party ODBC Test Tools (on Windows), or "isql" (on Linux) to troubleshoot the connection issue.

Hope this helps.

Regards,

John.

Re: Getting ERROR when running Logstream Task(DB2 I-series)

nabeelaslam1994 — Thu, 05 Jan 2023 17:50:55 GMT

Hi @john_wang

The version is 13.00.01.00. Is that good or should i install the 13.64.26 one?

Thanks,

Nabeel

Re: Getting ERROR when running Logstream Task(DB2 I-series)

john_wang — Fri, 06 Jan 2023 01:08:28 GMT

Hello @nabeelaslam1994 ,

Please follow the User Guide to install the certified client versions. Maybe other version works but it's risk.

Best Regards,

John.

Re: Getting ERROR when running Logstream Task(DB2 I-series)

nabeelaslam1994 — Fri, 06 Jan 2023 04:01:39 GMT

@john_wang thanks and i will update and see if it helps.

Nabeel

Re: Getting ERROR when running Logstream Task(DB2 I-series)

nabeelaslam1994 — Wed, 11 Jan 2023 16:57:14 GMT

@john_wang @Dana_Baldwin

I confirmed that the source endpoint is at the right OS version. Replicate tool is on the latest version. Updated the ODBC driver to the version mentioned in the User guide but still seeing the same errors. It looks like somewhat between halfhour-1 hr it fails and starts the table load from row 0.

Re: Getting ERROR when running Logstream Task(DB2 I-series)

john_wang — Thu, 12 Jan 2023 09:59:32 GMT

Hello @nabeelaslam1994 ,

We'd like to suggest you opening a support ticket with SOURCE_UNLOAD/SOURCE_CAPTURE set to Trace (we may ask you increase it to Verbose if necessary) , reproduce the error and then upload the task Diag Packages to the case. Support team will help you (please do not upload the file to this article as it's open to all users).

Thank you,

John.

Re: Getting ERROR when running Logstream Task(DB2 I-series)

nareshkumar — Wed, 21 Aug 2024 18:57:57 GMT

Hi John_wang,

We are in Qlik May 2023 version and AS400 DB2 on 7.2 and ODBC driver version: '07.01.025'. As per Qlik documentation '07.01.026' is supported driver ,however it has some bugs and as per Qlik support we had rolled back '07.01.026' and stay in '07.01.025' version ..

We are still seeing the errors :RetCode: SQL_ERROR SqlState: 08S01 NativeError: 10054 Message: [IBM][System i Access ODBC Driver]Communication link failure. comm rc=10054 - CWBCO1047 - The IBM i server application disconnected the connection [1022502] (ar_odbc_stmt.c:4020)

Please advise !!

Re: Getting ERROR when running Logstream Task(DB2 I-series)

DesmondWOO — Thu, 22 Aug 2024 02:59:28 GMT

Hi @nareshkumar ,

When Replicate reported a communication error, did it automatically retry the operation? If so, did you observe the stream position moving forward?

Regards,
Desmond

Re: Getting ERROR when running Logstream Task(DB2 I-series)

john_wang — Thu, 22 Aug 2024 07:51:39 GMT

Hello @nareshkumar ,

There are several potential causes for this error, such as the database server rejecting the connection, permission issues, firewall settings, etc. Typically, the root cause lies outside of Qlik Replicate, making it difficult to diagnose the issue solely from within the tool.

I recommend opening a support ticket and providing the verbose task log files. Additionally, collaboration with your DBA or IBM team will be essential to effectively resolve the connectivity issue.

Hope this helps.

John.