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

Andrew HodgeAndrew Hodge Posts: 132
edited October 6, 2010 6:58AM in SQL Monitor Previous Versions
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 '[email protected]__45D1FE37'. Cannot insert duplicate key in object '#44DDD9FE'.' : SQL Server MEDSQLWEB1 (code 2627)

Andrew Hodge


Sign In or Register to comment.