Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cjzimm76
Partner - Creator
Partner - Creator

General Script Error issue

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.

23 Replies
swuehl
MVP
MVP

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
Partner - Creator
Partner - Creator
Author

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

swuehl
MVP
MVP

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
Partner - Creator
Partner - Creator
Author

(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
Partner - Creator
Partner - Creator
Author

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
Former Employee
Former Employee

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.

Not applicable

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
Partner - Creator
Partner - Creator
Author

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

cjzimm76
Partner - Creator
Partner - Creator
Author

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.