Script execution problem

[madsgrathe]

Hi everybody

New problem 🙂

I've been trying to load a script, but QlikView keeps failing to load it. It starts out fine but at the end I keep getting the message: "Execution of script failed. Reload old data?"

By going through my code several times and trying to take out different parts, I've located the exact script that has QV failing. Here it is:

table_name:
LOAD
emailid,
min_date,
max_date,
referer,
'US' as Realm;
SQL
select
concat('US_',cast(emailid as char)) as emailid
,min(Date) as min_date
,max(Date) as max_date
,concat('US_',cast(max(refererid) as char)) as referer
from database_us.tmp_oldtablename
group by tmp_oldtablename.emailid;

Store table_name INTO ..\..\Source Data\Archive Data\table_name.qvd (qvd) ;
drop table table_name;

The weird thing is that QV doesn't explain WHY the execution fails. It just does. And it's rather perplexing since I've done a very similar thing before with any problems...

Any ideas as to where my script is bothering the system?

Thank you for any help you can provide.

[mike_garcia]

Hi,

The problem is in the Store statement. Change the destination file name to the following

"..\..\Source Data\Archive Data\table_name.qvd"

Brackets should also work

[..\..\Source Data\Archive Data\table_name.qvd]

Regards,

Mike

[madsgrathe]

Wow! That did just the trick!

Thank you so much

[madsgrathe · Accepted solution]

Hi again

Turned out that wasn't the problem. However, earlier today I found the answer.

Turns out the script I was running was trying to access a QVD file that was in use by another QV application. Once I closed this application, my script ran again no problem.

It's a shame that QlikView doesn't tell you this instead of just giving you a non-descriptive failure message.

I just wanted to share it with anyone else who might be running into similar issues.

[david_ze]

Hi,

Thanks for sharing your information.

Had the same problem and your information helped me solve it.

Best

David

[richard_chilvers]

I know this post was a little while ago.

But I now have the same problem, where Debug shows the script executing OK but on close says its actually failed. Where can I find out what is going wrong ?

Thanks for any ideas.