topic Re: Re: [ASK] can't load qvd from network shared folder in QlikView

[ASK] can't load qvd from network shared folder

Tue, 07 Jan 2014 07:26:33 GMT

Hello QV Developer

i have a problem that i can not load a qvd from network shared folder

i have 2 machine (A and B)

my source data is in B->QVD

i've give permission for QVD folder to be readable by A

i have some QVD files in that QVD folder (ex. 1,2,3,4)

i create a QVW file in A and load from \\B\QVD\

i able to load QVD 1,2, and 3

but not QVD 4

reloading is just stuck and stop doing nothing

Elapsed time stop clicking

i've checked task manager and CPU usage is only between 00-05, Memory usage is stuck in 1gb

i've tried to load QVD 4 from A, and have no problem

why is this happening?

anyone have clue?

many thx

Re: [ASK] can't load qvd from network shared folder

Siva_Sankar — Tue, 07 Jan 2014 07:28:19 GMT

Did you try checking the log file for information??

Regards.

Siva

Re: [ASK] can't load qvd from network shared folder

Tue, 07 Jan 2014 07:30:48 GMT

do you mean log from qlikview server?

i use no qlikview server, only qlikview desktop in my machine A

Re: [ASK] can't load qvd from network shared folder

MK_QSL — Tue, 07 Jan 2014 07:35:29 GMT

Go to Settings - Document Properties - General Tab

tick Generate Logfile option...

Now Reload the file.... this will create a Logfile in txt format in same folder your application is....

Read this file and try to find whether any problem is there or not...

Re: [ASK] can't load qvd from network shared folder

Tue, 07 Jan 2014 07:38:09 GMT

How big is the data set. I mean QVD Size. If its huge file some times it's happen. Even i face the same probelm.

What i did is, I kept that qvd script is first. I mean loaded the data first from whichever getting the error. It got resolve. If still persisting the problem share me screenshot of error.

Regards,

Santhosh G

Re: [ASK] can't load qvd from network shared folder

Siva_Sankar — Tue, 07 Jan 2014 07:40:39 GMT

If you see any permission related errors in the log file, try giving 'Full Control' instead of Read access and then load the QVW.

Regards.

Siva

Re: Re: [ASK] can't load qvd from network shared folder

Tue, 07 Jan 2014 07:55:14 GMT

Loading is still running, but no data fetched show in load box, and still stuck

there's no error in the log file.

i've copied the content of log file below :

07/01/2014 14:43:03:	Execution started.
07/01/2014 14:43:03:	QlikView Version:11.0.11426.0
07/01/2014 14:43:03:	CPU Target	x64
07/01/2014 14:43:03:	Operating System	Windows 7 Ultimate (64 bit edition)
07/01/2014 14:43:03:	Wow64 mode	Not using Wow64
07/01/2014 14:43:03:	MDAC Version	6.1.7600.16385
07/01/2014 14:43:03:	MDAC Full Install Version	6.1.7600.16385
07/01/2014 14:43:03:	PreferredCompression	2
07/01/2014 14:43:03:	EnableParallelReload	1
07/01/2014 14:43:03:	ParallelizeQvdLoads	1
07/01/2014 14:43:03:	AutoSaveAfterReload	0
07/01/2014 14:43:03:	BackupBeforeReload	0
07/01/2014 14:43:03:	EnableFlushLog	0
07/01/2014 14:43:03:	SaveInfoWhenSavingFile	0
07/01/2014 14:43:03:	UserLogfileCharset	0
07/01/2014 14:43:03:	OdbcLoginTimeout	-1
07/01/2014 14:43:03:	OdbcConnectionTimeout	-1
07/01/2014 14:43:03:	ScriptWantsDbWrite	false
07/01/2014 14:43:03:	ScriptWantsExe	false
07/01/2014 14:43:03:	LogFile CodePage Used:	1252

07/01/2014 14:43:03: 0002 SET ThousandSep='.'

07/01/2014 14:43:03: 0003 SET DecimalSep=','

07/01/2014 14:43:03: 0004 SET MoneyThousandSep='.'

07/01/2014 14:43:03: 0005 SET MoneyDecimalSep=','

07/01/2014 14:43:03: 0006 SET MoneyFormat='$#.##0;($#.##0)'

07/01/2014 14:43:03: 0007 SET TimeFormat='h:mm:ss'

07/01/2014 14:43:03: 0008 SET DateFormat='DD/MM/YYYY'

07/01/2014 14:43:03: 0009 SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]'

07/01/2014 14:43:03: 0010 SET MonthNames='Jan;Feb;Mar;Apr;Mei;Jun;Jul;Agust;Sep;Okt;Nop;Des'

07/01/2014 14:43:03: 0011 SET DayNames='Sen;Sel;Rabu;Kamis;Jumat;Sabtu;Minggu'

07/01/2014 14:43:03: 0013 LOAD *

07/01/2014 14:43:03: 0014 FROM

07/01/2014 14:43:03: 0015 [\\B\QVD\4.qvd]

07/01/2014 14:43:03: 0016 (qvd)

07/01/2014 14:43:03:

3 fields found: AAA,BBB,CCC

Re: Re: [ASK] can't load qvd from network shared folder

Siva_Sankar — Tue, 07 Jan 2014 08:42:27 GMT

as mentioned by Santhosh Kumar above, did you check the QVD file size?

Regards.

siva