General Script Error

[gargi_bardhan]

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

[Miguel_Angel_Baeyens]

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

[gargi_bardhan]

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

[gandalfgray]

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

[#5]

Hey Gargi,

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

[Miguel_Angel_Baeyens]

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

[gargi_bardhan]

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

[#8]

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

[gargi_bardhan]

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

[Miguel_Angel_Baeyens]

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