topic Re: QVX_UNEXPECTED_END_OF_DATA in QlikView

QVX_UNEXPECTED_END_OF_DATA

Tue, 01 Nov 2011 07:44:43 GMT

What is QVX_UNEXPECTED_END_OF_DATA? One of our Client is facing this problem, when they load data from Oracle.Please find the Snap Shots Attached

Thanks

Rupam

QVX_UNEXPECTED_END_OF_DATA

Fri, 18 Nov 2011 10:14:49 GMT

Hello,

I have the excacly same situation. Does anyone know what to do?

The problem is that it has been working ok for few weeks and now all of the sudden we receive this error!!!

Please help,

QVX_UNEXPECTED_END_OF_DATA

Fri, 18 Nov 2011 12:41:09 GMT

Hi,

It looks like i have found the solution:

In my case i was accessing the same (quite large) table subsequetly. (i was extracting table to qvd's and then dropping table after reloading it)

It took a few seconds to store it to qvd and it looks like that sql or. qv needs some time before "re-accessing" the same large table in sql.

Solution:

1 reload of the large table

2. reloading few other tables

3. and then agian reloading the same table.

In my case it works ok now.

P.S. It is funny thougn because this problem appeared all of the sudden (it was working fine for a month but now i got this error)

Cheers,

QVX_UNEXPECTED_END_OF_DATA

eliran — Sun, 18 Dec 2011 15:32:26 GMT

This has happend to me as well.

Accessing a quite large table at the end of the load script (6 million records)saving it to qvd and dropping it gave me the above error.

The solution was simpler then you have suggested, I moved the table to the start of the loading script, at the end of the list I have a lot of small tables.

That fixed the problem.

I hope it will help some one.

Regards,

Eliran.

Re: QVX_UNEXPECTED_END_OF_DATA

Tue, 10 Apr 2012 15:08:42 GMT

I'm getting this QVX_UNEXPECTED_END_OF_DATA error now loading a file from Oracle. I'm not saving it to qvd, just a simple load. It only has 365k records. It has been loading fine for quite some time, and now within the last few days I'm getting this error. Does anyone have any ideas or suggestions for the fix?

QVX_UNEXPECTED_END_OF_DATA

Tue, 17 Apr 2012 16:34:46 GMT

Has anybody found a solution to this problem? I am having the same error with a data load from Oracle?

Re: QVX_UNEXPECTED_END_OF_DATA

Thu, 19 Jul 2012 15:17:06 GMT

We are facing the same problem, though with DB2:

QVX_UNEXPECTED_END_OF_DATA: ErrorSource: IBM OLE DB Provider for DB2, ErrorMsg: CLI0108E Communication link failure. SQLSTATE=40003

Strangly it worked for some time, and then stopped. The table we are loading are not that big ~ 780 KB....

Are there any suggestions?

Re: QVX_UNEXPECTED_END_OF_DATA

Tue, 11 Dec 2012 10:26:02 GMT

I had the same error.

After reinstalling the transports to the SAP System (check all options: Import again, Overwrite objects in unconfirmed repairs, Overwrite originals), the error vanished.

It maybe that after an upgrade, not all objects are overwritten.

Re: QVX_UNEXPECTED_END_OF_DATA

Wed, 30 Jan 2013 08:20:42 GMT

I encountered this error while loading a SQL Function, the resulting table was not so large (+/- 23.000 records) but still QV did not seem to pul it of.

Any ideas on making the reload of a function more efficient?

Re: QVX_UNEXPECTED_END_OF_DATA

julian_rodriguez — Mon, 01 Apr 2013 13:16:48 GMT

Hello all...

I got the same error extracting data (about 500k records):

01/04/2013 2:13:34 AM: QVX_UNEXPECTED_END_OF_DATA:

01/04/2013 2:13:34 AM: Error: OLEDB read failed

Connecting to a Oracle database via OLEDB...

The most weird thing is that if I run the script from Qlikview Desktop, there is not problem at all... but from QVS, the task fails with the mentioned error...

I have QVS v 11.2 and Oracle 11g

Any ideas, please?

Re: QVX_UNEXPECTED_END_OF_DATA

julian_rodriguez — Tue, 02 Apr 2013 13:50:49 GMT

Solved myself...

Just deleted all tasks on the server and scheduled again.

What is the explanation of this?... I really don't know, but it worked.

Regards,

Re: QVX_UNEXPECTED_END_OF_DATA

biester — Mon, 15 Apr 2013 07:08:33 GMT

I just had the same error QVX_UNEXPECTED_END_OF_DATA when loading an Oracle database view and storing it into QVD. In my case the reason was a division by zero that occurred in the view; actually a select directly in the database already caused an error ORA-01476, so nothing wrong with QlikView in my case.

Rgds,

Joachim

Re: QVX_UNEXPECTED_END_OF_DATA

Mon, 22 Dec 2014 20:37:01 GMT

I realize that this is an old question but I encountered the same issue today and wanted to share more details as I'm sure others will encounter this in the future.

The problem in my case was that if I run the query in any SQL Query window it would execute fine and would start returning data ... then it would crash on record 300,000+. In QlikView they execute the query and the expectation is one of two things ... Query fails because there is something wrong with it, or the query obviously worked because SQL starts transferring data. QlikView's data extraction keeps pulling packet after packet of data back and suddenly encounters an error.

In my specific case I was doing a DateDiff in SQL to compare two field values. When it encountered a brand new value today of the year 9201 (7,000 years in the future) the query crashes. All QlikView knows is that the data mysteriously ended abruptly.

Hope this helps those 7,000 years in the future who google the search term that leads you to this community post.

Re: QVX_UNEXPECTED_END_OF_DATA

maksim_senin — Tue, 23 Dec 2014 05:13:17 GMT

Hi,

Restarting of QVS task helped me, but unfortunatelly it does not guarantee the error disappeared.

Best regards,

Maxim

Re: QVX_UNEXPECTED_END_OF_DATA

khasimvali85 — Wed, 05 Aug 2015 09:57:43 GMT

Hi,

I am also exactly same issue coming

please give anyone for this solution

waiting for reply

Error:QVX_UNEXPECTED_END_OF_DATA

Regards,

Khasim.

Re: QVX_UNEXPECTED_END_OF_DATA

dbaksa_1 — Tue, 22 Sep 2015 12:11:03 GMT

I just encountered the same issue when using OPENQUERY through a linked server. I found that limiting the number of columns in the query corrected my issue.

I hope this helps!!!

Dan

Re: QVX_UNEXPECTED_END_OF_DATA

chrissurguine — Fri, 19 Feb 2016 14:28:36 GMT

Just confirming Dalton's observation - this is related to a query failure while returning data from the DBMS. In other words, the query parses correctly, but an expected error occurs after data starts returning.

In my case, running it in Query Analyzer returned an error message:

Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Drilling down further, in my case a subquery in the From clause of my query was returning multiple values where multiple values should never have returned. Once I corrected the data causing the multiple values, the query (and load script) ran fine.

Re: QVX_UNEXPECTED_END_OF_DATA

Wed, 06 Jul 2016 12:59:39 GMT

Hi I encountered the same issue while connecting via Rest API connector. Manual reload from desktop worked but QVS task always failed. This is my error message:

2016-07-06 08:51:54 QVX_UNEXPECTED_END_OF_DATA: DNS error

2016-07-06 08:51:54 Error: Custom read failed

2016-07-06 08:51:54 General Script Error

2016-07-06 08:51:54 Execution Failed

2016-07-06 08:51:54 Execution finished.

Re: QVX_UNEXPECTED_END_OF_DATA

ellyodelly — Fri, 23 Sep 2016 15:42:38 GMT

I might as well join the group...

my error reads:

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1001, ErrorCode: 4294965484, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver]

The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), o

r there is not enough temporary storage space on the disk to store the query result.

using ODBC to an ACCESS database- I have 6 columns < 10k rows. This qvw reloads every 15min. out of 10 refreshes on average 4 will fail the rest succeed.

any suggestions? anyone find the answer?

Re: QVX_UNEXPECTED_END_OF_DATA

Anonymous — Wed, 28 Sep 2016 15:07:29 GMT

I have just had the error accessing a SQL database.

It seems to be related to bad data. I had a datediff calculation in the SQL and the one field wasn't valid, so it basically couldn't perform the calculation. When I added a WHERE clause to the query and eliminated those bad records, it worked fine. The data extract is over 23 million rows.

This would explain why the query can run perfectly for a long time and then suddenly crash; as well as why it would happen with different data sources. If there is new data that comes into that table which is problematic it would crash.

Hope that helps.