topic Script execution problem in QlikView

Script execution problem

madsgrathe — Wed, 12 Jan 2011 19:52:18 GMT

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.

Script execution problem

mike_garcia — Wed, 12 Jan 2011 20:09:08 GMT

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

Script execution problem

madsgrathe — Wed, 12 Jan 2011 21:09:06 GMT

Wow! That did just the trick!

Thank you so much

Script execution problem

madsgrathe — Thu, 13 Jan 2011 19:30:15 GMT

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.

Script execution problem

david_ze — Sat, 12 Mar 2011 22:17:08 GMT

Hi,

Thanks for sharing your information.

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

Best

David

Script execution problem

richard_chilvers — Thu, 12 Jan 2012 17:30:17 GMT

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.