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: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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: 
vijayit43
Creator
Creator
‎2015-07-23 01:52 AM

PROBLEM IN DISTRIBUTION SERVICES

hi Expert ,

               we are facing problem in QlikView Reloading fail it gives following error.

(2015-07-23 02:45:02) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: E:\QV Dashboard\Sales - Ghari\SND-Sales.qvw

(2015-07-23 02:45:02) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-07-23 02:45:02) Error: --- End of inner exception stack trace ---

(2015-07-23 02:45:02) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-07-23 02:45:02) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-07-23 02:45:02) Error: --- End of inner exception stack trace ---

(2015-07-23 02:45:02) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-07-23 02:45:02) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

Please Suggest asap.

2,306 Views
0 Likes
12 Replies
ashfaq_haseeb
Champion III
Champion III
‎2015-07-23 02:54 AM

Hi,

This is generic error it could come due to many reasons like.

1) Database unavailable at that instance

2) database is fully busy and it close connection

3) Antivirus may cause this.

To get specific error.

Open your Qlik App in desktop go to setting --> Document properties --> General tab --> Select generate log file.

Now schedule your task and share with us log file it generated.

You will find the same in below path.

C:\ProgramData\QlikTech\DistributionService\1\Log

Hope it helps.

Regards

ASHFAQ

1,238 Views
qlikviewwizard
Master II
Master II
‎2015-07-23 04:09 AM

In response to ashfaq_haseeb

Hi ashfaq_haseeb

Good check list to troubleshoot the issue. Thank you for info.

1,238 Views
0 Likes
awhitfield
Partner - Champion
Partner - Champion
‎2015-07-23 04:17 AM

Hi Vijay,

can you post the entire log file rather than just a section?

Andy

1,238 Views
0 Likes
vijayit43
Creator
Creator
‎2015-07-23 05:00 AM
Author

In response to awhitfield

(2015-07-23 02:45:00) Information: Starting task 'ReloadSNDSales'. Id:a57c860e-b3e7-4589-89ba-1c818ec524f4. Triggered by 'ScheduleTrigger'. Id:007958f8-9a7c-4b67-9111-c380ee3dc2e2

(2015-07-23 02:45:00) Information: Entering Task Execution.

(2015-07-23 02:45:00) Information: ClusterID=1

(2015-07-23 02:45:00) Information: QDSID=0f01ac39-e57a-e118-14c0-70f4d9aed3ab

(2015-07-23 02:45:00) Information: TaskID=a57c860e-b3e7-4589-89ba-1c818ec524f4

(2015-07-23 02:45:00) Information: MaxRunTime=1.00:00:00

(2015-07-23 02:45:00) Information: MachineName=QV

(2015-07-23 02:45:00) Information: Max attempts:1

(2015-07-23 02:45:00) Information: Current Attempt=0

(2015-07-23 02:45:00) Information: Task Dependencies are OK

(2015-07-23 02:45:00) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2015-07-23 02:45:00) Information: Opening "E:\QV Dashboard\Sales - Ghari\SND-Sales.qvw"

(2015-07-23 02:45:00) Information: Allocating new QlikView Engine. Current usage count=7 of 9 (of type non-reader).

(2015-07-23 02:45:00) Information: Max retries:5

(2015-07-23 02:45:00) Information: Attempt:01

(2015-07-23 02:45:01) Information: Opened the QlikView Engine successfully. ProcessID=6452

(2015-07-23 02:45:01) Information: Allocated QlikView Engine successfully. Current usage count=8 of 9 (of type non-reader). Ticket number=3404.

(2015-07-23 02:45:01) Information: Loading document "E:\QV Dashboard\Sales - Ghari\SND-Sales.qvw" (163.36 Mb)

(2015-07-23 02:45:01) Error: Document open call failed. The document might require username and password.

(2015-07-23 02:45:01) Information: Attempted to load the document without data.

(2015-07-23 02:45:01) Error: The document failed to open.

(2015-07-23 02:45:02) Information: Closed the QlikView Engine successfully. ProcessID=6452

(2015-07-23 02:45:02) Error: Document could not be opened

(2015-07-23 02:45:02) Information: Closed the QlikView Engine successfully. ProcessID=6452

(2015-07-23 02:45:02) Information: Failed to check in document: E:\QV Dashboard\Sales - Ghari\SND-Sales.qvw

(2015-07-23 02:45:02) Error: The task "ReloadSNDSales" failed. Exception:

(2015-07-23 02:45:02) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: E:\QV Dashboard\Sales - Ghari\SND-Sales.qvw

(2015-07-23 02:45:02) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-07-23 02:45:02) Error: --- End of inner exception stack trace ---

(2015-07-23 02:45:02) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-07-23 02:45:02) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-07-23 02:45:02) Error: --- End of inner exception stack trace ---

(2015-07-23 02:45:02) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-07-23 02:45:02) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2015-07-23 02:45:02) Information: Task Execute Duration=00:00:01.9701970

(2015-07-23 02:45:02) Information: Sending Alert mail

(2015-07-23 02:45:04) Information: TaskResult.status=Finished

(2015-07-23 02:45:04) Information: Notifying all triggers of new state:FinishedWithErrors

(2015-07-23 02:45:04) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2015-07-23 02:45:04) Information: Saving Task Result

1,238 Views
0 Likes
ashfaq_haseeb
Champion III
Champion III
‎2015-07-23 05:18 AM

In response to vijayit43

Hi,

Do you have section access?

Regards

ASHFAQ

1,238 Views
0 Likes
vijayit43
Creator
Creator
‎2015-07-23 05:36 AM
Author

In response to ashfaq_haseeb

Yes Ashfaq we have use section access

1,238 Views
0 Likes
ashfaq_haseeb
Champion III
Champion III
‎2015-07-23 05:40 AM

In response to vijayit43

Two things here.

1) Make sure your service account is a part of your Section access admin group.

2) Go to Distribution service in you QMC go to advance tab and provide section access admin credentials.

Let me know if that worked.

Regards

ASHFAQ

1,238 Views
0 Likes
awhitfield
Partner - Champion
Partner - Champion
‎2015-07-23 05:54 AM

The issue is most likely the line:

01) Error: Document open call failed. The document might require username and password.

If the qvw has section access, then ensure the user running the QV services is added as ADMIN to your SA load, reload via QV Desktop, save and reload from QMC.

Andy

1,238 Views
0 Likes
vijayit43
Creator
Creator
‎2015-07-23 07:05 AM
Author

Dear Ashfaq & Andrew

                                  but thease types of issues occoure once or twice in a week.

1,238 Views
0 Likes