Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

Help needed.........

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

7 Replies
aveeeeeee7en
Specialist III
Specialist III

Try Errormode=0;

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

See this:

ErrorMode.png

Regards

Av7eN

MayilVahanan

Hi

Try like

Set ErrorMode = 0;

Please refer the error handling

Error Handling in Qlikview

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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....

jagan
Luminary Alumni
Luminary Alumni

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.

aveeeeeee7en
Specialist III
Specialist III

Try ErrorMode=1;

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

Regards

Av7eN

Not applicable
Author

Hi,

thanks for reply

Regards

Sai