topic ODBC Error in QlikView

ODBC Error

markgraham123 — Mon, 20 Jul 2015 17:58:58 GMT

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.

Re: ODBC Error

maksim_senin — Tue, 21 Jul 2015 05:52:27 GMT

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

Re: ODBC Error

krishna20 — Tue, 21 Jul 2015 06:12:43 GMT

Hi,

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

Re: ODBC Error

PrashantSangle — Tue, 21 Jul 2015 06:15:23 GMT

Hi,

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

Regards,

Re: ODBC Error

Anonymous — Tue, 21 Jul 2015 06:44:17 GMT

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.

Serhan