topic Script execution fail. in QlikView

Script execution fail.

Sat, 03 Dec 2011 07:35:17 GMT

When i'm loading my qvw file with updated qvd file i'm getting the script execution fail error message. Can anyone help why this error message shows when qvd file is updated with new data.

Here i'm attaching zip file which consists of two qvd files with less data and one 1 qvw file. can anyone please check this and help me how to overcome this. I'm trying from long period on this but still i'm not able to resovle this issue.

Script execution fail.

Sat, 03 Dec 2011 07:53:49 GMT

Qlikview guru's please help me on this..

Re: Script execution fail.

llauses243 — Sat, 03 Dec 2011 11:11:01 GMT

Hi ,

Your case is very interesting, funct with V9, no funct with V10 ¡¡

Moreover your script can be more simple using SUB in script

This will continue ...

Good luck, Luis

Script execution fail.

Sat, 03 Dec 2011 11:46:08 GMT

Luis Laura,

Thanks a lot for your relpy. But i'm not able to understand what u r saying for me. Is there any solution for this. Right now i'm using SR3 qlikview 10 version.

Script execution fail.

swuehl — Sat, 03 Dec 2011 22:26:49 GMT

jacq,

I think the problem is the multiple use of

INPUTFIELD MinIMM,MaxIMM;

Try removing all occurences except the first. This did the job for me (QV10 SR3).

Regards,

Stefan

Script execution fail.

Mon, 05 Dec 2011 11:12:07 GMT

Ya your right. I had tried what you said but, still my problem is not solved.

Script execution fail.

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 11:22:49 GMT

Hi Jacq,

Even with the inputfields in place (that actually accept as many fields as you want, even wildcards just fine), the reload finishes all right.

What error are you getting and when? Did you do a debug load to see where the script stops?

Hope that helps.

Miguel

Script execution fail.

Mon, 05 Dec 2011 12:11:27 GMT

Miguel,

I'm getting the error message as "Execution of script failed. Reload old data". This error comes when i reload qvw file with updated qvd file.

I've seen debug mode also to find where the problem is. It is executing entire script without any problem, I can also able to see "---------Script Finished--------------". But when i Click on Close button it shows the above mentioned error.

Re: Script execution fail.

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 12:22:18 GMT

Jacq,

Is there any chance that you are using QV 10 SR3 build 9055? That release was updated with QV 10 SR3 build 9061. If so, upgrade and it should run all right.

Apart from that, is there any other piece of code in your script in addition to the application you have uploaded? (There are lots of lines commented that may be causing unwanted synthetic keys, concatenations or so).

Hope that helps.

Miguel

EDIT: In addition to the above, the Release Notes for SR3 and SR4 read:

Inputfields are not compatible with joins or resident loads. The reason for this is that an inputfield must be read one time and one time only. Once the inputfield is read it is added to an inputfield table and this table cannot be tampered with. Joins affect the table and for that reason inputfields are disabled when combined with joins. Resident works slightly different but it also affects the inputfield table and it is disabled for the same reason.

Release Notes for SR4 have one bug corrected that reads:

41848 Document Reload Fails with Inputfield

Whatever that means without futher details, upgrading to the SR4 may worth the effort to check whether that solves your issue or not.

Re: Script execution fail.

Mon, 05 Dec 2011 13:12:12 GMT

I'm using QV 10 SR3 build 9061.7. Ya i'm executing the uncomment code also.

Let me explain why i developed that:

I've around 300 fields. The end user wants to see Min and Max of those fields and he want to choose his own fields by changing the Min and Max values.

For Eg:

A, B, C, D are the fields

Now he want to see all this in one group along with min and max

Group Min Max

A 10 20

B 12 34

C 0 6

D 1 5

For this i've taken one listbox along with expression to display Min and Max. When he choose A i'm allowing to change min and max values through the table box.

Re: Script execution fail.

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 14:11:43 GMT

Hi Jacq,

It's loading the whole script here (all lines uncommented) just fine and shows data, and leaves me to change values in fields (I'm using 10 SR4 x64 and 9 SR4 x64). You see that there are some known issues when INPUTFIELD works together with RESIDENT, and that may be the cause of the failure in your system.

I don't know what else to say, other than as you are already renaming fields, use just one INPUTFIELD line before the first load.

Hope that helps.

Miguel

Re: Script execution fail.

Tue, 06 Dec 2011 08:31:07 GMT

Can you plz once again try the enclosed qvw file, with changing the qvd file names which i've been attached in previous zip file. First reload the application with RTQMain.qvd, if execution is success then reload the application with 2.qvd. In both cases if execution is sucess then there is a problem with my qlikview version which i'm using.

Right now i'm using QV 10 SR3 build 9061.7. But you are using 10 SR4 x64 and 9 SR4 x64. Can you help me where can i download this versions.

Re: Script execution fail.

llauses243 — Tue, 06 Dec 2011 18:43:17 GMT

Hi jacq,

This is my offer for any version ...

. script more simple using SUB & CALL

. if the fields in cuestion contains numeric values, u must change using function ISNUM

Pls to see image attached

Good luck, Luis

Re: Script execution fail.

Miguel_Angel_Baeyens — Wed, 07 Dec 2011 08:29:11 GMT

Hi Jacq,

In the first line where you load all fields from RTQMain.qvd or 2.qvd, comment that line and set "*" instead (to load all fields). Then run the script. That should work.

Actually, RTQMain.qvd loads without problem. 2.qvd does create an error as you mentioned above. Changing that line to "*" works just fine.

If you still need the file reloaded, let me know.

Hope that helps.

Miguel

OK: forgot what I said above (I'll leave it anyway). The issue happens with the IsNull() function. Leave it all as it was in your original upload, but change your WHERE clause to this in each file you load:

While Len(FieldValue('BCShotHoldPressTime2R', IterNo())) > 0;

Using Len(field) > 0 instead of Not IsNull(field). IsNull() keeps behaving wrong in different computers with different data, and usually with x64 architecture computers. It's not the first time it happens to me, and I've read several posts in the QlikCommunity in this regard. It's not documented and likely have to do with how QlikView deals with the data source (in some cases and "empty" value is not a "null" value or a "blank" value).

Functionality of both is the same. If the length of a given value is zero, then we can assume the value is null. It doesn't degrade performance and will work fine with bot x64 and 32 bits systems.

Re: Script execution fail.

Wed, 07 Dec 2011 12:36:50 GMT

Thanks a lot miguel.. But it is amazing to me 2 see the difference b/w IsNull() and Len(field)>0.

B'coz the result is same when we use both functionalities according to theory in qlikview. But at lost Len(field) >0 given me exact result.

Re: Script execution fail.

Miguel_Angel_Baeyens — Wed, 07 Dec 2011 12:42:24 GMT

Hi Jacq,

I know and perhaps it's worth writing an idea or opening a support case to see in what cases the null is such in QlikView when functions IsNull() or NullCount() or MissingCount() are involved and the differences between them.

I started doing the Len() thing some time ago for x64 computers, now I always do this, regardless the computer and the possible values (null, empty, blank, whatever).

Regards.

Miguel

Re: Script execution fail.

Wed, 14 Dec 2011 12:47:48 GMT

Miguel,

Previously what we developed script is not generating exact min and max values. Can you please check once.

I had created new thread in qlikview community for this. See this Link .

Re: Script execution fail.

Thu, 15 Dec 2011 12:40:57 GMT

Miguel can you please check it once. I'm not able to find the way how to overcome this.