topic Re: SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: -25580 Message: [Informix][Informix ODBC Driver][Informix]System error occur in Qlik Replicate

SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: -25580 Message: [Informix][Informix ODBC Driver][Informix]System error occurred

jese_murayari — Thu, 02 Sep 2021 04:52:34 GMT

Hello good evening,

I am using Qlik Replicate 2021.5.0.764, I am currently replicating an Informix source to an Aurora PostgreSQL destination.
The connections are already configured and the tasks are running, but in the logs I see the following message very repeatedly:

SOURCE_CAPTURE] E: RetCode: SQL_ERROR SqlState: HY000 NativeError: -25580 Message: [Informix] [Informix ODBC Driver] [Informix] System error occurred in network function. [1022502] (ar_odbc_stmt.c: 3974)

--------------------

The informix client that I have on the replicate server is version 4.10

Does anyone know what the problem could be or what is the cause of this message?
And if this message is repetitive, can it affect the replication of the data?

Thank you so much,
Greetings.

Re: SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: -25580 Message: [Informix][Informix ODBC Driver][Informix]System error occur

john_wang — Thu, 02 Sep 2021 11:11:06 GMT

Hello @jese_murayari ,

I'm not sure if the task can get changes from Informix source, or no changes can be captured at all. And if it's a random error.

When it comes to the error:

In general it's followed by further error info "Communication link failure". there are many reasons may lead the error. It can be termination of connection, network outage, timer expired, firewall configuration (e.g. tcp_keepidle), network settings, hardware or cabling issue, such as a faulty network card, hub or cable. From IBM documentation:

-25580 : System error occurred in network function. A system call has failed. For assistance, contact your system administrator or IBM Technical Support.

I'm list some links below, hope it helps.

https://www.ibm.com/docs/en/informix-servers/12.10?topic=products-configuring-client-windows-systems

https://www.ibm.com/support/pages/25580-error-connecting-informix-sdk-ilogin-or-connect-test-demo-or-odbc-apply-test

https://www.ibm.com/support/pages/node/517983

https://www.ibm.com/support/pages/node/231853

https://www.ibm.com/support/pages/how-further-diagnose-listener-thread-err-25580-oserr-1

And you may troubleshoot the issue by:

1- Informix Client "ConnectTest Demo" program; or

2- Config an ODBC DSN and try to access it

Regards,

John.

Re: SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: -25580 Message: [Informix][Informix ODBC Driver][Informix]System error occur

jese_murayari — Wed, 15 Sep 2021 16:33:11 GMT

good morning John,

Thank you very much for the information.
We are working normally with running tasks.
We will validate with the networking team to rule out connectivity problems.

We have already carried out connection tests to the Informix on premise database and we have no problems on that side.
Sometimes the message is random:

Message: [Informix] [Informix ODBC Driver] [Informix] System error occurred

regards,
Jesé Murayari

Re: SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HY000 NativeError: -25580 Message: [Informix][Informix ODBC Driver][Informix]System error occur

john_wang — Thu, 16 Sep 2021 01:09:29 GMT

Hello Jesé Murayari,

Thanks for your following up.

For the random error, the Informix server side log files helps too.

Regards,

John.