3 Replies Latest reply: Mar 20, 2013 12:38 PM by Bill Britt RSS

    Task Dependencies Failing

      Hi everyone,

       

      I'm having an issue with a report i've set up to run at a specific time on a monday with a dependency to another report.

       

      This is the first time i've tried using dependencies in Publisher and i cannot seem to get it to work correctly. Everytime i try to reload the report (with the dependency) i receive the following error log on the server;

       

      18/03/2013 16:06:25.5030398InformationExecuting ClusterID=1, QDSID=b1ebd202-404b-2342-d04d-be268e028d49 QDSMain.DistributeTask
      18/03/2013 16:06:25.5030398InformationStarting task "Business Reports - Demand - Reload &  Mail Warehouse Despatch Figures" (Attempt 1 of 1)
      18/03/2013 16:06:25.5030398InformationMax run time: 1.00:00:00
      18/03/2013 16:06:25.5030398InformationTask Dependencies found. TaskNames=01.Reload of Back_End_Reports\New\Demand.qvw
      18/03/2013 16:06:25.5030398WarningDependency check failed due to current errors in execution of task "01.Reload of Back_End_Reports\New\Demand.qvw".
      18/03/2013 16:06:25.5030398ErrorTask dependencies failed. Count=1
      18/03/2013 16:06:25.5030398ErrorThe task "Business Reports - Demand - Reload &  Mail Warehouse Despatch Figures" failed. ErrorCount=1
      18/03/2013 16:06:25.5030398InformationSending Alert Mail to 2 recipients.

       

       

      Now, unless i'm reading this wrong, its telling me that it's failing because the task 01.Reload of Back_End_Reports\New\Demand.qvw has failed.

       

      ....Except it hasn't. Even the log files on the server for that report indicate otherwise;

       

       

      18/03/2013 15:50:55.6322065InformationExecuting ClusterID=1, QDSID=b1ebd202-404b-2342-d04d-be268e028d49 QDSMain.DistributeTask
      18/03/2013 15:50:55.6322065InformationStarting task "01.Reload of Back_End_Reports\New\Demand.qvw" (Attempt 1 of 1)
      18/03/2013 15:50:55.6322065InformationMax run time: 1.00:00:00
      18/03/2013 15:50:55.6322065InformationDocument is marked for refresh; Initializing Reload.
      18/03/2013 15:50:55.6322065InformationOpening "C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw"
      18/03/2013 15:50:55.6322065InformationAllocating QlikView Engine
      18/03/2013 15:50:55.6322065InformationAllocating new QlikView Engine. Current usagecount=1 of 4
      18/03/2013 15:50:55.6322065InformationAn instance of the QlikView Engine is being created
      18/03/2013 15:50:55.6322065InformationStarting QlikView Engine
      18/03/2013 15:50:56.4902080InformationAllocated QlikView Engine successfully. Current usagecount=1 of 4, Ticket=146
      18/03/2013 15:50:56.4902080InformationLoading document "C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw" (138.35 Mb)
      18/03/2013 15:50:57.5042098InformationLoading. LoadTime=00:00:01.0140018
      18/03/2013 15:50:58.7990121InformationPhysical FileSize=138.35 Mb. Memory Allocation Delta for this file=375.04 Mb. Available Physical Memory Before Open=12048.59 Mb. Available Physical Memory After Open=11684.99 Mb. Total Physical Memory=32758.06 Mb.
      18/03/2013 15:50:58.7990121InformationThe document was loaded successfully.
      18/03/2013 15:50:58.7990121InformationInitializing Checkout (0), Loading document (858), Initializing load (858), Checking read (858), Creating QlikView Engine (858), Checking Size (858), Load (858), Load Completed (2808), Tables read (3136), Opened successfully (3167)
      18/03/2013 15:50:58.7990121InformationDocument was opened successfully
      18/03/2013 15:50:58.7990121InformationOpened successfully (0)
      18/03/2013 15:50:58.7990121InformationStarting reload
      18/03/2013 15:50:58.8146121InformationQlikView->Settings->Document Preferences->Generate Logfile in document is set. Enabling Log Copier.
      18/03/2013 15:50:58.8146121InformationWaiting for the document log "C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw" to become available..
      18/03/2013 15:50:58.8146121InformationThe Source Document is being reloaded. DocumentPath=C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw
      18/03/2013 15:50:58.8770122InformationFound a document log. FileName=C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw.log
      18/03/2013 15:50:58.8770122InformationWriting documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20130318\155055 - 01.Reload of Back_End_Reports_New_Demand.qvw\DocumentLog.txt
      18/03/2013 15:50:59.8130139InformationReloading.
      18/03/2013 15:51:00.8270157InformationReloading..
      18/03/2013 15:51:01.8410174InformationReloading...
      18/03/2013 15:51:02.8550192InformationReloading....
      18/03/2013 15:51:03.8690210InformationReloading.....
      18/03/2013 15:51:04.8830228InformationReloading......
      18/03/2013 15:51:05.8970246InformationReloading.......
      18/03/2013 15:51:06.9110264InformationReloading........
      18/03/2013 15:51:07.9250281InformationReloading.........
      18/03/2013 15:51:08.9390299InformationReloading..........
      18/03/2013 15:51:09.9530317InformationSlowing down logging. LoggingSeconds=2
      18/03/2013 15:51:09.9530317InformationReloading
      18/03/2013 15:51:11.9810353InformationReloading.
      18/03/2013 15:51:14.0090388InformationReloading..
      18/03/2013 15:51:16.0370424InformationReloading...
      18/03/2013 15:51:18.0650459InformationReloading....
      18/03/2013 15:51:20.0930495InformationReloading.....
      18/03/2013 15:51:22.1210531InformationReloading......
      18/03/2013 15:51:24.1490566InformationReloading.......
      18/03/2013 15:51:26.1770602InformationReloading........
      18/03/2013 15:51:28.2050638InformationReloading.........
      18/03/2013 15:51:30.2330673InformationReloading..........
      18/03/2013 15:51:32.2610709InformationSlowing down logging. LoggingSeconds=10
      18/03/2013 15:51:32.2610709InformationReloading
      18/03/2013 15:51:42.4010887InformationReloading.
      18/03/2013 15:51:52.5411065InformationReloading..
      18/03/2013 15:52:02.6811243InformationReloading...
      18/03/2013 15:52:12.8835422InformationReloading....
      18/03/2013 15:52:23.0235600InformationReloading.....
      18/03/2013 15:52:33.1635778InformationReloading......
      18/03/2013 15:52:43.3035957InformationReloading.......
      18/03/2013 15:52:53.4436135InformationReloading........
      18/03/2013 15:53:03.5836313InformationReloading.........
      18/03/2013 15:53:13.7236491InformationReloading..........
      18/03/2013 15:53:23.8636669InformationSlowing down logging. LoggingSeconds=60
      18/03/2013 15:53:23.8636669InformationReloading
      18/03/2013 15:54:24.7193738InformationReloading.
      18/03/2013 15:55:25.5594806InformationReloading..
      18/03/2013 15:56:26.3995875InformationReloading...
      18/03/2013 15:57:27.2396944InformationReloading....
      18/03/2013 15:58:28.0798012InformationReloading.....
      18/03/2013 15:59:28.9199081InformationReloading......
      18/03/2013 16:00:29.7756150InformationReloading.......
      18/03/2013 16:01:30.6157218InformationReloading........
      18/03/2013 16:02:31.4558287InformationReloading.........
      18/03/2013 16:03:32.2959355InformationReloading..........
      18/03/2013 16:04:33.1360424InformationSlowing down logging. LoggingSeconds=300
      18/03/2013 16:04:33.1360424InformationReloading
      18/03/2013 16:05:30.4661431InformationThe Source Document reload complete. DocumentPath=C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw
      18/03/2013 16:05:30.4661431InformationMemory Allocation Delta for this file=764.18 Mb. Available Physical Memory Before Reload=11685.00 Mb. Available Physical Memory After Reload=10755.70 Mb. Total Physical Memory=10755.70 Mb.
      18/03/2013 16:05:30.6377434InformationThe Source Document was reloaded successfully.
      18/03/2013 16:05:30.7001435InformationInitializing Reload (0), Finished (871901)
      18/03/2013 16:05:30.7001435InformationReload finished successfully.
      18/03/2013 16:05:30.7001435InformationSaving document
      18/03/2013 16:05:42.5873644InformationInitializing save (0), Copying permissions to new file (16), Saving C:\QLIKVIEW\Reports\Back_End_Reports\New\cf9d4386-ba89-428a-902f-8bb540cd6456_Demand.qvw.tmp (16), Moving temp file to new file. Attempt= 1 (11872), Deleting old file (11872)
      18/03/2013 16:05:42.6029644InformationClosing the document.
      18/03/2013 16:05:42.9461650InformationClosed the QlikView Engine successfully. ProcessID=4212
      18/03/2013 16:05:42.9461650InformationInitializing (0), Finished (358)
      18/03/2013 16:05:42.9461650InformationReload completed successfully.
      18/03/2013 16:05:42.9461650InformationThe task "01.Reload of Back_End_Reports\New\Demand.qvw" finished successfully

       

      Is there something i'm missing? I've read the (almost useless) server manual on the subject but cannot find any help for this!!

       

      I'm sure theres something i'm probably missing but i cannot figure it out! Hopefully someone wise on here can help ?

       

      Thanks,

       

      Nick