topic Re: Re: Re: reload error: document cannot be opened in QlikView

reload error: document cannot be opened

Mon, 26 Jan 2026 18:19:17 GMT

HI,

This morning during reload, several document failed to reload properly. One of the common reason that all document had in log was

14.10.2014 3:05:55          Error      Document open call failed. The document might require username and password.

14.10.2014 3:05:55          Error      The document failed to open.

14.10.2014 3:05:56          Error      Document could not be opened

14.10.2014 3:05:56          Error      The task "abc_6101_DEV_FullLoad" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to open document: \\test11.int\QV11Files\SourceDocuments\AbtL\6101_DEV\abc_6101_DEV.qvw

   at QDSMain.DistributeTask.OpenDocument(TaskResult taskResult, String fileName)

   at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   --- End of inner exception stack trace ---

   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

Few had the message that reload failed because the document cannot be opened. When I ran the reload again for each client, the reload went successfully. My question is that what could have gone wrong because when I reloaded them again, they all were reloaded successfully. I had not fixed anything.

How can I avoid this error in future

Shah

Re: reload error: document cannot be opened

Bill_Britt — Tue, 14 Oct 2014 12:05:51 GMT

Hi,

Do you have section access applied to the QVWs? Is any of the below checked?

Bill

Re: reload error: document cannot be opened

ashfaq_haseeb — Tue, 14 Oct 2014 12:15:38 GMT

HI,

If no Section access then, It could be due to below..

1) Performance

2) May be there was another task using the same files

3) Antivirus scanning those very files (make exceptions in your AV program).

4) some inconsistencies in that directory.

It is fine to stop the QDS service, remove/backup the content of C:\ProgramData\QlikTech\DistributionService\ and start QDS again. The folder content will be automatically recreated and any temporary files would be cleared. The directory holds temp files, reference files for the repository and log-files. No task settings would be lost, only task history.

Regards

ASHFAQ

Re: Re: reload error: document cannot be opened

Tue, 14 Oct 2014 12:21:11 GMT

Yes, section access is implemented with the following setting

There is one document which has reloaded successful but then failed during distribution

Distribute failed with errors to follow. ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to open document

The others had failed because of the earlier error message given in initial post. The issue is that these document load successfully most of the times but give this error only at times and then load successfully on next reload. We want to investige what is causing these errors

Shah

Re: reload error: document cannot be opened

Colin-Albert — Tue, 14 Oct 2014 12:25:43 GMT

Is the QDS service account included in your section access list with admin access to the complete set of data?

Re: reload error: document cannot be opened

Tue, 14 Oct 2014 12:30:15 GMT

Yes, and It is able to load successfully in 90% cases. It's only sometimes that it fails with a message that failed to open the document. It would complete successfully on next run though

Shah

Re: reload error: document cannot be opened

Bill_Britt — Tue, 14 Oct 2014 12:31:17 GMT

Ok,

Make sure the service account is in section access as admin and if you are using any reduction fields you it is as blank for the service account.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, AREA

ADMIN, SERVICE ACCOUNT NAME

USER, BOB, NORTH

USER, STEVE, SOUTH

];

Section Application;

Bill

Re: Re: Re: reload error: document cannot be opened

ashfaq_haseeb — Tue, 14 Oct 2014 12:31:17 GMT

Hi,

You have to provide admin access details here.

have a look at attached image

Regards

ASHFAQ

Re: Re: Re: reload error: document cannot be opened

Bill_Britt — Tue, 14 Oct 2014 12:34:22 GMT

You need to stay away from using this field for section access. This is used when you can't use a service account to access data.

It is best to build in the service account.

Bill

Re: Re: Re: reload error: document cannot be opened

Bill_Britt — Tue, 14 Oct 2014 12:36:04 GMT

Bill,

What version are you on?

What do you have the "Max number of simultaneous QlikView engines for distribution" set to?

Bill

Re: Re: Re: reload error: document cannot be opened

Tue, 14 Oct 2014 12:39:57 GMT

It's Qlikview 11.2 sr6. The max simultaneous Qlikview engines for distribution is set to 9

Shah

Re: Re: Re: reload error: document cannot be opened

Bill_Britt — Tue, 14 Oct 2014 12:44:51 GMT

Hi,

If this is running 90% of the time, it might be an engine issue. In the task log there should show the number of engines used when the task is started. If it is 7 or 8 then this could be the issue.

Remember that Qlik isn't the only software that uses Comm Objects on a system.

Bill

Re: reload error: document cannot be opened

Wed, 15 Oct 2014 06:16:36 GMT

Hi Bill,

Many thanks for the info that you have been providing. It indeed seems that are running at max number of reloads at simultaneously. My questions is whether I can increase the number to something more than 9? Do I have to calculate the load that server can take in terms of memory and CPU before increasing this number ?

In my opinon, its not going to be a simple answer because every reload job has its own cost related to memory and CPU so even a single reload could make the system reach 100% but my question was more related to the limit we can put in Max number of simultaneous QlikView engines for distribution or if it does not have any limit

Shah

Re: Re: reload error: document cannot be opened

Bill_Britt — Wed, 15 Oct 2014 11:46:34 GMT

Hi,

You can try increase the Desktop Heap value in the registry. Below is some information on it and please backup the registry before you make changes. As you read the below the value you are looking at changing is 1024,20480,768

You may have to play with this to get it set correctly

Memory Heap Registry change:

Change the registry setting:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows

Change the GDI and User handle max count in the registry to SharedSection=1024,20480,2048

%SystemRoot%\system32\csrss.exe ObjectDirectory=\Windows
SharedSection=1024,20480,2048 Windows=On SubSystemType=Windows
ServerDll=basesrv,1 ServerDll=winsrv:UserServerDllInitialization,3
ServerDll=winsrv:ConServerDllInitialization,2 ProfileControl=Off
MaxRequestThreads=16

Default is 1024,3072,512 in x86 or 1024,20480,768 in x64

Desktop Memory Heap Registry change:

Change the registry setting:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows

Change the GDI and User handle max count in the registry to SharedSection=1024,20480,2048

Default is 1024,3072,512 in x86 or 1024,20480,768 in x64