11 Replies Latest reply: Aug 12, 2016 2:36 AM by Karim Khaloula RSS

    BATCH Reload : General Script Error

    Karim Khaloula

      Hello,

      I am working at the IT Dept.

       

      I am new in Qlikview and I dont know how to use Qlikview ^^ but I am charged to manage the reloads.

       

      For that, I have created a BATCH Script that launches a reload.

       

      Script

       

      QVDistributionService.exe -r="D:\Qlikview\QVD\QVD.qvw" -out="D:\LOGS\QVD.log"

      QVDistributionService.exe -r="D:\Qlikview\MODELS\MODEL.qvw" -out="D:\LOGS\MODEL.log"

      QVDistributionService.exe -r="D:\Qlikview\APPS\Qlikview_Experimantal.qvw" -out="D:\LOGS\APPS.log"

       

       

      WhenI run that script from Task Scheduler, I got some errors like this :

       

      Header 1

      04/07/2016 12:37:11    Information    REQUEST_NAME, 8Â 257Â 959 lines fetched

      04/07/2016 12:38:14    Information    04/07/2016 12:36:29: 0511  DROP Table REQUEST

      04/07/2016 12:38:14    Information    04/07/2016 12:38:02: 0536  MAP_NEWREQ:

      04/07/2016 12:38:14    Information    04/07/2016 12:38:02: 0537 

      04/07/2016 12:38:14    Information    04/07/2016 12:38:02: 0538  mapping LOAD REQUEST_TYPE,

      04/07/2016 12:38:14    Information    04/07/2016 12:38:02: 0539       REQUEST_TYPE_COUNT

      04/07/2016 12:38:14    Information    04/07/2016 12:38:02: 0540  Resident REQUEST_TYPE

      04/07/2016 12:38:14    Information    04/07/2016 12:38:02:           2 fields found: TYPE_REQUEST, COMPTEUR_TYPE_REQUEST, 84 lines fetched

      04/07/2016 12:42:55    Information    04/07/2016 12:38:02: 0547  COUNT LINE_PER_REQUEST:

      04/07/2016 12:43:01    Information    04/07/2016 12:38:02: 0548  NoConcatenate

      04/07/2016 12:43:02    Information    04/07/2016 12:38:02: 0549  LOAD REQUEST_NUMBER&ExtractionDate as LineNbr,count(REQUEST_NUMBER&ExtractionDate) as LINE_PER_REQUEST

      04/07/2016 12:43:02    Information    04/07/2016 12:38:02: 0550  Resident TMP_REQUEST_DETAIL

      04/07/2016 12:43:02    Information    04/07/2016 12:38:02: 0551 

      04/07/2016 12:43:02    Information    04/07/2016 12:38:02: 0552 

      04/07/2016 12:43:02    Information    04/07/2016 12:38:02: 0553 

      04/07/2016 12:43:02    Information    04/07/2016 12:38:02: 0554 

      04/07/2016 12:43:02    Information    04/07/2016 12:38:02: 0555  Group by REQUEST_NUMBER&ExtractionDate

      04/07/2016 12:43:02    Information    04/07/2016 12:42:51:       General Script Error

      04/07/2016 12:43:59    Information    04/07/2016 12:42:57:       Execution Failed

      04/07/2016 12:43:59    Information    04/07/2016 12:43:59:      Execution finished.

      04/07/2016 12:44:14    Information    The Source Document reload complete. DocumentPath=D:\Qlikview\MODELS\MODEL.qvw

      04/07/2016 12:44:28    Information    Memory Allocation Delta for this file=-686.35 Mb. Available Physical Memory Before Reload=10901.50 Mb. Available Physical Memory After Reload=11850.75 Mb. Total Physical Memory=11850.75 Mb.

      04/07/2016 12:46:01    Error    The Source Document was NOT reloaded successfully. DocumentPath=D:\Qlikview\MODELS\MODEL.qvw.

      04/07/2016 12:46:13    Information    Closing the document.

      04/07/2016 12:46:14    Information    Closed the QlikView Engine successfully. ProcessID=3832

      04/07/2016 12:46:14    Error    The Batch Job failed. ErrorCount=1

      04/07/2016 12:46:14    Information    Setting exit code to the number of errors. ErrorCount=2

       

      If I reload the application from the Qlikview client (I mean open the QVW model file and clik on Reload button), the reload is OK.

       

      After the manual reload, I can run successfully my batch file.

       

      So, maybe I have forgotten something in my script ?

       

      Whats wrong with that ?

       

      Thank you for your help.