Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

alis2063
Not applicable

Reload task failed

We are facing some issues where distribution app is  being continuously  failed cause of below erroe,

2018-02-05 21:25:11) Information: Starting task 'Reload of Invoice Reporting.qvw'. Id:ff09de06-259d-4b89-ab97-becf85171f4c. Triggered by 'RetryStartTrigger'. Id:0000000c-000b-000a-0908-070605040302

(2018-02-05 21:25:11) Information: Entering Task Execution.

(2018-02-05 21:25:11) Information: ClusterID=1

(2018-02-05 21:25:11) Information: QDSID=21220e39-cd79-b68d-a589-3595783c4b2f

(2018-02-05 21:25:11) Information: TaskID=ff09de06-259d-4b89-ab97-becf85171f4c

(2018-02-05 21:25:11) Information: MaxRunTime=1.00:00:00

(2018-02-05 21:25:11) Information: MachineName=EUDC-QLIKPUB

(2018-02-05 21:25:11) Information: Max attempts:3

(2018-02-05 21:25:11) Information: Current Attempt=2

(2018-02-05 21:25:11) Information: Task Dependencies are OK

(2018-02-05 21:25:11) Information: Start document distribution.

(2018-02-05 21:25:11) Information: Opening source document

(2018-02-05 21:25:11) Information: Opening document: "Invoice Reporting.qvw"

(2018-02-05 21:25:11) Information: Allocating new QlikView Engine. Current usage count=3 of 8 (of type non-reader).

(2018-02-05 21:25:11) Information: Max retries:5

(2018-02-05 21:25:11) Information: Attempt:01

(2018-02-05 21:25:15) Information: Opened the QlikView Engine successfully. ProcessID=8416

(2018-02-05 21:25:15) Information: Allocated QlikView Engine successfully. Current usage count=4 of 8 (of type non-reader). Ticket number=2469.

(2018-02-05 21:25:15) Information: Loading document "E:\Production\Application\Invoice Reporting.qvw" (9027.67 Mb)

(2018-02-05 21:25:16) Information: Loading. LoadTime=00:00:01.0156258

(2018-02-05 21:25:18) Information: Loading. LoadTime=00:00:03.0157374

(2018-02-05 21:25:22) Information: Loading. LoadTime=00:00:07.0470061

(2018-02-05 21:25:30) Information: Loading. LoadTime=00:00:15.0784563

(2018-02-05 21:25:46) Information: Loading. LoadTime=00:00:31.1725172

(2018-02-05 21:26:18) Information: Loading. LoadTime=00:01:03.3607024

(2018-02-05 21:27:19) Information: Loading. LoadTime=00:02:03.8307406

(2018-02-05 21:28:19) Information: Loading. LoadTime=00:03:04.2538849

(2018-02-05 21:28:40) Information: Physical FileSize=9027.67 Mb. Memory Allocation Delta for this file=10324.83 Mb. Available Physical Memory Before Open=18321.13 Mb. Available Physical Memory After Open=8122.63 Mb. Total Physical Memory=32767.49 Mb.

(2018-02-05 21:28:40) Information: Attempted to load the document with data.

(2018-02-05 21:28:40) Information: The document was loaded successfully.

(2018-02-05 21:29:41) Information: Reduce skipped, nothing is selected.

(2018-02-05 21:29:41) Information: Document was opened successfully

(2018-02-05 21:29:41) Information: Determined 142 static recipients spread over 1 Distribution Resources.

(2018-02-05 21:29:41) Information: Number of rule combinations was calculated successfully. Rounds=1

(2018-02-05 21:29:41) Information: Empty rules

(2018-02-05 21:29:41) Information: Rules resulted in distribution.

(2018-02-05 21:29:41) Information: ROUND: 0 of 1. WarningCount=0

(2018-02-05 21:29:41) Information: Building filename

(2018-02-05 21:29:41) Information: Destination name: Invoice Reporting.qvw

(2018-02-05 21:29:41) Information: Set script

(2018-02-05 21:29:42) Information: Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear

(2018-02-05 21:29:42) Information: Offer resources

(2018-02-05 21:29:42) Information: Commencing ReduceData for C:\ProgramData\QlikTech\DistributionService\1\temp\4c968604-f695-438a-821a-83bd9568a4f7\document.qvw. (Reduce=False, Save=True)

(2018-02-05 21:30:09) Information: Completed ReduceData for C:\ProgramData\QlikTech\DistributionService\1\temp\4c968604-f695-438a-821a-83bd9568a4f7\document.qvw. (Reduce=False, Save=True)

(2018-02-05 21:30:09) Information: Memory Allocation Delta for this file=1.27 Mb. Available Physical Memory Before Reduce=8290.80 Mb. Available Physical Memory After Reduce=8242.19 Mb. Total Physical Memory=8242.19 Mb.

(2018-02-05 21:30:09) Error: Failed to generate QVW files.. Exception=System.IO.FileNotFoundException: Could not find file 'C:\ProgramData\QlikTech\DistributionService\1\temp\4c968604-f695-438a-821a-83bd9568a4f7\document.qvw'. || File name: 'C:\ProgramData\QlikTech\DistributionService\1\temp\4c968604-f695-438a-821a-83bd9568a4f7\document.qvw' || at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) || at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) || at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) || at QVBWrapper.DocumentPackage.AddFile(String i_PathToFile, String i_StoreAsFileName) || at QVBWrapper.Document.GetStream(ILogBucket i_LogBucket, eDocumentType i_DocumentType, String i_URL, Boolean i_ShowToolBar, String i_ReportID)

(2018-02-05 21:30:14) Information: Retry <1> of <1> to get document package.

(2018-02-05 21:30:14) Error: Failed to generate QVW File package.. Exception=QDSMain.Exceptions.NoDocumentPackageFoundException: No Document Package found. || at QDSMain.DistributeHelper.GetDocumentPackage(ILogBucket logBucket, IDictionary`2 duplicateList, Document document, eDocumentType documentType, String url, Boolean showToolBar, String reportID, Int32 maxRetries, Int32 currentRetry) || at QDSMain.DistributeHelper.GrabQVWFile(ILogBucket i_LogBucket, FilePackageContainer i_ParentFilePackageContainer, String i_FileName, Dictionary`2 i_DuplicateList, Document i_Document)

(2018-02-05 21:30:14) Information: Deleting temporary files.

(2018-02-05 21:30:14) Information: Closing the document.

(2018-02-05 21:30:17) Information: Closed the QlikView Engine successfully. ProcessID=8416

(2018-02-05 21:30:17) Error: The task "Reload of Invoice Reporting.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.LogBucketErrorException: Failed to generate QVW File package.. Exception=QDSMain.Exceptions.NoDocumentPackageFoundException: No Document Package found. || at QDSMain.DistributeHelper.GetDocumentPackage(ILogBucket logBucket, IDictionary`2 duplicateList, Document document, eDocumentType documentType, String url, Boolean showToolBar, String reportID, Int32 maxRetries, Int32 currentRetry) || at QDSMain.DistributeHelper.GrabQVWFile(ILogBucket i_LogBucket, FilePackageContainer i_ParentFilePackageContainer, String i_FileName, Dictionary`2 i_DuplicateList, Document i_Document) || at QDSMain.DistributeTask.RevertOneAndAlwaysOne(Document qvbDocument) || at QDSMain.DistributeTask.ReleaseQvb(Document qvbDocument) || at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue) || 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)

(2018-02-05 21:30:17) Information: Task Execute Duration=00:05:06.2564779

(2018-02-05 21:30:17) Information: Sending Alert mail

(2018-02-05 21:30:25) Information: TaskResult.status=Finished

(2018-02-05 21:30:25) Information: Notifying all triggers of new state:FinishedWithErrors

(2018-02-05 21:30:25) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2018-02-05 21:30:25) Information: Saving Task Result

1 Solution

Accepted Solutions
marcus_sommer
Not applicable

Re: Reload task failed

I don't have a publisher and therefore couldn't use distribution and have no own experience on the matter. But I could imagine that the problem is related to the filesize and the available amounts of RAM and storage-space. The application is quite large for your 32 GB of RAM but it will be loaded and if the distribution runs it may not enough RAM available and/or there is not enough storage.

If I'm right with my assumation then you should find appropriate hints within the QlikView performance-log and the windows event-logs. Another way of checking could be to reduce the filesize artificial maybe with a first-statement to your largest fact-table to about 10% of the origin filesize. Again if I'm right it should now run or at least the failure should happens later.

Further a look into the document-log might be helpful and also to consider to optimize the application because for your environment seemed these application a bit too heavy and I assume that there are quite a lot of further applications and tasks.

- Marcus

3 Replies
alis2063
Not applicable

Re: Reload task failed

Hi marcus_sommer

Could you please help into above issues.

I have hit my head to check the all possibility.

1)Check the issues at application level(Desktop App) Working fine

2)Restart the Distribution Service-However it is still getting failed

3)Checked -'C:\ProgramData\QlikTech\DistributionService\1 & found that there is no any file.


Regards,

Ali

marcus_sommer
Not applicable

Re: Reload task failed

I don't have a publisher and therefore couldn't use distribution and have no own experience on the matter. But I could imagine that the problem is related to the filesize and the available amounts of RAM and storage-space. The application is quite large for your 32 GB of RAM but it will be loaded and if the distribution runs it may not enough RAM available and/or there is not enough storage.

If I'm right with my assumation then you should find appropriate hints within the QlikView performance-log and the windows event-logs. Another way of checking could be to reduce the filesize artificial maybe with a first-statement to your largest fact-table to about 10% of the origin filesize. Again if I'm right it should now run or at least the failure should happens later.

Further a look into the document-log might be helpful and also to consider to optimize the application because for your environment seemed these application a bit too heavy and I assume that there are quite a lot of further applications and tasks.

- Marcus

alis2063
Not applicable

Re: Reload task failed

Hi Marcus,

Its resolved now. I have just released the some  space in C Drive .

Thanks for guiding me Marcus.