Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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