Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
twanqlik
New Contributor III

General Script Error during storing of a large QVD

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.

5 Replies
prieper
Honored Contributor II

Re: General Script Error during storing of a large QVD

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)?

tomasz_tru
Valued Contributor

Re: General Script Error during storing of a large QVD

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

twanqlik
New Contributor III

Re: General Script Error during storing of a large QVD

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.

Or
Valued Contributor II

Re: General Script Error during storing of a large QVD

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.

prieper
Honored Contributor II

Re: General Script Error during storing of a large QVD

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

Community Browser