topic Re: QVX_PIPE_ERROR in Archived Groups

QVX_PIPE_ERROR

Anonymous — Wed, 23 Jul 2025 14:48:52 GMT

Got a few failures reloading QV applications on QVS. Log files, in all cases, ended with this:

QVX_PIPE_ERROR:

Error: OLEDB read failed

General Script Error

Execution Failed

Execution finished.

None of the applications is using QVX, all load data from SQL database using OLEDB connect, and from Excel files. The error message is apparently misleading. The only common thing in all cases that there were two reloads running at the same time - one is triggered by scheduler, another by EDX.

Repeating reload at the time when nothing else is reloading - works fine.

Appreciate any comments.

Thank you

Michael

Re: QVX_PIPE_ERROR

rwunderlich — Wed, 05 Jun 2013 05:57:07 GMT

Hi Micheal,

Did you ever get any resolution on this? I've got a customer with the same QVX_PIPE_ERROR occuring randomly on a single application during server reloads.

-Rob

Re: QVX_PIPE_ERROR

konrad_mattheis — Wed, 05 Jun 2013 09:43:59 GMT

Hi,

@Michael: Qlikview is using QVX to transfer the data between the connector(32/64) process an the qlikview application.

@Rob: I had this bug in combination with the navision odbc driver, but QT support told me that is an error of the odbc driver, so they closed the case.

bye

Konrad

Re: QVX_PIPE_ERROR

Anonymous — Wed, 05 Jun 2013 12:01:53 GMT

Hi Rob,

No, I didn't do anything about it. When I get notification about the reload failure, I just initiate reload again. Going to upgrade to QV 11.20 SR2 soon, will see if it changes anything.

Konrad,

Thanks for this info. I don't use ODBC connection.

Regards,

Michael

Re: QVX_PIPE_ERROR

Anonymous — Fri, 14 Jun 2013 14:47:51 GMT

Upgrading to QV11.20 SR2 didn't help.

Changed number of tries in "task execution options" from the default value 1 to 2. Hopefully it will help.

Re: QVX_PIPE_ERROR

Fri, 14 Jun 2013 15:48:48 GMT

Hi,

Amongst the greats of the community....i wud like to present what i tried and it worked for me.

May be it helps you as well:

I noticed that if i'm fetching multiple tables in a single qvw, saving them to qvds and dropping the table,one by one,i get the error in the script exceution progress only when the 2nd table is fetched and not for the 1st table fetch.

So this is what i did:

"Before every new load of the table from the Database i just copied and pasted the ODBC connection string"

For eg.

ODBC connect to DSN(username,password)

tab1:

SQL select * from tablename1;

store....qvd;

drop table tab1;

/// I got the error here

ODBC connect to DSN(username,password)

tab2:

SQL select * from tablename2;

store....qvd;

drop table tab2;

........

In case the two tables are on different servers/DSNs i used 'Disconnect' explicitly before the connecting to new DSN.

For eg.

ODBC connect to DSN1(username,password)

tab1:

SQL select * from tablename1;

store....qvd;

drop table tab1;

Disconnect;

ODBC connect to DSN2(username,password)

tab2:

SQL select * from tablename2;

store....qvd;

drop table tab2;

It worked for me. I would be pleased to know the results for you.

Thanks

Re: QVX_PIPE_ERROR

Anonymous — Fri, 14 Jun 2013 18:01:51 GMT

Interesting observation, thank you. I'll keep an eye on it.

Re: QVX_PIPE_ERROR

rwunderlich — Thu, 31 Oct 2013 00:03:09 GMT

I've tried adding a CONNECT before each SQL SELECT and it improved the problem for some time, but not completely. It appears to be a timing problem and anything that changes the timing -- and maybe slows things down -- seems to make the problem move around as well.

-Rob

Re: QVX_PIPE_ERROR

Anonymous — Thu, 31 Oct 2013 12:13:17 GMT

Yes Rob, it looks like a timing issue. When I increased "number of tries", the problem's non-existent.

I got an impression that it happens when two reloads are reading data from the same QVD at the same time.

Re: QVX_PIPE_ERROR

Fri, 01 Nov 2013 06:34:07 GMT

Hi Michael,

1) "When I increased "number of tries", the problem's non-existent."--Where can i increase the no. of tries, QMC ?

2) "I got an impression that it happens when two reloads are reading data from the same QVD at the same time."--

I'm sure it is not the reason, i reload 3 qvws parallely reading data from same qvd exactly at the same time daily(running on the success of the common qvd maker set in QMC). 2qvws again reading from same qvds at the same time daily. They've never failed.

One which has failed due to this error is their qvd makers which only read from the Database & write qvd to disk ( don't read qvds).

So, (1) seems more reasonable.

the interesting thing here is the error code: why does it contain 'QVX', something do with the connection to the datasource ?

Regards

Re: QVX_PIPE_ERROR

Anonymous — Fri, 01 Nov 2013 11:06:22 GMT

Hi qlik_techie,

1 - Yes, it is in QMC, in the task properties, tab Triggers, at the bottom, under "Task Execution Options". The default number is 1, I changed it to 2 for all tasks that run on schedule.

2 - Likely you're right. My impression's based on observation. Maybe it was when the same QVW was reloading by scheduled task and by EDX at the same time.

As for the error code, no idea why it mentions QVX. See reply from Konrad Mattheis above. (I think he originally mentioned ODBC, otherwise my response to Konrad doesn't make any sense.)

Thanks,

Michael

Re: QVX_PIPE_ERROR

Fri, 01 Nov 2013 11:20:16 GMT

Hi,

we don't have QV Publisher, it it why i don't see Triggers tab in QMC ?

any other way to increase the no. of tries ?

Thanks

Re: QVX_PIPE_ERROR

Anonymous — Fri, 01 Nov 2013 11:38:32 GMT

At this time, I don't have access to an environment with QVS without Publisher... Maybe not possible... Try to start a new discussion with this exact question.

Regards,

Michael