topic Re: Exception Handling in QlikView

Exception Handling

Fri, 04 Oct 2013 11:12:32 GMT

Kindly give me sometips on this as there are errors popping when reloading but not getting the exact error.

Please help me with the common type of errors in scripting when we reload.

Re: Exception Handling

shree909 — Fri, 04 Oct 2013 14:10:34 GMT

Hi,

In order to check the errors , don't reload everything at one time.

use debug in the extract script and try to load only few rows of data. u have an option of doing it by step by step and animate. and use some break points . so that u will know where exactly u are making the errors.

Hope this helps

Thanks

Re: Exception Handling

Anonymous — Fri, 04 Oct 2013 14:44:16 GMT

By using the log file also you can find the error.

Re: Exception Handling

Anonymous — Fri, 04 Oct 2013 14:48:44 GMT

Check for missing "," commas or semicolons ";"

Check for proper use of "Group by" if any aggregation is performed anywhere

Check for Proper use of table names in case of working with joins

Re: Exception Handling

Mon, 07 Oct 2013 10:56:27 GMT

Thank you all.

as mentioned above most errors occur due to commas

Re: Re: Exception Handling

Anonymous — Mon, 07 Oct 2013 14:29:54 GMT

then you should use the Syntax Check option before you run the script.