'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

[Anonymous]

Thanks to wonderful error handling in QV, this can really by anything. In my case - it was happening when there was not enough memory available for the app. After restart it worked like a charm.

[Anonymous]

I went through line-by-line, but even when I found the line (an innocuous one with no errors) I still got the message. After trying closing Qlikview, etc, and trying other methods detailed above, I ended up fixing by rebooting my PC. This is a frustrating one.

[raviityou]

Hi, i was facing the same issue, just apply exit script on first tab before all your code and then save it and try re-open and  reload. it should work.

[Mawkishrains]

Well I faced this monster today, tried commenting, deleting qvd's, logging, and none worked, so decided to restart my PC, and it worked like nothing was wrong once the pc restarted. I was running this on a Virtual machine and probably some update messed things up.