Failed Reload - QVX_PIPE_ERROR

[stuwannop]

Hi Everyone

All of a sudden none of my Qlikview documents that use an OLEDB connector will reload anymore from QVS. In the log file, I get the following error:

QVX_PIPE_ERROR:

20/01/2014 10:49:19:       Error: OLEDB read failed

I am not using QVX at all I just use the OLE DB connection string (which I have re-created and still get the same error). The reloads work perfectly fine when I do them on my laptop but when I try to run them on the server (either using reloads on QMS or using the client I have installed on the server) they just stop with the error message above.

Any ideas?

For what it's worth the system info (Qlikview server) is below:

Product Information
		Product name	QMS Backend Core x64
		Client Build Number	11.0.11154.0
		Target Platform	x64
		Publisher License Key	No License
		Service authentication	AD groups
	Machine Information
		Computer Name	VIRAPPS1
		Operating System Version	Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.0.6002 Service Pack 2)
		.NET Version	4.0.30319.1008
		Physical Memory	12286Mb
		Available Memory	7512Mb
	CPU Information
		CPU 0	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 1	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 2	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 3	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz

ReloadEngine@virapps1 at http://virapps1:4720/QDS/Service
	Product Information
		Product name	QlikView Distribution Service x64
		Client Build Number	11.0.11154.0
		Target Platform	x64
	Machine Information
		Computer Name	VIRAPPS1
		Operating System Version	Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.0.6002 Service Pack 2)
		.NET Version	4.0.30319.1008
		Physical Memory	12286Mb
		Available Memory	7512Mb
	CPU Information
		CPU 0	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 1	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 2	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 3	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz

QVS@virapps1 at qvp://virapps1/
	Server System Info
		Operating System	Windows Server (R) 2008 Standard Service Pack 2 (64 bit edition)
		Operating System Version	6.0.6002
		Wow64 mode	Not using Wow64
		QlikTech Product	QlikViewServer 64-bit Edition (x64)
		Product Version	11.00.11154.0
		Server License Key	4404 **** **** ****
		CPU Target	x64
		Country	44 United Kingdom United Kingdom
		Language	0809 English (United Kingdom) English
		Server Collaboration	Enabled
		Number of CPUs	4
		CPU 0	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz 2666MHz
		CPU 1	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz 2666MHz
		CPU 2	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz 2666MHz
		CPU 3	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz 2666MHz
		Physical RAM(MB)	12286
		VMCommitted(MB)	1936
		VMAllocated(MB)	2120
		VMFree(MB)	7512
		VMLargestFreeBlock(MB)	7512
		Local Time	2014-01-20 11:03
		GMT Time	2014-01-20 11:03

DSC@virapps1
	Product Information
		Product name	QlikView Directory Service Connector x64
		Client Build Number	11.0.11154.0
		Target Platform	x64
	Machine Information
		Computer Name	VIRAPPS1
		Operating System Version	Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.0.6002 Service Pack 2)
		.NET Version	4.0.30319.1008
		Physical Memory	12286Mb
		Available Memory	7511Mb
	CPU Information
		CPU 0	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 1	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 2	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 3	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz

QVWS@virapps1
	Product Information
		Product name	QVWebServerSettingsService
		Client Build Number	11.0.11154.0
		Target Platform
	Machine Information
		Computer Name	VIRAPPS1
		Operating System Version	Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.0.6002 Service Pack 2)
		.NET Version	4.0.30319.1008
		Physical Memory	12286Mb
		Available Memory	7511Mb
	CPU Information
		CPU 0	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 1	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 2	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz
		CPU 3	Intel(R) Xeon(R) CPU           X5550  @ 2.67GHz

[Anonymous]

Hi Stuart,

Looks familiar.  See if this helps: http://community.qlik.com/thread/74390

Regards,

Michael

[stuwannop]

Hi Michael

I can't seem to be able to view that thread I'm afraid - I get an "Unauthorized" message saying the content is restricted.

Thanks

Stu

[Anonymous]

Sorry, it is in a group.
In essence, I had the same problem.  It's gone now.  The changes I've made:
- Upgraded QV Server to 11.20 SR2
- Increased number of tries for each production task from 1 (default) to 2.  It is on the "Triggers" tab.
Besides, there was a recommendation to use CONNECT statement before every new SQL SELECT, and DISCONNECT statement  before every new CONNECT, but I didn't have to do it.

Regards,
Michael

[vlad_komarov]

Michael,

This problem occures on my system occasionally (I am running v. 11.2 SR2 and I have modified the Attempts count to 2). Looks like this issue was resolved in v.11.0 SR3 (bugID 62361), but I could not find any references about similar issue resolved in v. 11.2.

It seems to be a resource allocation issue (occurs on DEV server with less RAM and never occurs on PROD server), so I hope it is resolved in one of recent 11.2 updates.

Did not try the CONNECT/DISCONNECT combination yet, but it might be a solution for me.

Thanks for the reference.

Regards,

Vladimir

[djsampat]

The issue is most likely systems resources. Check the QVS.exe process to see if it consumes a large amout of the CPU or Memory. A Qlikview server service restart may help, but a actual Windows Server restart should fix it for a week or so depending on your qvd reload size.

This link below may be helpful as well.

http://www.qlikisrael-support.com/Knowledgebase/Article/GetAttachment/142/2093344