Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
jese_murayari
Contributor II
Contributor II

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

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.

3 Replies
john_wang
Support
Support

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/25580-error-connecting-informix-sdk-ilogin-or-connect-test-demo-or...

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
jese_murayari
Contributor II
Contributor II
Author

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

john_wang
Support
Support

Hello Jesé Murayari,

Thanks for your following up.

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

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!