General Script Error issue

[cjzimm76]

I have a .qvw file and its only purpose is the generate multiple .qvd files.  The task will run on the server successfully for weeks at a time, and then unexpectedly, I get the "General Script Error  Execution Failed". message in the middle of the task.  All of the .qvds are creating from the same data source and stored in the same folder.  After some time passes, I can run the task again without making any changes to the .qvw script and it will run successfully.  There is plenty of disk space available.  Folder permissions should not be an issue as the task will create the first couple .qvds but then the error comes in the middle of the script.  Any ideas on how to solve or trouble shoot this would be appreciated.

[swuehl]

Could there be a conflict with another qvw accessing the same set of qvw for reading (so they are locked when your qvw tries writing to them)?

[cjzimm76]

All other QV tasks are dependent on this task to being completed first.

[swuehl]

No manual reloads happening? No backup / 3rd party software reading the qvds in the time you are running your script?

Could you upload the document log and task log?

[cjzimm76]

(2014-06-20 10:57:27) Information: Reloading.........

(2014-06-20 11:12:27) Information: Reloading..........

(2014-06-20 11:14:58) Information: The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\QVD Generator.qvw

(2014-06-20 11:14:58) Information: Memory Allocation Delta for this file=83.30 Mb. Available Physical Memory Before Reload=38274.49 Mb. Available Physical Memory After Reload=37746.13 Mb. Total Physical Memory=37746.13 Mb.

(2014-06-20 11:14:58) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\QVD Generator.qvw.

(2014-06-20 11:14:58) Information: Initializing Reload (0), Finished (19854297)

(2014-06-20 11:14:58) Error: Reload failed.

(2014-06-20 11:14:58) Information: Closing the document.

(2014-06-20 11:14:59) Information: Closed the QlikView Engine successfully. ProcessID=5996

(2014-06-20 11:14:59) Information: Initializing (0), Finished (265)

(2014-06-20 11:14:59) Error: Reload failed. Distribution skipped.

(2014-06-20 11:14:59) Error: The task "QVD Generator.qvw" failed. ErrorCount=3

[cjzimm76]

6/20/2014 11:11:51 AM: 0426  FROM DBO."T_TRANS"

6/20/2014 11:11:51 AM:        3 fields found: TSTAMP, TX_AGG_ACCTVAL, TX_AGG_CONTRIB_AMT 233,681 lines fetched

6/20/2014 11:14:55 AM: 0428  Store [LIT Transactions] into QVD\LIT Transactions.QVD

6/20/2014 11:14:58 AM:       General Script Error

6/20/2014 11:14:58 AM:       Execution Failed

6/20/2014 11:14:58 AM:      Execution finished.

[Chris_Rice]

Looks like it's failing on the STORE command, so my best guess is that something is blocking the write process.  I've seen that happen with anti-virus scanners locking the files, as well as latency in reading/writing with a NAS.  If you are using some type of NAS I would put the files on a local drive to see if the issue persists.  Should the issue persist, you could use a program like Process Explorer to see what other programs may be locking that file.

[#8]

Hi,

Try to find which file is giving error, as per my understanding you are creating a number of qvd's from the source, so just try to identify which qvd is making error and put that alone in a separate application and check for detailed error description.

So you can get some more idea about the error to rectify.

[cjzimm76]

We are using a local drive.  I'll see if Process Explorer can be used during our reload times.

[cjzimm76]

Kira,

It can be a different qvd each time.  And like I said, I just wait and run the same code a little later and it will work fine.