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

Andrew Hodge

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

Have restarted the service and it appears to be working ok. Still getting the above error (DBNull) in the logs though.

Anu D

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?