Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having recent issues with a specific reload task. The job takes an average of an hour to reload. The script and data reloads successfully, but when it attempts to close the reloaded source document, I get the following error messages:
(2013-01-09 11:36:14) Information: The Source Document was reloaded successfully.
(2013-01-09 11:36:14) Information: Initializing Reload (0), Finished (3136885)
(2013-01-09 11:36:14) Information: Reload finished successfully.
(2013-01-09 11:36:14) Information: Saving document
(2013-01-09 11:39:05) Information: Initializing save (0), Copying permissions to new file (125), Saving E:\QlikViewDocuments\SourceDocuments\SD\4412f738-5bb2-4ec7-a5ad-418fbdcfac01_Global_Lead_Time_Metrics.qvw.tmp (140), Moving temp file to new file. Attempt= 1 (171054), Deleting old file (171054)
(2013-01-09 11:39:06) Information: Closing the document.
(2013-01-09 11:39:28) Error: Could not close the SourceDocument. Exception=The currently executing operation was aborted.
(2013-01-09 11:39:28) Warning: The QlikView Engine isn't responding to close command, it will be killed (Please ignore logged errors about the kill).
(2013-01-09 11:39:28) Information: Killing the QlikView Engine. ProcessID=2972
(2013-01-09 11:39:28) Information: Closed the QlikView Engine successfully. ProcessID=2972
(2013-01-09 11:39:28) Information: Initializing (0), Finished (22292)
(2013-01-09 11:39:28) Error: Reload failed. Distribution skipped.
(2013-01-09 11:39:28) Error: The task "Reload Lead Time Dashboard" failed. ErrorCount=2
I did read in another thread something about SECONDSTOWAITBEFOREQVBKILL in the config file, but I think that might be outdated as I did not see that parameter in my qds config file
Server version: QV 10 SR 3 (10.00.9070.7)
What version of QlikView are your running?
Bill
We're running QV 10 SR 3 (10.00.9070.7). Updated in the original post.
I would upgrade to SR6 and see if that will correct your issue.
Bill
I'll investigate an upgrade to SR6. The interesting thing is we have a development environment with the exact same data and these reloads are not problematic there.
Hi Martin,
How did you solve your problem?
I have the same problem on Qlikview Server 11 SR2.
The document is quite big (about 10GB) and server spends about 20 minutes to save it,
I try to set longer timeout on Triggers tab of Task but it doesn't solve the problem.
Any suggestion?
Just a workaround, set to 2 or 3 the "Number of tries", the second attempt seems to work properly.
this line is not pressent in default conf file. You need simple add this line, like this
<!-- If amount of log rows per 60 sec exceeds value, QDS is shut down-->
<add key="MaxLogRowsPerMinuteBeforeStopService" value="100000" />
<!-- the time the Distribution Service will wait for the document to close.-->
<add key="SECONDSTOWAITBEFOREQVBKILL" value="60" />
<!-- ************ SNMP Settings ************ -->
<!-- Set to true to enable snmp listener -->
<add key="EnableSNMP" value="false" />