topic Re: General Script Error during storing of a large QVD in QlikView

General Script Error during storing of a large QVD

twanqlik — Mon, 18 Sep 2017 14:46:02 GMT

Sometimes during the storing of a 'large' QVD i get a "General Script Error", it does not always occur.

What can i do to avoid this error, i've attached my QVW and the Log file. It's quite a large table that i'm trying to store +/- 18GB.

/16/2017 6:23:12 AM: 0124 Store F_CONSUMER_CORE into ..\5_QVD\FULL_F_CONSUMER_CORE_12MONTHS.qvd (qvd)

9/16/2017 6:29:40 AM: General Script Error

9/16/2017 6:29:43 AM: Execution Failed

9/16/2017 6:29:43 AM: Execution finished.

Re: General Script Error during storing of a large QVD

prieper — Mon, 18 Sep 2017 15:06:56 GMT

Does the error always incur after the same time?

Does it incur with lesser data?

Is there enough free space on the disk?

Is there some other activity, which may block the file (backup, virus-scanner)?

Re: General Script Error during storing of a large QVD

tomasz_tru — Mon, 18 Sep 2017 20:39:39 GMT

What's the file system. In ext2/3, for minimal block size, maximum file size is around 17GB.

Re: General Script Error during storing of a large QVD

twanqlik — Tue, 19 Sep 2017 07:41:32 GMT

The file system is NTFS, i don't think that the file system is the problem here, because sometimes the script completes.

Does the error always incur after the same time? No

Does it incur with lesser data? No, also never had any problems using the debug model

Is there enough free space on the disk? Yes

Is there some other activity, which may block the file (backup, virus-scanner)? No, not that i know of.

Re: General Script Error during storing of a large QVD

Or — Tue, 19 Sep 2017 07:44:36 GMT

Check that you aren't competing for I/O resources and/or disk space with something else - antivirus scans, backups, other writes, etc. That could explain sporadic crashes if QV determines it's no longer able to continue writing the file to disk.

Re: General Script Error during storing of a large QVD

prieper — Tue, 19 Sep 2017 07:51:58 GMT

What if writing to another location? probably directly on the server, where the app is running?