topic Re: I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's? in QlikView

I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's?

Fri, 19 Jun 2015 05:49:03 GMT

Help needed.........

Re: I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's?

aveeeeeee7en — Fri, 19 Jun 2015 05:54:20 GMT

Try Errormode=0;

Use SET ErrorMode=0; at the Starting of your Script.

See this:

Regards

Av7eN

Re: I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's?

MayilVahanan — Fri, 19 Jun 2015 05:59:02 GMT

Try like

Set ErrorMode = 0;

Please refer the error handling

Error Handling in Qlikview

Re: I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's?

jagan — Fri, 19 Jun 2015 06:01:22 GMT

Hi,

Try ErrorMode in your script

Put this script at the beginning of your script, to skip if any error occurs.

SET ErrorMode=0;

Regards,

jagan.

Re: I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's?

Fri, 19 Jun 2015 06:09:19 GMT

Hi,

If we keep ErrorMode=0 it skips the error and reload will be done how can we know a error occured at particular qvd and it is loaded are not....
help....

Re: I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's?

jagan — Fri, 19 Jun 2015 06:18:35 GMT

Hi,

Check the log file for details about the failure

You can log the custom log message using TRACE & ScriptErrorList statements

SET ERRORMODE = 0;

LOAD

RESIDENT Test;

If ScriptError <> 0 THEN

TRACE Error Message : $(ScriptErrorList) ;

ENDIF

You can enable log file using

Settings -> Document Properties -> General -> select Generate Log File option

Hope this helps you.

Regards,

Jagan.

Re: I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's?

aveeeeeee7en — Fri, 19 Jun 2015 06:22:55 GMT

Try ErrorMode=1;

It will show you error >> Ok it >> After this, it will Reload the Other Qvds.

Regards

Av7eN

Re: I had 5 QVD's while reloading i got error at 3rd QVD,How to skip that error and want to reload other 2 qvd's?

Fri, 19 Jun 2015 06:29:12 GMT

Hi,

thanks for reply

Regards

Sai