topic General Script Error while Saving QVW in QlikView

General Script Error while Saving QVW

gprasanth93 — Tue, 08 May 2018 21:48:27 GMT

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

Re: General Script Error while Saving QVW

jheasley — Tue, 08 May 2018 23:10:43 GMT

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

Re: General Script Error while Saving QVW

sasiparupudi1 — Wed, 09 May 2018 04:37:13 GMT

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

Re: General Script Error while Saving QVW

gprasanth93 — Thu, 10 May 2018 18:10:35 GMT

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 ?

Re: General Script Error while Saving QVW

gprasanth93 — Thu, 10 May 2018 18:11:03 GMT

Yes, Joe, I am the admin

Re: General Script Error while Saving QVW

kamielrajaram — Thu, 10 May 2018 21:53:53 GMT

Hi,

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

Kind Regards

Kamiel

Re: General Script Error while Saving QVW

Peter_Cammaert — Fri, 11 May 2018 07:44:21 GMT

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)