topic Re: Document reload fails in QlikView

Document reload fails

Tue, 13 Oct 2015 12:04:18 GMT

Hi,

My application loads all data with no error ( i.e. ScriptError is 0); however, after completion QV displays "Execution of Script Failed"?

I have turned on the logging but have not been useful as there is no error.

I shutdown the QV instance and reopened the application, problem still remains.

Any idea, help !!!

Much appreciated.

Sibtain

Re: Document reload fails

Tue, 13 Oct 2015 12:19:20 GMT

does the reload fail when doing a manual reload or on a scheduled reload/manual through QMC

Re: Document reload fails

Anonymous — Tue, 13 Oct 2015 12:21:21 GMT

Hi Sibtain,

Are they lot of synthetic keys?try to resolve them.

Re: Document reload fails

Peter_Cammaert — Tue, 13 Oct 2015 12:21:40 GMT

Do you have any SUB definitions in your script code? Even though at the moment you may not use any of them?

Re: Document reload fails

Tue, 13 Oct 2015 12:25:56 GMT

Manual reload on my desktop.

Re: Document reload fails

sergiorey — Tue, 13 Oct 2015 12:26:07 GMT

Hi Sibtain,

Have you tried reloading in Debug mode so as to detect any problems?

Re: Document reload fails

Tue, 13 Oct 2015 12:27:12 GMT

No, not a single SK.

Re: Document reload fails

Anonymous — Tue, 13 Oct 2015 12:28:24 GMT

Yes try limit load option in Debug dialog and check if script is having any issues....

Re: Document reload fails

Tue, 13 Oct 2015 12:31:08 GMT

Yes, i have tried this option as well with no luck. The script would complete without error yet will not reload.

Re: Document reload fails

rajkumarb — Tue, 13 Oct 2015 12:31:31 GMT

are you Trying to load data from SQL

if its then check if you missed any semicolons at the end

Re: Document reload fails

Anonymous — Tue, 13 Oct 2015 12:34:16 GMT

Are they any complex calculations or transformations?

What is the size of the data?

Check for memory usage as well.

Re: Document reload fails

qlikviewwizard — Tue, 13 Oct 2015 12:34:59 GMT

Follow the three steps :

1. Close all the folders, files and reload. It will works.

2. Else debug with zero records.

3.run step by step by using exist script ; command.

Still facing the issue, upload your qvw with sample data .

Hope this will help you.

Re: Document reload fails

Gabriel — Tue, 13 Oct 2015 12:36:58 GMT

Hi,

Are you loading from QVD file(s)

Re: Document reload fails

jonathandienst — Tue, 13 Oct 2015 12:42:23 GMT

Do you have an Exit Script statement with code after the statement. This code gets parsed, even though it is not executed and a parse error (eg Next without For etc) will still be thrown.

How do you know that there are no syn keys if the script does not terminate successfully?

Re: Document reload fails

Tue, 13 Oct 2015 12:50:08 GMT

Because the col names are unique and appeared in the viewer properly before this error.

Re: Document reload fails

Peter_Cammaert — Tue, 13 Oct 2015 12:52:49 GMT

That's weird Jonathan, because the QlikView engine is an interpreter and not a look-ahead parser in any way.

Also I cannot duplicate this behavior, even when I put broken FOR statements and even plain garbage after an EXIT SCRIPT;

Do you have any examples? (you did make me curious )

Peter

Re: Document reload fails

Tue, 13 Oct 2015 12:57:40 GMT

Now, the document loads successfully. I did following:

Loaded my document in steps; placing 'Exit Script' after each table load and did it for all the tables and reloaded and during this process i came across no error.

Finally, error has disappeared.

Anyway, thank you gentlemen for your quick replies and suggestions.

I hope that this does not appear again !

Regards,

Sibtain

Re: Document reload fails

Tue, 13 Oct 2015 13:01:29 GMT

I am curious too. I use exit script as a habit and have never come across with such a problem. As a matter of fact this problem is solved (I hope it is ) with the help of Exit Script; while developing there is a lot of dead code after it and it never bothered me.

Sibtain

Re: Document reload fails

qlikviewwizard — Tue, 13 Oct 2015 13:12:39 GMT

wwhat is the reason for the issu?

CLosing all the applications,folders,files or what?

I think Exist script won't be the cause of issue.

PLease share..