Error in the SQL Response logs / hung instance of sql respon

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Error in the SQL Response logs / hung instance of sql respon

Postby Andrew Hodge » Tue Oct 05, 2010 7:49 am

Had an instance were SQL response repository service appears to have hung and we recieved no alerts.

Had a look in the log and could only find the following error

07:43:55.047|Error |AlertRepository |60 |DatabaseFileMonitor - MW_PGLive : 'Object cannot be cast from DBNull to other types.' : SQL Server MEDVMCARSQL (code 0)|System.InvalidCastException: Object cannot be cast from DBNull to other types.
at System.DBNull.System.IConvertible.ToDouble(IFormatProvider provider)
at System.Convert.ToDouble(Object value)
at al.a(ISqlDatabaseDescription , SqlConnection , IDictionary`2 )

Does this error prevent monitoring of the databases on this server?

Had some warnings about violation of primary key but but pretty sure this was looked at before and it was deemed to be ok

07:33:31.235|Warn |AlertRepository |45 |SysprocessMonitor : 'Violation of PRIMARY KEY constraint 'PK__@procs__45D1FE37'. Cannot insert duplicate key in object '#44DDD9FE'.' : SQL Server MEDSQLWEB1 (code 2627)

Andrew Hodge
Andrew Hodge
 
Posts: 90
Joined: Thu Jul 19, 2007 8:34 am
Location: Kent, UK

Postby Andrew Hodge » Tue Oct 05, 2010 7:50 am

Have restarted the service and it appears to be working ok. Still getting the above error (DBNull) in the logs though.
Andrew Hodge
 
Posts: 90
Joined: Thu Jul 19, 2007 8:34 am
Location: Kent, UK

Postby Anu Deshpande » Wed Oct 06, 2010 11:58 am

Many thanks for your post and apologies for inconvenience caused.

Can you kindly email us the log files? You can obtain the log files as specified in this article: http://www.red-gate.com/supportcenter/C ... aspx?p=SQL Response&c=SQL_Response%5cknowledgebase%5cSR_log_files.htm

And also can you confirm that you receive the alerts as per expectation?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests