Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi guys,
sorry for the delay. Running scripts AS the same user as Qlikview server works well.
Thank you for your help.