Error in the SQL Response logs / hung instance of sql respon
Andrew Hodge
Posts: 132
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
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
Comments
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?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com