10 Replies Latest reply: Jul 18, 2014 5:53 PM by Joseph Chen RSS

    Section Access Problem on QEMC

    Srikanth P

      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 .

        • Re: Section Access Problem on QEMC
          Srikanth P

          Any help

          • Re: Section Access Problem on QEMC

            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

              • Re: Section Access Problem on QEMC
                Srikanth P

                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)

              • Re: Section Access Problem on QEMC
                Bill Britt

                Hi,

                 

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

                 

                Bill

                  • Re: Section Access Problem on QEMC
                    Srikanth P

                    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)

                  • Re: Section Access Problem on QEMC
                    Joseph Chen

                    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.