Red Gate forums :: View topic - Error in the SQL Response logs / hung instance of sql respon
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

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

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Andrew Hodge



Joined: 19 Jul 2007
Posts: 90
Location: Kent, UK

PostPosted: Tue Oct 05, 2010 7:49 am    Post subject: Error in the SQL Response logs / hung instance of sql respon Reply with quote

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
Back to top
View user's profile Send private message
Andrew Hodge



Joined: 19 Jul 2007
Posts: 90
Location: Kent, UK

PostPosted: Tue Oct 05, 2010 7:50 am    Post subject: Reply with quote

Have restarted the service and it appears to be working ok. Still getting the above error (DBNull) in the logs though.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 662
Location: Cambridge

PostPosted: Wed Oct 06, 2010 11:58 am    Post subject: Reply with quote

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/Content.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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group