Section Access Problem on QEMC

[#1]

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]

Any help

[#3]

Any Help ?

[#4]

Any Help ??

[#5]

Please provide your Section Access script so we can take a look.

Also, have you added the service account that are running QlikView Distribution service to the Section Access script?

It has to be added as admin to be able to open document

[Bill_Britt]

Hi,

Can you post the whole task log?  Need to look at the resources.

Bill

[#7]

The service account which runs distribution service already added to section table.

I have another application with runs section access without any problem.

Script:

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, DOMAIN\QVSERVIE

ADMIN, DOMAIN\SDATHU

];

SECTION APPLICATION ;

This is the Error Log File email:

The task "Reload and Distribute of Stage\Test\SA.qvw" failed. Part of the log file follows:

12/11/2013 9:28:25 PM   Error  Document open call failed. The document might require username and password.

12/11/2013 9:28:25 PM   Error  The document failed to open.

12/11/2013 9:28:26 PM   Error  Document could not be opened

12/11/2013 9:28:26 PM   Error  The task "Reload and Distribute of Stage\Test\SA.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\Test\SA.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)

[#8]

This is the error log file e-mail:

The task "Reload and Distribute of Stage\Test\SA.qvw" failed. Part of the log file follows:

12/11/2013 9:28:25 PM   Error  Document open call failed. The document might require username and password.

12/11/2013 9:28:25 PM   Error  The document failed to open.

12/11/2013 9:28:26 PM   Error  Document could not be opened

12/11/2013 9:28:26 PM   Error  The task "Reload and Distribute of Stage\Test\SA.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\Test\SA.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)

[#9]

Does the other application have the exact same SA script ?

[#10]

Yes I have the same Section Access script on other application.

I tested without domain name in NTNAME on section table. that works.

I don't know why some application works with DOMAIN name & this application works without DOMAIN name.?

Is there any specific reason ?