3 Replies Latest reply: Feb 7, 2018 5:04 AM by ALI SA RSS

    Reload task failed

    ALI SA

      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

        • Re: Reload task failed
          ALI SA

          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

            • Re: Reload task failed
              Marcus Sommer

              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