Get ODBC error into email?

grussell · Joined: 21 Jan 2010 Posts: 36

We are using an ODBC driver to push the log results to an SQL database. We’ve setup the option to notify us via email should the system be unable to publish the log.

But how do we get the error message generated by the SQL server/ODBC driver into the email? I have gone through the macro variables but can’t see an option?

For instance – the SQL database may return “unable to convert string to int….” or "timeout" ..etc – how do we get this into the email? I can see the message in the bottom message bar of HostMonitor?

Thanks,

Gavin.

KS-Soft · Joined: 03 Apr 2002 Posts: 12303 Location: USA

Logging errors recorded into system log file specified on System Log page in the Options dialog. If you are using text file for system log then you may setup Text Log test method to check for some specific error and assign "Send e-mail" action to the test.
On the other hand, if you want to check connection to SQL server and send e-mail in case of some problem, you should use ODBC Query test.

Regards
Alex

grussell · Joined: 21 Jan 2010 Posts: 36

Thanks for your response - it didn't quite answer my question.

I am wondering how we get the last system error into a variable to be used within an alert email?

Thanks.

KS-Soft · Joined: 03 Apr 2002 Posts: 12303 Location: USA

If you are using text file for system log then you may setup Text Log test method to check for some specific error and assign "Send e-mail" action to the test.
Otherwise I do not see any option.

Regards
Alex

grussell · Joined: 21 Jan 2010 Posts: 36

ok - then a useful feature request would be a variable that holds the details of the last system error.

Thanks

KS-Soft · Joined: 03 Apr 2002 Posts: 12303 Location: USA

And how you can use this variable? Start some action every 5 min?

Regards
Alex

grussell · Joined: 21 Jan 2010 Posts: 36

In the "Options" under "Log settings" I have "Execute alert profile when log inaccessible" generating an "Email"

I would want to use this variable in this alert email so I receive an email telling me the SQL error that preventing the log from being written.

Thanks

KS-Soft · Joined: 03 Apr 2002 Posts: 12303 Location: USA

Ok, we implement this option in next version.

Regards
Alex

grussell · Joined: 21 Jan 2010 Posts: 36

Is this in 8.50 now?

Thanks

KS-Soft · Joined: 03 Apr 2002 Posts: 12303 Location: USA

Yes.
Quote:
==================
New %HM_LastLoggingError% macro variable can be used as parameter of the actions. It represents description of last logging error (if any); can be useful for actions triggered by HostMonitor when it cannot save data into the log
==================

http://www.ks-soft.net/hostmon.eng/news.htm

Regards
Alex