Re: ODBC Error - Qlik Community

markgraham123 · ‎2015-07-20

HI all,

I'm fetching the data from ODBC tables (huge)

Script load gets failed with below error:

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 08S01, ErrorCode: 10054, ErrorMsg: [IBM][System i Access ODBC Driver]Communication link failure. comm rc=10054 - CWBCO1047 - The System i server application disconnected the connection

Error: ODBC read failed

General Script Error

Any help is appreciated.

maksim_senin · ‎2015-07-21

Hi,

Not sure since it was quite a long time ago, but it seems that you have some troubles with your query. Check whether it works well outside of QV. In my case there were some problems with either subqueries or formats of values.

Best regards,

Maxim

krishna20 · ‎2015-07-21

Hi,

Delete the old connection string and try with new connection string. Then, you may get an idea where will be the error is.

PrashantSangle · ‎2015-07-21

Hi,

Contact to your DBA team and asked them that they have taken any down time during your extractor was executing.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2015-07-21

Hello,

This is generally because of some formatting problem of some columns in the sql.

1. Try with limited load.

2. If result is same try to eliminate the columns to see which one is problematic.

Another cause might be related to timeout or network problems. If you can trace it on source side, try to do so to locate the problem. Maybe it's rejected by source. That's also possible, looking at the error.

BR

Serhan