General Script Error while Storing QVD

[#1]

I encounter a "General Script Error' while storing a QVD whose data is fetched from a Database. I get this frequently. What could be the problem ?

I have understood that it could be a memory issue while writing to the disk (i/o operation). The code is attached.

Any suggesstions ?

6/27/2011 12:55:00 AM: 0828  LOAD
6/27/2011 12:55:00 AM: 0829  PROPOSALID,
6/27/2011 12:55:00 AM: 0830  if(PROPOSALID=AGREEMENTID_UTLCPF or AGREEMENTNO=TRANSFER_CEF_TEF_AGREEMENTNO,'17',if(AGREEMENTNO='UTL018066O0900121713','31',SCHEMEID)) as SCHEMEID,
6/27/2011 12:55:00 AM: 0831  if(PROPOSALID=AGREEMENTID_UTLCPF or AGREEMENTNO=TRANSFER_CEF_TEF_AGREEMENTNO,'CV',if(AGREEMENTNO='UTL018066O0900121713','FASEQ',PRODUCTFLAG)) as PRODUCTFLAG,
6/27/2011 12:55:00 AM: 0832  if(AGREEMENTNO=AGREEMENTNO_NEW,NEW_BRANCHID,
6/27/2011 12:55:00 AM: 0833  if(num(trim(LESSEEID))=num(trim(CUSTOMERID_DLFIN)),if(isnull(BRANCHID_DLFIN),BRANCHID,BRANCHID_DLFIN),BRANCHID)) as BRANCHID
6/27/2011 12:55:00 AM: 0834  resident LEA_AGREEMENT_DTL_TEMP
6/27/2011 12:55:00 AM:           4 fields found: PROPOSALID, SCHEMEID, PRODUCTFLAG, BRANCHID, 411,482 lines fetched
6/27/2011 12:55:10 AM:       Joining/Keeping
6/27/2011 12:55:14 AM: 0835  drop table LEA_AGREEMENT_DTL_TEMP
6/27/2011 12:55:16 AM: 0836  Store LEA_AGREEMENT_DTL into D:\Qlik2Finance\Data\RawQVD\LEA_AGREEMENT_DTL.qvd
6/27/2011 12:55:18 AM:       General Script Error
6/27/2011 12:55:19 AM:       Execution Failed
6/27/2011 12:55:19 AM:      Execution finished.

[#2]

Hi,

I'm also encountering exactly same issue though frequency is very random, a couple of times per day or never occured and problematic QVD file also changes. I had never seen this issue before late June and my local support contact has a bit doubts if Windows hotfixes/security patch or unti-virus software locking QVD file from being written.

Reload frequency: every 1 mins

Reload engine: QVDistributionService.exe

Num of QVDs written by reload: 4

OS: Windows server 2008 R2

Unti-virus software: Symantec Endpoint Protection 11.0.5002.333

Hotfixes/security patches as following:

[#3]

Adding sleep after store command is working..