topic 'Execution of Script Failed. Reload old data?' error message in QlikView

'Execution of Script Failed. Reload old data?' error message

Wed, 30 May 2012 12:59:50 GMT

Hi There

I am getting the following error message in QlikView when I do an incremental reload to an exsiting QVD:

I find this error to be the most ambigious error ever! Just thought I should clear that up as this error frustrates me as it is not clear what it means.

I have a QVD which has all historic data stored in the same directory as my QVW. I am loading csv and Excel files which match the data structure of the QVD. The fields are exactly the same and the formats for each field are exaclty the same as the QVD.

The following is my code for setting up the historic QVD location and getting the maximum date when the data was last loaded.

let vQVDPath='.\User_Data_Historic.qvd';    //?? The QVD filename 
LET vExecution = now();
set vLastExecTime = 0;
if not isnull(QVDCreateTime('$(vQVDPath)')) then
LoadTime:
load max(date(User_CalendarDate)) as User_CalendarDate
from $(vQVDPath)(qvd);
let vLastExecTime = peek('User_CalendarDate', 0, 'LoadTime');
drop table LoadTime ;
end if

Data:
noconcatenate load 
U_ID,
[User_CalendarDate],
User_ID,
[User_Registration_Date],
ONLINE_ID, 
[Login],
[POSTS],
[PAGE],
[LOGINS],
[MINUTES], 
User_ACCEPTED,
User_GIVEN,
User_RECEIVED, 
[User_NOTES],
Flag
resident MyTable where  [User_CalendarDate] >= '$(vLastExecTime)' and [User_CalendarDate] < '$(vExecution)';
drop table MyTable;
The next step is to append the data, evaluating the load time for the QVD on the last load. 
if not isnull(QvdCreateTime('$(vQVDPath)')) then
concatenate (Data) load
* from $(vQVDPath) (qvd) where not exists(U_ID);
end if
if NoOfRows('Data') > 0 then
store Data into $(vQVDPath) (qvd);

Above is the load of new data. I have concatenated two Excel files together to form one table which should be appended to the historic QVD. Data should be loaded where the Calendar Date in the new data is higher than the maximum date in the historic QVD.

After reloading my script I get the 'Execution of Script Load' error and I have used this exact code for another dataset and I have encountered no error and runs fine. After reading many posts on the QlikCommunity, I have exhausted the many possible reasons into why I get the error.

Does someone know why this is happening only on this load and not on other loads?

Thanks

'Execution of Script Failed. Reload old data?' error message

erichshiino — Thu, 31 May 2012 01:21:34 GMT

HI,

Did you try to enable log files? Maybe the you can get more details on the point where your script if failling.

To enable it, go to settings - > Document properties -> General Tab -> check 'Enable log file'

After a reload (or when you try it) a file with the same name of your qvw but with the extension .log will be generated in the same folder of your qvw.

If you post your results here it might be easier to help you.

From your script, I'd say it is problably during your store command. The file might be blocked or the path was not accepted.

Hope this helps,

Erich

'Execution of Script Failed. Reload old data?' error message

Thu, 07 Jun 2012 10:01:50 GMT

Hi Erich

I have used your solution to enable log files.

Miraculously the script works fine now and all my newly loaded data is being appended to my historic QVD. The path I use for storing and accessing the QVD is accessible and like I said in my previous post it is used in other QlikView documents successfully with no problems.

This error is unexplained and is a hidden 'Easter Egg' that the guys at Qliktech have planted!

Thanks for your reply Erich.

'Execution of Script Failed. Reload old data?' error message

robertomontanar — Thu, 07 Jun 2012 10:23:47 GMT

Sometimes the file your qvw document try to write, is locked by someone else, that is writing too.

It happen very often to me, because I use more than one qv.exe istance in the same time.

In this case, the error reported by QlikView is exactly what you get

Could be the same as your experience ?

'Execution of Script Failed. Reload old data?' error message

Thu, 07 Jun 2012 13:43:24 GMT

Hi Roberto

Thank you for your answer.

To confirm, there are no other instances of QV.Exe or QVConnect in the task scheduler. This was the first thing I had checked. I agree that having more than one process for QV creates this error and I have experienced this before.

I usually try all possible avenues before I come on the community for a solution. To be honest, this error is ambigious as there is not a documented reason for this to occur.

'Execution of Script Failed. Reload old data?' error message

rwunderlich — Thu, 07 Jun 2012 15:06:37 GMT

This error is commonly seen during development. What happens is you are developing a script and on reload you have some type of understandable error -- like a syntax error. You fix the error and reload but then start to receive the dreaded "General script error". This is usually due to the files (usually a QVD) being left locked by the first script failure. You can clear this problem up by exiting QV and starting again.

-Rob

'Execution of Script Failed. Reload old data?' error message

Miguel_Angel_Baeyens — Thu, 07 Jun 2012 15:16:36 GMT

Hi,

That's certainly an ambiguous error message that means no more and no less than "something went wrong". The first step I always take when the issue is not obvious is to peform a limited debug load, with 100 records or even less, step by step to see where the script ends, and what values are the variables storing, how many records are being pulled from the sources, whether or not the connections are taking place, the files are stored properly...

Did you try that to see where the script crashes or what happens just after the load? You are using time functions like QvdCreateTime() to check when the file was created. Is there any chance that the difference between the successful and failed loads is in the OS time or local time settings?

Use the script variable "ScriptError" to check if you can get a reason according to those documented in the Reference Manual.

Hope that makes some sense.

Miguel

'Execution of Script Failed. Reload old data?' error message

Thu, 07 Jun 2012 16:04:02 GMT

sometimes, deleting the previously created qvd before doing a reload also helps since qv has locked the qvd and does not overwrite it automatically.

Re: 'Execution of Script Failed. Reload old data?' error message

Fri, 28 Sep 2012 14:35:43 GMT

Thanks Jasleen, this tip helped me out

Re: 'Execution of Script Failed. Reload old data?' error message

Fri, 28 Sep 2012 18:01:57 GMT

Am glad it help. Its one of those quirky things.

Re: 'Execution of Script Failed. Reload old data?' error message

Thu, 18 Apr 2013 07:37:27 GMT

Mostly it happens due to lock problem only.

Sometimes, after modifying script when try to run the script and it gets failed, at times, log files get locked. And whenever we start reloading, immediately it says 'Execution of Script Failed'.

To solve this problem, You can try either of followings :

1. If your log file generation is enabled, and you already have log file generated for previous execution, try to delete that log file. Possibly it won't allow you to delete. Hence, uncheck the option to generate log file and it'll work.

2. Also, you can simply rename the document or generate a copy with some other name and it'll work.

Hope it helps.

Hardik

Re: 'Execution of Script Failed. Reload old data?' error message

Thu, 18 Apr 2013 07:42:51 GMT

Mostly it happens due to lock problem only.

Sometimes, after modifying script when try to run the script and it gets failed, at times, log files get locked. And whenever we start reloading, immediately it says 'Execution of Script Failed'.

To solve this problem, You can try either of followings :

2. Also, you can simply rename the document or generate a copy with some other name and it'll work.

Hope it helps.

Hardik

Re: 'Execution of Script Failed. Reload old data?' error message

Thu, 18 Apr 2013 07:43:40 GMT

Mostly it happens due to lock problem only.

Sometimes, after modifying script when try to run the script and it gets failed, at times, log files get locked. And whenever we start reloading, immediately it says 'Execution of Script Failed'.

To solve this problem, You can try either of followings :

2. Also, you can simply rename the document or generate a copy with some other name and it'll work.

Hope it helps.

Hardik

Re: 'Execution of Script Failed. Reload old data?' error message

Thu, 18 Apr 2013 08:16:34 GMT

Mostly it happens due to lock problem only.

Sometimes, after modifying script when try to run the script and it gets failed, at times, log files get locked. And whenever we start reloading, immediately it says 'Execution of Script Failed'.

To solve this problem, You can try either of followings :

2. Also, you can simply rename the document or generate a copy with some other name and it'll work.

Hope it helps.

Hardik

Re: 'Execution of Script Failed. Reload old data?' error message

felcar2013 — Tue, 11 Jun 2013 11:33:20 GMT

I got exactly the same message after reloading the full script, which showed no errors. In the log files, there are no hints about what went wrong, but I reviewed carefully the sript and realised there were a "store" statement indicating a wrong path. I commented it and then the script worked.

Re: 'Execution of Script Failed. Reload old data?' error message

Mon, 17 Mar 2014 20:34:56 GMT

What is the location of the Qlikview log folder ? Is there a log folder on my local computer ? I could not find an answer on google.

Re: 'Execution of Script Failed. Reload old data?' error message

Mon, 17 Mar 2014 20:35:48 GMT

Unfortunately, jasleen's method did not work for me.

Re: 'Execution of Script Failed. Reload old data?' error message

prabhu0505 — Thu, 18 Sep 2014 04:55:57 GMT

In my case I was able to resolve by following below approach.

i commented code after main tab and executed

slowly progressed by one tab at a time, finally I was able to successfully execute the complete script.

Don't ask me the logic behind this, but it worked

Re: 'Execution of Script Failed. Reload old data?' error message

Fri, 14 Nov 2014 08:35:24 GMT

I have tried every suggestion above. What im doing is through Hive sql database, connecting to two dbo's. if I import only one, it works, yet when I try to import both, either separate or by Multipule select statements. Both table have identicile column names as the one is current and the other is archived data.

Any other suggestions?

Re: 'Execution of Script Failed. Reload old data?' error message

agomes1971 — Fri, 14 Nov 2014 08:40:06 GMT

Hi,

the use of trace is important when developing in QlikView.

Trace

The trace statement writes string to the Script Execution Progress window and to the script log file, when used.

The syntax is:

trace string

Examples:

trace Main table loaded;

trace $(MyMessage);

Regards

André Gomes