Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-12-11 11:14 AM

Section Access Problem on QEMC

Hello, I implemented the section access at script level by using SECTION Table. I was reloaded the report at my desktop client and I am trying to reload on the publisher. I am distributing the qvw document to folder. But my task got failed with below error:

The task "Reload of Stage\ODS - Security Check.qvw" failed. Part of the log file follows:

12/11/2013 11:02:25 AM               Error      Document open call failed. The document might require username and password.

12/11/2013 11:02:25 AM               Error      The document failed to open.

12/11/2013 11:02:26 AM               Error      Document could not be opened

12/11/2013 11:02:26 AM               Error      The task "Reload of Stage\ODS - Security Check.qvw" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: D:\QlikView\Publisher\Stage\ODS - Security Check.qvw

   at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

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

   at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

   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)

Please help me what is wrong in my file .

2,485 Views
0 Likes
10 Replies
Not applicable
‎2014-07-18 05:51 PM
Author

I solved this problem by adding the service account running the QV server to my session access table as the following example shows (I am using AD authentication).

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, NTDOMAINSID

    ...

    ADMIN, <service_account_id>, <nt_domain_id>

];

Remember to reload the document before copying the QVW to the server so the new service account credential is in the document. Then, to verify it, go to QMC, go to Documents> Source Documents, and click the document task. Click the Reload tab. There is a "Open Document" button there. Click it to verify you have no errors. Then, run it as normal and it runs fine for me.

When I got errors, I either forgot to reload the document after the change or had spelling error on the service account ID. Hope this helps.

217 Views