Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gprasanth93
Contributor
Contributor

General Script Error while Saving QVW

Hi All,

I am facing a weird issues with Qlikview Server 11.20 64x

The application was running successfully on all previous attempts, but has started failing abruptly without any code change.

Currently the application loads around 129 Million records and fails while saving the app.

In the Logs all i can see is

08/05/2018 20:31:16:       General Script Error

08/05/2018 20:31:17:       Execution Failed

08/05/2018 20:31:17:      Execution finished.

Current Settings:

Application has Initial Data Reduction Based on Section Access.

Things that I have tried:

Removed Initial Data Reduction Based on Section Access. -- No Luck

Removed Final Store QVD Command -- No Luck

Checked if the QVW itself has some checks on windows attribute (ie Read Only) -- No Luck -- No Attributes were applied

Checked if the Disk has enough Space -- Its ample space to save the QVD

Checked the CPU and Memory Usage -- No issues with that as well -- One thing that i noticed -- Before failing it spikes to 100% CPU and abruptly fails.


Currently I am trying to reduce the data, Lets see how it goes.


Update : Reduced 9mil records and the extract has ran successfully


Want to understand what is the issue about? Is it the Load capacity between the Qlikview version and Windows Server?


Meanwhile any help would be much appreciated

6 Replies
jheasley
Luminary Alumni
Luminary Alumni

Have you made yourself and all of the qlik services into Admins in your Section Access script?

sasiparupudi1
Master III
Master III

Did you search for the word 'error' in the log file? Any changes done to the script to cause this issue

?

gprasanth93
Contributor
Contributor
Author

HI,

There no error apart from General Script Error.

Anyway the thing that I was trying to reduce the data a load, It has worked.

To my surprise why would the reload would fail? May be load capacity between the Server and Qlikview vr ?

gprasanth93
Contributor
Contributor
Author

Yes, Joe, I am the admin

kamielrajaram
Creator III
Creator III

Hi,

Have you checked that no other documents are referencing the file you are trying to save.

Kind Regards

Kamiel

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Are you storing QVDs in sequence? Or to put it differently, is there a STORE statement immediately before or after the one that fails? Then you may want to try by putting delays inbetween those successive STOREs (SLEEP statements)