Red Gate forums :: View topic - No data available on Analysis
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

No data available on Analysis

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nigelhooper



Joined: 08 Sep 2011
Posts: 3

PostPosted: Thu Sep 08, 2011 12:41 pm    Post subject: No data available on Analysis Reply with quote

Whenever I try to look at any of the entries on the Analysis tab it always says "No data available between X and now." Where X is 10 minutes ago.

The overviews tab also appears to be missing lots of data.

The C:\Documents and Settings\All Users\Application Data\Red Gate\Logs\SQL Monitor 2\Base Deployment*.log files have lots of entries as follows:

2011-09-08 11:24:53,579 [ 14] WARN RedGate.Response.Common.SmartAssembly.HeadlessUnhandledExceptionHandler - Report last sent at 09/08/2011 08:51:50. Report send skipped.
2011-09-08 11:25:01,048 [ 14] WARN RedGate.Response.Common.Utilities.Scheduling.JobRunner - Unhandled exception in job run: JobRef(DataCollectionScheduler:Root[].[Cluster][[Name]=goldeneagle].[Machine][[Name]=], IntervalJobSchedule(00:00:15))
System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "Cluster_Machine_LogicalDisk_UnstableSamples_Cluster_Machine_LogicalDisk_Keys". The conflict occurred in database "RedGateMonitor", table "data.Cluster_Machine_LogicalDisk_Keys", column 'Id'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
at (Object , DataTable )
at #vgv.#KZz.#MZz(SqlBulkCopy , SqlConnection , SqlTransaction , DataTable )
at #onv.#zov.#Ahz(SqlConnection , IDictionary`2 )
at #onv.#zov.#Tbo(#hjv , #CJv , IEnumerable`1 )
at #5mv.#eov.#fDv(#MJv , #hjv , #hjv , Boolean )
at #5mv.#eov.#t.#B3.#bcz()
at (Object )
at #jZ8.#Xf8.#2f8(#8l8 )


The SQL monitor was installed a couple of months ago by our DBA who has since left, I believe that it was working before he left but I am not sure.

It appears that we have SQL_Monitor_2.3.0.334.exe installed.

How do I fix this?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Thu Sep 08, 2011 3:30 pm    Post subject: Reply with quote

Hi Nigel,

Are there any connection errors on Configuration > Monitored servers page?

Thanks,
Priya
Back to top
View user's profile Send private message
nigelhooper



Joined: 08 Sep 2011
Posts: 3

PostPosted: Thu Sep 08, 2011 3:36 pm    Post subject: Reply with quote

There are no connection errors on the Configuration > Monitored servers page.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Thu Sep 08, 2011 3:41 pm    Post subject: Reply with quote

Hi Nigel,

Could you please send me the base monitor log files to priya.sinha@red-gate.com? It should be in C:\ProgramData\Red Gate\Logs\SQL Monitor 2 or equivalent location.

Thanks,
Priya
Back to top
View user's profile Send private message
nigelhooper



Joined: 08 Sep 2011
Posts: 3

PostPosted: Fri Sep 09, 2011 2:31 pm    Post subject: Reply with quote

If any one else has the same problem, I solved it by restarting the SQL Monitor 2 Base Monitor service.
Back to top
View user's profile Send private message
KristofDM



Joined: 05 Jun 2012
Posts: 3

PostPosted: Tue Jun 05, 2012 8:22 am    Post subject: Same issue, no solution... Reply with quote

Restaring the BASE 3 service helped me out!
ty Wink
Back to top
View user's profile Send private message
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