Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error: Could not close the SourceDocument

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)

7 Replies
Bill_Britt
Former Employee
Former Employee

What version of QlikView are your running?

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

We're running QV 10 SR 3 (10.00.9070.7). Updated in the original post.

Bill_Britt
Former Employee
Former Employee

I would upgrade to SR6 and see if that will correct your issue.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

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.

Not applicable
Author

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.

Cattura.JPG

Any suggestion?

Not applicable
Author

Just a workaround, set to 2 or 3 the "Number of tries", the second attempt seems to work properly.

Cattura.JPG

korsikov
Partner - Specialist III
Partner - Specialist III

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" />