topic Re: Partial reload - leads to script_errors being reported? Plz help. in QlikView

Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Thu, 01 Dec 2016 14:33:11 GMT

Hi,

in the script I'm currently working on, a specific table is being generated to report certain items.

Due to a process error, however, there can be wrong items in this table - so I want to offer the user a possibility to check those items.

To do that, the script has to be reloaded - but as this table has not been stored as a qvd, I would have to keep this table

=> A partial reload looks like just the thing I need. I have done some work with that feature and I have taken some notes - the "negative query" >>NOT(ISPARTIALRELOAD())<< has to come first, right?

So I have a code >> IF NOT(ISPARTIALRELOAD()) THEN <<, followed by everything I have in the script for standard situations. After all that is finished, just before the EXIT, I have implemented the second branch with an >> IF ISPARTIALRELOAD()) THEN << - but when I try this and partially reload the script, QlikView reports errors with one of the LOOPs in the course of the regular script_branch ...

Can anyone lend me a hand here?

Thanks a lot!

Best regards,

DataNibbler

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 08:31:55 GMT

Hi,

I have a better idea: There is this one big table that I need to consult several times in the script - that is prepared at the very outset of the script to make the following LOADs faster (only RESIDENT) - but the primary loading of the table still takes time. Now, if the users of this report check one item using the report, and within 2min they use it again, that is not really necessary - that big table itself is only renewed once an hour by another script.

The partial reload, however, is not explained in detail in any of my ebooks nor is it in the manual, and I haven't really worked with it yet. Can someone please help me with that?

I already have the script finished, quite complex, with several subroutines. As I understand it, when a partial reload is done, the tables that don't have a prefix are not touched - so I want to kind of build that around my existing script - all the tables except that big one should be replaced - but how do I place the ISPARTIALRELOAD() query?

Thanks a lot!

Best regards,

DataNibbler

Re: Partial reload - leads to script_errors being reported? Plz help.

tresB — Fri, 02 Dec 2016 08:41:31 GMT

I guess I could not follow you entirely. If you use 'Replace load' for all the rest tables (except the big one), it should work, right? Am I missing something?

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 08:48:03 GMT

Hi Tresesco,

no - it should work then, right - but where do I place the query to get it right? That's the detail that I could not find anywhere. Do I place this query in front of every table, around the keyword? That looks easier to me, easier than placing this as one giant bracket around the entire script ...

Re: Partial reload - leads to script_errors being reported? Plz help.

tresB — Fri, 02 Dec 2016 08:52:21 GMT

Partial reload is only relevant to Load and Select statement, hence you have to place the keyword 'Replace' before every desired load/select statement.

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 09:02:36 GMT

Yep, I know - we're still not meeting 😉

Best, I will post a sample here - a very simple one. My script is complex, but the logic should be the same ...

>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<

Temp1:

LOAD 1 as ONE, 2 as TWO, 3 as THREE autogenerate 1; // This table should be loaded only in a full reload;

// In a partial reload, it should just be left where it is

Temp2:

LOAD 'a' as letter1, 'b' as letter2, 'c' as letter3 autogenerate 1; // This table should be loaded in both a full and a partial

// reload.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

In this small example, where would I place the ISPARTIALRELOAD() query? I don't want to write the whole stuff a second time in my script

Re: Partial reload - leads to script_errors being reported? Plz help.

tresB — Fri, 02 Dec 2016 09:18:54 GMT

I guess you just need a Replace/Add keyword before second reload like:

Temp2:

Replace LOAD 'a' as letter1, 'b' as letter2, 'c' as letter3 autogenerate 1;

IsPartialreload() is not required here.

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 09:23:49 GMT

Ah, I see.

I'm working on Wifi right now, so i cannot try it out - that would be too much for our network ...

So that keyword would be ignored in a regular (full) load, right?

So I usually don't need this ISPARTIALRELOAD() - what then would I need that for?

Thanks a lot!

Best regards,

DataNibbler

P.S.: [5min later] - needless to say, that works fine - so in my big script where I actually want to use this, I can just put the REPLACE keyword in front of every table except that big one. Wonderful!

Re: Partial reload - leads to script_errors being reported? Plz help.

tresB — Fri, 02 Dec 2016 09:38:39 GMT

As I mentioned, Partial reload would only execute statements Load/Select preceded by Add/Replace. If you come across a situation when you need to control other statements (apart from load/select) based on reload type (full/partial), something like:

if IsPartialreload() then

let vVar=1;

else

let vVar=2;

endif

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 09:52:06 GMT

Yes, I thought of something like that - I do have several variables and stuff in the script - but these should be executed in both reload-types, full and partial - so I don't have to do anything to them, do I?

Re: Partial reload - leads to script_errors being reported? Plz help.

tresB — Fri, 02 Dec 2016 09:58:51 GMT

No, you don't have to.

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 10:06:42 GMT

Thanks a lot!

I'll write that down in an internal "developer_guide" I have written for the reason I mentioned - these details seem to be nowhere to be found (except this Community) ...

Best regards,

DataNibbler

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 10:22:37 GMT

Hi Tresesco,

there is still a problem: When I do a partial reload, an issue is reported which must be in a piece of code that I have implemented as an INCLUDE file, judging from the error_message - I will have a look and if I cannot spot the error, I will be back here I just wanted to catch you before you leave 😉

Of course, if I make it and I don't need you to look in here anymore, I will tell you.

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 10:33:13 GMT

Ah - in that piece of code, one table is loaded, the number of records in that table then controls a FOR_NEXT clause. The issue must be with that table - from the error_message, it seems that the variable NoOfRows() cannot be calculated.

Let's see ...

Oh my - I cannot use the Debugger to step through this INCLUDE code ...

The funny thing is, this INCLUDE - like a few others - is used before the actual processing starts ...

Re: Partial reload - leads to script_errors being reported? Plz help.

datanibbler — Fri, 02 Dec 2016 10:45:18 GMT

Right - just like I thought - that table is not loaded in a partial reload (I used to not have the keyword in front of that LOAD) - so it was not loaded in the partial reload, the NoOfRows() could not be generated and the loop did not work.

I have to use the keyword - but why - oh, of course, the table is dropped after the loop has been executed 😉 So it just wasn't there for the partial reload ...

The thread is herewith closed. Thanks for your help with the first issue! Have a nice day!