Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
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)
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/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.
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
Hello Jesé Murayari,
Thanks for your following up.
For the random error, the Informix server side log files helps too.
Regards,
John.