topic General Script Error in QlikView

General Script Error

gargi_bardhan — Wed, 01 Feb 2012 10:36:33 GMT

Hi All !

The data extraction is done by two extractors running parallely hit by a batch file like this:

LOADSTART

CD "D:\Qlik View\BatchFiles\Sub_Batchfiles"

ECHO Qlikview Reload initiated at %DATE% %TIME% >>LOADSTART.log

Start DataExtract1.BAT
Start DataExtract2.BAT

The problem is that sometimes either of the two extractors fails & the error is 'General Script Error' , so is there any way that the application doesnt exit & goes into a loop which will make it try atleast twice .

Firstly I thought as I am hitting it parallely so may be due to load one is getting failed, so I put sleep command in the DataExtract2.qvw but all in vain.

So how to resolve this ?

Regards,

Gargi

General Script Error

Miguel_Angel_Baeyens — Wed, 01 Feb 2012 10:59:22 GMT

Hi Gargi,

Does the script error happens when you reload using Desktop instead of the scheduled task? Do the two BAT files refer to the same file so it might be reloading at the same time? How do the BAT files look like?

Regards.

Miguel

General Script Error

gargi_bardhan — Wed, 01 Feb 2012 12:01:02 GMT

Hi Miguel !

PFA,

Yes,reload is done using Desktop by hitting a batch file 'LOADSTART' which hits other two batch files .

1) DataExtract1.BAT

This batch reloads Data_Extract_1.qvw

2) DataExtract2.BAT

this batch reloads Data_Extract_2.qvw

I have divided into two extractors as it saves 1/2 of the total reload time, earlier it was taking 1hr, now 30-35min.

After this reload is completed (the last one which completes) hits other Intermediate applications.

Regards,

Gargi

General Script Error

gandalfgray — Wed, 01 Feb 2012 13:07:37 GMT

In my experience General Script Error has mostly been caused by problems with the STORE command due to the file being locked by some other application.

What does the QV logfile say?

best regards

Gandalf

General Script Error

Wed, 01 Feb 2012 13:13:59 GMT

Hey Gargi,

I believe they are Raw Extraction application. Two application are parallely hitting the database. To save time try incremental load.

General Script Error

Miguel_Angel_Baeyens — Wed, 01 Feb 2012 14:09:36 GMT

Gargi,

The QVW files run without issues when called from the Desktop (not using the BAT file but opening the files manually) or do the errors appear in this case as well?

Is there any chance that both scripts are saving the same file name in the same folder, so one of both locks the file and the other generates the error?

Regards.

Miguel

General Script Error

gargi_bardhan — Thu, 02 Feb 2012 05:22:03 GMT

Hello Miguel,

The QVW files run without issues while running from Desktop, earlier I misundrstood the term Desktop .

No, I checked back today there are no common file getting saved with the same name, so now how to resolve??

Is there any issue with the batch where I have used Flag ?

Regards,

Gargi

General Script Error

Thu, 02 Feb 2012 05:50:12 GMT

Hello ,

Can you share the applications log file here please. I guess the server cannot handle two extractions at the same time. Does the CPU Usage reach its peak when both batches are running ?

Rajeev

Re: General Script Error

gargi_bardhan — Thu, 02 Feb 2012 07:42:17 GMT

Hi Rajeev,

This system works fine but once or twice in a month it fails, so I think server is easily handling the extraction,

& as extraction process is done in early hours so there is not much CPU usage as well .

As on daily basis log files get overwritten so I dont have the log file having the error details.

Regards,

Gargi

General Script Error

Miguel_Angel_Baeyens — Thu, 02 Feb 2012 12:41:51 GMT

Hi Gargi,

Both reload lines seem OK to me. Make sure the user that runs the BAT file has permissions on the folders and files. If you are using Windows Scheduler, make sure the user specified to logon as when the file is triggered has the same permissions you have (or even use your own user), and that the radio button "Run whether user is logged on or not" is checked.

In order to see where exactly the script stops, open each document, go to Settings menu, Document Properties, General tab and click on "Generate logfile" and "Timestamp in logfile name". That will create a file with the same name that the QVW but ending in ".log" that will show how many lines of the script have been executed and how many records have them fetched, should they are load or select lines.

Hope that helps.

Miguel

General Script Error

Thu, 02 Feb 2012 14:39:11 GMT

Hi,

Try reloading applications via a reload engine. You can also set the dependencies among the application there.

Its much safer.

But If it fails too then atleast it will give you a proper log why did reload fail ?

Regards

Re: General Script Error

gargi_bardhan — Mon, 06 Feb 2012 05:44:11 GMT

Hi Miguel,

The user who is hitting the Bat has rights on the folder & its a daily process, the issues occurs once in a month but its also not fix,thats why it is geeting difficult to get rid of this issue and Window Scheduler is not used.

Ya the setting you mentioned is implemented here but right now I have no sample of the error log file . The errror which comes in the log is after execution of few lines is 'General Script Error' .

Anyways thanks Miguel, once again If it fails I will attach the log file.

Regards,

Gargi

Re: General Script Error

Wed, 04 Jul 2012 07:56:39 GMT

I was having the same issue - however removing the destination file and then running the QV doc from the server to recreate it (instead of running from desktop) seems to have worked.

I'm guessing that this sets the permissions on the file for the service account as owner (doing this manually didn't work).