How can we help you today? How can we help you today?

No data available on Analysis

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?
nigelhooper
0

Comments

5 comments

Sort by
  • priyasinha
    Hi Nigel,

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

    Thanks,
    Priya
    priyasinha
    0
  • nigelhooper
    There are no connection errors on the Configuration > Monitored servers page.
    nigelhooper
    0
  • priyasinha
    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
    priyasinha
    0
  • nigelhooper
    If any one else has the same problem, I solved it by restarting the SQL Monitor 2 Base Monitor service.
    nigelhooper
    0
  • KristofDM
    Restaring the BASE 3 service helped me out!
    ty ;)
    KristofDM
    0

Add comment

Please sign in to leave a comment.