topic Re: Execution of Script Failed with no reason in QlikView

Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 18:48:38 GMT

Hi guys,

I am adding another script tab in to my existing application to bring a new qvd in together with some new definition of a few fields and some conditions. After I hit "reload", it fetched everything and it looks good until it finished reloading and gave me an ambiguous error message saying:" Execution of script failed. Reload old data?"

I tested the new added script in a new application without the old script and it works fine. I tested the old scripts in the old application and they are good also...

Would you masters be able to find any possible reasons?

Thanks a lot,

Lynn

Re: Execution of Script Failed with no reason

julian_rodriguez — Tue, 18 Mar 2014 18:51:15 GMT

Hello Lynn,

Are you storing a QVD file on the line before the error?...

Did you activated the execution log file to see on wich line the error is?

Could you share this log with us to check it out?

Regards,

Re: Execution of Script Failed with no reason

Tue, 18 Mar 2014 19:03:33 GMT

Just taking a shot in the dark.

Can you close the entire application and then again try to open and reload everything?

Thanks

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 19:09:36 GMT

Hi guys,

There is no error shown in the log file...and I closed it out and reopen it. Still the same problem...Really wish I could share the log so you guys can take a look for me but I am afraid the company policy won't allow me to do that..

Thanks,

Lynn

Re: Execution of Script Failed with no reason

Tue, 18 Mar 2014 19:19:01 GMT

Are you storing a QVD file on the line before the error? Delete the stored qvd-file and run the script again.

Re: Execution of Script Failed with no reason

Tue, 18 Mar 2014 19:24:08 GMT

Can you put Trace commands in your script to see if there are any sudden increases in the record count in any of the tables due to joins any where.
Try doing a limited load with 100 lines and see if it reloads successfully.
Can you try running it on your Dev sever and check out the Task Log file if it fails. Task log will give you the reason for failure
Also it might fail without error if you try to write to a qvd while its being read or read from a qvd while its being written

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 19:29:18 GMT

Thanks for the tips, Ajay. How can I put Trace commands..? I searched it in the Qlikview help but didn't get anything...

What is Dev server? Does IT needs to be involved...?

Sorry I must sound like a dummy...:(

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 19:46:13 GMT

I didn't store a QVD in this script. I created QVDs and loaded them into this application.

Re: Execution of Script Failed with no reason

Bill_Britt — Tue, 18 Mar 2014 19:52:22 GMT

Hi Lynn,

Go into Debug and do a step through of the script and see what happens.

Bill

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 20:03:25 GMT

It doesn't show any error....:(

Re: Execution of Script Failed with no reason

ToniKautto — Tue, 18 Mar 2014 20:08:44 GMT

Does the document script log end with a "Execution finished." line?

If this is the case, there is nothing wrong with the script syntax, but your additional script more likely results in a heavy synthetic key. If a synthetic key is to complex or heavy for QlikView to resolve, the reload can fail with an error message like the one you see.

A synthetic key is generated if two (or more) tables have more than one field in common. If you for example intended to auto-concatenate two table, but one has a misspelled field name the result will be a synthetic key.

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 20:13:35 GMT

The document script log does end with an "Execution finished." line. I qualified * when I created the QVD file for the new table I loaded to the application. I don't think there would be any synthetic key...:(

Re: Execution of Script Failed with no reason

Tue, 18 Mar 2014 20:21:51 GMT

Thats ok I thought you were a developer. would it be ok to paste the script as a text file here.

Its extremely tough to debug without that.

A few more suggestions I can think of - After the old script try commenting out everything(the new script) and reload.

Then slowly try uncommenting the the new script step by step like one set of code at a time and see where exactly this error is happening.

How to use Trace:

Lets say you have a table like

Customers:

Load*

From Customers.qvd(qvd);

Let vCount = noofrows('Customers');

Trace 'No of records in Customer table is: $(vCount)' ;

You can do this before and after the table which will help you find out if the # of records is consistent or not.

Re: Execution of Script Failed with no reason

Tue, 18 Mar 2014 20:26:16 GMT

Is it possible to delete the qvd files and create them again?

After that you can try to run the script again. I had the same problem and it worked fine for me.

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 20:39:53 GMT

I'd think it's a logical loop in the data model, but "qualify *" rules it out...

Can you create new qvw, copy the whole script, and try to reload?

Re: Execution of Script Failed with no reason

julian_rodriguez — Tue, 18 Mar 2014 20:43:41 GMT

This error happens when there is logical error too. For example, an aggregation function like Sum(), Min(), Max(), without the Group by sentence.

Which special functions are you using?

Can you execute your scritpt step by step and see on which line is ending?... pherhaps you may share with us this single line...

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 20:46:10 GMT

Hi Michael,

Thank you so much!! It successfully reloaded!! But does that mean I have to design the whole dashboard all over again?!

Would you guys be able to figure out what happened to my old application...? It makes me feel extremely insecure. It's like my work can be damaged at any time...:(

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 20:54:58 GMT

Thanks, Toni.

I am a developer. But a dummy developer who just got started...

The # of records is consistent. I feel my original application was destroyed for some reason. I recreated another application, copied and pasted the entire script and it's successfully reloaded!

I really wanna know what happened to my old application. It should be damaged for a reason...

Thanks again!

Lynn

Re: Execution of Script Failed with no reason

Anonymous — Tue, 18 Mar 2014 22:25:06 GMT

Well, you can copy/paste the front end, sheet by sheet.

The only part to re-create manually are the variables. If there are many, create an input box with all variables in the broken app, and copy into the new one. But variable definitions are not copied, sorry.

Re: Re: Execution of Script Failed with no reason

ToniKautto — Wed, 19 Mar 2014 06:27:31 GMT

QlikView Project (PRJ) folder is a easy way to export the QVW content to file and then recreate the content in a new QVW file. See "QlikView Project Folders" in reference manual.

Variables and data are not part of the PRJ folder structure. Data will be restored once you reload the QVW, but variables you need to export and import through the script, to avoid a too painful manual work. See below for script examples on how to export and import the variables through your script.

STORE ALL VARIABLES INTO A QVD FILE

VariableNames:

LOAD Name AS VariableName

FROM [MyApplication-prj\AllProperties.xml] (XmlSimple, Table is [AllProperties/VariableProperties/VariableProperties]);

FOR i=0 TO NoOfRows('VariableNames')

LET varName = Peek('VariableName', $(i), 'VariableNames');

LET varValue = $(varName);

Variables:

LOAD

'$(varName)' AS VariableName,

'$(varValue)' AS VariableValue

AutoGenerate 1;

STORE Variables INTO Variables.qvd (QVD);

DROP Tables VariableNames, Variables;

RESTORE ALL VARIABLES FROM A QVD FILE

Variables:

LOAD VariableName,

VariableValue

FROM Variables.qvd (qvd);

FOR i=0 TO NoOfRows('Variables')

LET vVar = Peek('VariableName', $(i), 'Variables');

LET vVal = Peek('VariableValue', $(i), 'Variables');

LET '$(vVar)' = '$(vVal)';

DROP TABLE Variables;