Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
richnorris
Creator II
Creator II

Suppress Error messages on reload?

We are running a scheduled task to reload our QVD file from a database every day. The task runs a VB script which keeps retrying every minute until a new QVD has been generated. A new QVD will not be generated until the database is ready. What we have found is that sometimes there is a job running on the database which causes a conflict with the Qlikview reload attempt, and Qlikview gives an indeterminate SQL error message. This means we manually have to click on 'OK' and cancel the reload. It doesn't matter that it gets these errors, because the task will automatically retry until it has succeeded, so we just need a way to surpress the SQL Error messages in Qlikview. Does such a feature exist? Something like, on error, automatically close? Thanks.

1 Solution

Accepted Solutions
Not applicable

Try something like this

set ErrorMode=0; or set ErrorMode=4 or 5 ; or see help on ErrorMode

If ErrorMode = 4 then

.......

Endif

Talha

View solution in original post

1 Reply
Not applicable

Try something like this

set ErrorMode=0; or set ErrorMode=4 or 5 ; or see help on ErrorMode

If ErrorMode = 4 then

.......

Endif

Talha