topic Error message QVX in QlikView

Error message QVX

Wed, 05 Oct 2011 17:11:29 GMT

Hello,

i have a unknown Error message when i reload a script that connects to a SQL Server and load a table.

First i have the message "QVX_unknown Error" in the script window of the fat client. Than i filtered the table and in a smaller load version it shows me the

Error "QVX_PIPE_ERROR" ...what can be the Problem?

Error message QVX

danielrozental — Wed, 05 Oct 2011 23:30:40 GMT

Is there a particular reason to be using QVX?

You should delete the connection string and try using an OLEDB or ODBC connection.

Error message QVX

Thu, 06 Oct 2011 07:29:56 GMT

The weird thing is i use a normal OLEDB connection...

Error message QVX

Mon, 17 Oct 2011 11:34:55 GMT

The right Error Code is :

"QVX_unexpected_end_of_data"

When i filtered the table with sql satements to a little piece than it works, but i need the full table...I thought that QlikView read everything in a table independent of the content in the table..

Re: Error message QVX

Tue, 01 Nov 2011 18:16:52 GMT

I have a similar problem. Migrated an application from QV8.5 to QV10. Ran fine in QV8.5, but now raises an error message:

QVX_UNEXPECTED_END_OF_DATA:

Error: OLEDB read failed

General Script Error

Execution Failed

The first OLEDB connection it makes to the external data source it loads 57 records successfully. The next file it attempts to load is 24,981 records...but it fails with this message. Obviously I need the whole data source. What causes this message? Update - I also get an ORA-29275 error message. I believe this is caused by an Oracle table with a "partial multibyte character". We have updated recently to include international characters. Could be a driver issue. I'm using 11g.

Error message QVX

colinh — Wed, 23 Nov 2011 07:59:25 GMT

Does anyone have any more information on this error? I have the same problem, connecting to a Microsoft AX SQL database. We moved from QV 9 on a 32 bit Win 2003 machine to QV 10 SR3 on a 64 bit Win 2008 machine last week.

I don't believe it is data related.

If I create a new document with only a full load of a large table, I get "QVX_PIPE_ERROR". If I only load a single column from the table I get "QVX_UNEXPECTED_END_OF_DATA". I am using OLE DB and I've tried changing the connection to force 32 bit - same result.

Thanks.

Re: Error message QVX

Wed, 23 Nov 2011 10:06:27 GMT

I will be out of the office starting 11/18/2011 and will not return until

11/28/2011.

I will be checking my email very infrequently. If you need immediate

assistance please contact Michael Maziarz at 205.261.6302.

Re: Error message QVX

Tue, 13 Dec 2011 16:10:12 GMT

We upgraded to QV 10 (SR4) last week and experience the exact same problem. The loading worked perfectly in QV 9 but now the loadings sometimes just stops and we get QVX_PIPE_ERROR:

If I re-run the task it sometimes executes succesfully. Nasty error indeed. I will report this to QT through our partner as a bug. Anyone else reported this to QT?

best regards,

Johan

Error message QVX

Mon, 19 Dec 2011 14:32:21 GMT

I am also getting this error after an upgrade to QV 10.

It is happening with OLE connections and with ODBC connections as well. I have reported this to QT.

It is also seems to work fine most of the time when I re-run the task or re-load it manually.

Re: Error message QVX

kevinpintokpa — Fri, 24 May 2013 15:06:03 GMT

I am receiving this error too with SQL Server. Unsure what the root cause is. It is intermittent.

Re: Error message QVX

rwunderlich — Wed, 05 Jun 2013 06:05:47 GMT

I too have a customer experiencing this error intermittently on SQL Server. This thread references a bugid

http://community.qlik.com/message/324401#324401

Not sure if it's applicable to SQL Server.

-Rob

Re: Error message QVX

Wed, 05 Jun 2013 09:14:50 GMT

We had our QV environment redesigned with new and more powerful and dedicated loading servers and the error disappeared. I can still reproduce the error on our test server when loading our 'biggest' applications. The test server is sized half in ram memory compared to our production loading servers. We use virtual machines as loading servers with 50 Gb ram and 10 cores on each without issues. I would suggest to setup a virtual machine if possible and double the amount of ram on that machine and run the loading that fails and see what happens. When upgrading from v 9 to v 10 the amount of ram used for loading increased dramatically for us. We did an investigation of memory usage together with our QV partner and QT and came to the conclusion that the memory was insufficient for our loadings in v 10. However, the loadings in v 10 were alot faster.

br,

Johan

Re: Error message QVX

Wed, 05 Jun 2013 09:28:01 GMT

It can be a performance issue. When i had this errror message i had a 12 GB Server with 4 Cores and the tables had more then 75 million data sets.

Re: Error message QVX

lawrance — Sat, 14 Jan 2017 21:42:46 GMT

Hi all,

Please find the attached document of QVX_PIPE_ERROR resolution and I hope this will help you.

Thanks,

Lawrance A