Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow.

Hello,

I have a dashboard that runs on a trigger that keeps failing (pertinent log details below).

From similar posts on this topic, it sounds like it may be a database permissions issue; however, there doesn't seem to be a consensus.

Before submitting help desk tickets internally (and externally to Qlik if need be), was hoping someone may have some ideas.

Thank you very much in advance!

Regards,

Karen

(2015-03-16 06:00:03) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=E:\Development\Surgery_Production_DailyProd_v3.qvw.

(2015-03-16 06:00:03) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2015-03-16 06:00:03) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-03-16 06:00:03) Error: --- End of inner exception stack trace ---

(2015-03-16 06:00:03) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-03-16 06:00:03) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-03-16 06:00:03) Error: --- End of inner exception stack trace ---

(2015-03-16 06:00:03) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-03-16 06:00:03) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

1 Solution

Accepted Solutions
awhitfield
Partner - Champion
Partner - Champion

Hi Karen,

you should be able to get further info from the document logfile. But, normally if you can reload from QV Desktop on the Server, but NOT from a schedule, it will be down to access writes on your data source.

What are you reloading from?

Is the datasource available at the time you are reloading?

Andy

View solution in original post

7 Replies
simsondevadoss
Partner - Creator III
Partner - Creator III

This is due to error in the source application. Please check the log file

Not applicable
Author

I'm attaching the entire log below - just wondered if anyone had this issue and knew of a solution they found that worked.

I'm checking in with those that helped build the .qvds that feed the app.

(2015-03-16 06:00:00) Information: Starting task 'Daily Sx Dashboard with Details by Facility'. Id:bce02f4d-e72c-467d-9699-cd9036e735e9. Triggered by 'ScheduleTrigger'. Id:acd9a1f5-1541-4db1-91ba-a90d71dc9725

(2015-03-16 06:00:00) Information: Entering Task Execution.

(2015-03-16 06:00:00) Information: ClusterID=1

(2015-03-16 06:00:00) Information: QDSID=8e8ef735-1a47-710f-3e55-646ef30dcf9a

(2015-03-16 06:00:00) Information: TaskID=bce02f4d-e72c-467d-9699-cd9036e735e9

(2015-03-16 06:00:00) Information: MaxRunTime=1.00:00:00

(2015-03-16 06:00:00) Information: MachineName=HFQLIKVIEW1

(2015-03-16 06:00:00) Information: Max attempts:1

(2015-03-16 06:00:00) Information: Current Attempt=0

(2015-03-16 06:00:00) Information: Task Dependencies are OK

(2015-03-16 06:00:00) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2015-03-16 06:00:00) Information: Opening "E:\Development\Surgery_Production_DailyProd_v3.qvw"

(2015-03-16 06:00:00) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).

(2015-03-16 06:00:00) Information: Max retries:5

(2015-03-16 06:00:00) Information: Attempt:01

(2015-03-16 06:00:01) Information: Opened the QlikView Engine successfully. ProcessID=8828

(2015-03-16 06:00:01) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=67.

(2015-03-16 06:00:01) Information: Loading document "E:\Development\Surgery_Production_DailyProd_v3.qvw" (3.59 Mb)

(2015-03-16 06:00:01) Information: Physical FileSize=3.59 Mb. Memory Allocation Delta for this file=31.19 Mb. Available Physical Memory Before Open=371843.64 Mb. Available Physical Memory After Open=371806.23 Mb. Total Physical Memory=393146.21 Mb.

(2015-03-16 06:00:01) Information: Attempted to load the document without data.

(2015-03-16 06:00:01) Information: The document was loaded successfully.

(2015-03-16 06:00:01) Information: Document was opened successfully

(2015-03-16 06:00:01) Information: Starting reload

(2015-03-16 06:00:01) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.

(2015-03-16 06:00:01) Information: The Source Document is being reloaded. DocumentPath=E:\Development\Surgery_Production_DailyProd_v3.qvw

(2015-03-16 06:00:01) Information: Waiting for the document log "E:\Development\Surgery_Production_DailyProd_v3.qvw" to become available.. Check until 3/16/2015 6:00:05 AM

(2015-03-16 06:00:01) Information: Found a document log. FileName=E:\Development\Surgery_Production_DailyProd_v3.qvw.log

(2015-03-16 06:00:01) Information: Writing documentLog to E:\Admin\QDS\1\Log\20150316\060000 - Daily Sx Dashboard with Details by Facility\DocumentLog.txt

(2015-03-16 06:00:02) Information: Reloading.

(2015-03-16 06:00:02) Information: The Source Document reload complete. DocumentPath=E:\Development\Surgery_Production_DailyProd_v3.qvw

(2015-03-16 06:00:02) Information: Memory Allocation Delta for this file=8.14 Mb. Available Physical Memory Before Reload=371806.21 Mb. Available Physical Memory After Reload=371795.41 Mb. Total Physical Memory=371795.41 Mb.

(2015-03-16 06:00:03) Error: The Source Document was NOT reloaded successfully. DocumentPath=E:\Development\Surgery_Production_DailyProd_v3.qvw.

(2015-03-16 06:00:03) Information: Closing the document.

(2015-03-16 06:00:03) Information: Closed the QlikView Engine successfully. ProcessID=8828

(2015-03-16 06:00:03) Error: The task "Daily Sx Dashboard with Details by Facility" failed. Exception:

(2015-03-16 06:00:03) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=E:\Development\Surgery_Production_DailyProd_v3.qvw.

(2015-03-16 06:00:03) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2015-03-16 06:00:03) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-03-16 06:00:03) Error: --- End of inner exception stack trace ---

(2015-03-16 06:00:03) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-03-16 06:00:03) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-03-16 06:00:03) Error: --- End of inner exception stack trace ---

(2015-03-16 06:00:03) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-03-16 06:00:03) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2015-03-16 06:00:03) Information: Task Execute Duration=00:00:03.4475779

(2015-03-16 06:00:03) Information: Sending Alert mail

(2015-03-16 06:00:04) Information: TaskResult.status=Finished

(2015-03-16 06:00:04) Information: Notifying all triggers of new state:FinishedWithErrors

(2015-03-16 06:00:04) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2015-03-16 06:00:04) Information: Saving Task Result

Not applicable
Author

Hi Karen,

this is the task log, if you can post up the application log (this resides in the same folder as the qvw but is a .txt file with the same name) it will be easier to spot your problem.

If the application log isn't being created you'll need to enable this from the document properties and then run the task again.

logfile - Copy.PNG

Joe

buzzy996
Master II
Master II

seems to be the problem is ur able to fetch data but do not have access right back the data on same file.

means , u do not have complete access(write access) on the file to load.

awhitfield
Partner - Champion
Partner - Champion

Hi Karen,

you should be able to get further info from the document logfile. But, normally if you can reload from QV Desktop on the Server, but NOT from a schedule, it will be down to access writes on your data source.

What are you reloading from?

Is the datasource available at the time you are reloading?

Andy

simsondevadoss
Partner - Creator III
Partner - Creator III

Whether you are reloading and distributing the application in same path?

Not applicable
Author

Thanks for the feedback, everyone!

It should have occurred to me to run the qvw file outside of Publisher; when I did, I noticed one the qvd files failed.

Looks like someone moved the file path so am working to get it restored.

Have a good day!