Exception Handling

[#1]

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.

[shree909]

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

[Anonymous]

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

[Anonymous]

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

[#5]

Thank you all.

as mentioned above most errors occur due to commas

[Anonymous]

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