Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

BATCH Reload : General Script Error

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.

11 Replies
Not applicable
Author

Hi guys

Run as qlikview user sounds good.

I need more time to reproduce the real conditions (automatic process running once a week) but the manual tests look good.

I'll keep you update.

Not applicable
Author

Hi guys,

sorry for the delay. Running scripts AS the same user as Qlikview server works well.

Thank you for your help.