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

[#1]

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

[#2]

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

[#3]

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

[#4]

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

[#5]

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

[felcar2013]

hi

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.

[#7]

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.

[#8]

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

[prabhu0505]

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

[#10]

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?

[agomes1971]

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