Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.5030398 | Information | Executing ClusterID=1, QDSID=b1ebd202-404b-2342-d04d-be268e028d49 QDSMain.DistributeTask |
18/03/2013 16:06:25.5030398 | Information | Starting task "Business Reports - Demand - Reload & Mail Warehouse Despatch Figures" (Attempt 1 of 1) |
18/03/2013 16:06:25.5030398 | Information | Max run time: 1.00:00:00 |
18/03/2013 16:06:25.5030398 | Information | Task Dependencies found. TaskNames=01.Reload of Back_End_Reports\New\Demand.qvw |
18/03/2013 16:06:25.5030398 | Warning | Dependency 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.5030398 | Error | Task dependencies failed. Count=1 |
18/03/2013 16:06:25.5030398 | Error | The task "Business Reports - Demand - Reload & Mail Warehouse Despatch Figures" failed. ErrorCount=1 |
18/03/2013 16:06:25.5030398 | Information | Sending 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.6322065 | Information | Executing ClusterID=1, QDSID=b1ebd202-404b-2342-d04d-be268e028d49 QDSMain.DistributeTask |
18/03/2013 15:50:55.6322065 | Information | Starting task "01.Reload of Back_End_Reports\New\Demand.qvw" (Attempt 1 of 1) |
18/03/2013 15:50:55.6322065 | Information | Max run time: 1.00:00:00 |
18/03/2013 15:50:55.6322065 | Information | Document is marked for refresh; Initializing Reload. |
18/03/2013 15:50:55.6322065 | Information | Opening "C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw" |
18/03/2013 15:50:55.6322065 | Information | Allocating QlikView Engine |
18/03/2013 15:50:55.6322065 | Information | Allocating new QlikView Engine. Current usagecount=1 of 4 |
18/03/2013 15:50:55.6322065 | Information | An instance of the QlikView Engine is being created |
18/03/2013 15:50:55.6322065 | Information | Starting QlikView Engine |
18/03/2013 15:50:56.4902080 | Information | Allocated QlikView Engine successfully. Current usagecount=1 of 4, Ticket=146 |
18/03/2013 15:50:56.4902080 | Information | Loading document "C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw" (138.35 Mb) |
18/03/2013 15:50:57.5042098 | Information | Loading. LoadTime=00:00:01.0140018 |
18/03/2013 15:50:58.7990121 | Information | Physical 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.7990121 | Information | The document was loaded successfully. |
18/03/2013 15:50:58.7990121 | Information | Initializing 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.7990121 | Information | Document was opened successfully |
18/03/2013 15:50:58.7990121 | Information | Opened successfully (0) |
18/03/2013 15:50:58.7990121 | Information | Starting reload |
18/03/2013 15:50:58.8146121 | Information | QlikView->Settings->Document Preferences->Generate Logfile in document is set. Enabling Log Copier. |
18/03/2013 15:50:58.8146121 | Information | Waiting for the document log "C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw" to become available.. |
18/03/2013 15:50:58.8146121 | Information | The Source Document is being reloaded. DocumentPath=C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw |
18/03/2013 15:50:58.8770122 | Information | Found a document log. FileName=C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw.log |
18/03/2013 15:50:58.8770122 | Information | Writing 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.8130139 | Information | Reloading. |
18/03/2013 15:51:00.8270157 | Information | Reloading.. |
18/03/2013 15:51:01.8410174 | Information | Reloading... |
18/03/2013 15:51:02.8550192 | Information | Reloading.... |
18/03/2013 15:51:03.8690210 | Information | Reloading..... |
18/03/2013 15:51:04.8830228 | Information | Reloading...... |
18/03/2013 15:51:05.8970246 | Information | Reloading....... |
18/03/2013 15:51:06.9110264 | Information | Reloading........ |
18/03/2013 15:51:07.9250281 | Information | Reloading......... |
18/03/2013 15:51:08.9390299 | Information | Reloading.......... |
18/03/2013 15:51:09.9530317 | Information | Slowing down logging. LoggingSeconds=2 |
18/03/2013 15:51:09.9530317 | Information | Reloading |
18/03/2013 15:51:11.9810353 | Information | Reloading. |
18/03/2013 15:51:14.0090388 | Information | Reloading.. |
18/03/2013 15:51:16.0370424 | Information | Reloading... |
18/03/2013 15:51:18.0650459 | Information | Reloading.... |
18/03/2013 15:51:20.0930495 | Information | Reloading..... |
18/03/2013 15:51:22.1210531 | Information | Reloading...... |
18/03/2013 15:51:24.1490566 | Information | Reloading....... |
18/03/2013 15:51:26.1770602 | Information | Reloading........ |
18/03/2013 15:51:28.2050638 | Information | Reloading......... |
18/03/2013 15:51:30.2330673 | Information | Reloading.......... |
18/03/2013 15:51:32.2610709 | Information | Slowing down logging. LoggingSeconds=10 |
18/03/2013 15:51:32.2610709 | Information | Reloading |
18/03/2013 15:51:42.4010887 | Information | Reloading. |
18/03/2013 15:51:52.5411065 | Information | Reloading.. |
18/03/2013 15:52:02.6811243 | Information | Reloading... |
18/03/2013 15:52:12.8835422 | Information | Reloading.... |
18/03/2013 15:52:23.0235600 | Information | Reloading..... |
18/03/2013 15:52:33.1635778 | Information | Reloading...... |
18/03/2013 15:52:43.3035957 | Information | Reloading....... |
18/03/2013 15:52:53.4436135 | Information | Reloading........ |
18/03/2013 15:53:03.5836313 | Information | Reloading......... |
18/03/2013 15:53:13.7236491 | Information | Reloading.......... |
18/03/2013 15:53:23.8636669 | Information | Slowing down logging. LoggingSeconds=60 |
18/03/2013 15:53:23.8636669 | Information | Reloading |
18/03/2013 15:54:24.7193738 | Information | Reloading. |
18/03/2013 15:55:25.5594806 | Information | Reloading.. |
18/03/2013 15:56:26.3995875 | Information | Reloading... |
18/03/2013 15:57:27.2396944 | Information | Reloading.... |
18/03/2013 15:58:28.0798012 | Information | Reloading..... |
18/03/2013 15:59:28.9199081 | Information | Reloading...... |
18/03/2013 16:00:29.7756150 | Information | Reloading....... |
18/03/2013 16:01:30.6157218 | Information | Reloading........ |
18/03/2013 16:02:31.4558287 | Information | Reloading......... |
18/03/2013 16:03:32.2959355 | Information | Reloading.......... |
18/03/2013 16:04:33.1360424 | Information | Slowing down logging. LoggingSeconds=300 |
18/03/2013 16:04:33.1360424 | Information | Reloading |
18/03/2013 16:05:30.4661431 | Information | The Source Document reload complete. DocumentPath=C:\QLIKVIEW\Reports\Back_End_Reports\New\Demand.qvw |
18/03/2013 16:05:30.4661431 | Information | Memory 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.6377434 | Information | The Source Document was reloaded successfully. |
18/03/2013 16:05:30.7001435 | Information | Initializing Reload (0), Finished (871901) |
18/03/2013 16:05:30.7001435 | Information | Reload finished successfully. |
18/03/2013 16:05:30.7001435 | Information | Saving document |
18/03/2013 16:05:42.5873644 | Information | Initializing 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.6029644 | Information | Closing the document. |
18/03/2013 16:05:42.9461650 | Information | Closed the QlikView Engine successfully. ProcessID=4212 |
18/03/2013 16:05:42.9461650 | Information | Initializing (0), Finished (358) |
18/03/2013 16:05:42.9461650 | Information | Reload completed successfully. |
18/03/2013 16:05:42.9461650 | Information | The 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
I would upgrade to the current SR for the version you are on and try again.
Bill
Thanks Bill.
I believe that we are on the latest SR for Qlikview 10. (10.0.9282.8).
Is this all it can be? Unfortunately it's not practical for us to update currently.
Regards,
Nick
That is not the lastest SR. 9282 is SR4 and the current one is 9731 which is SR6.
Bill