Error(s) with v6.0.18.6833
Binks
Posts: 10 New member
Hi,
Since upgrading to v6.0.18.6833 last Wednesday (1/25) the email alerts I receive from SQL Monitor display "The underlying data for this alert has been purged:" in the details section where the details of the alert would normally be shown and "unknown" for Process Name, Database, Host, User, etc.
Errors like this one are in the event log.
The one thing that stands out is that the time of the event in the event log is 1/31/2017 7:34:17 AM, but then in the error it says "Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM" which would be in the future. Perhaps this value is in GMT though.
Log Name: Red Gate Software
Source: SQL Monitor 6
Date: 1/31/2017 7:34:17 AM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: *****
Description:
2017-01-31 13:34:17,871 [42] ERROR RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory [(null)] - Assuming alert data purged
System.Data.ObjectNotFoundException: Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel.GetHeadProcess(IEnumerable`1 allProcesses)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel..ctor(AlertDefinition alertTypeDefinition, AlertInstance alertInstance, IRepositoryDataPresenter dataPresenter, IQueryRangeProvider queryRangeProvider)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory.GetSpecificAlertTypeViewModel(AlertInstance alertInstance, AlertDefinition alertTypeDefinition, IRepositoryDataPresenter dataPresenter, IUtcDateTimeProvider utcDateTimeProvider, IAlertConfigurationProvider alertConfiguration, IAlertControllerHelper alertControllerHelper, IQueryRangeProvider queryRangeProvider, ISqlServerAliasRepository serverAliasRepository)System.Data.ObjectNotFoundException: Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel.GetHeadProcess(IEnumerable`1 allProcesses)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel..ctor(AlertDefinition alertTypeDefinition, AlertInstance alertInstance, IRepositoryDataPresenter dataPresenter, IQueryRangeProvider queryRangeProvider)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory.GetSpecificAlertTypeViewModel(AlertInstance alertInstance, AlertDefinition alertTypeDefinition, IRepositoryDataPresenter dataPresenter, IUtcDateTimeProvider utcDateTimeProvider, IAlertConfigurationProvider alertConfiguration, IAlertControllerHelper alertControllerHelper, IQueryRangeProvider queryRangeProvider, ISqlServerAliasRepository serverAliasRepository)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SQL Monitor 6" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-01-31T13:34:17.000000000Z" />
<EventRecordID>1049</EventRecordID>
<Channel>Red Gate Software</Channel>
<Computer>*****</Computer>
<Security />
</System>
<EventData>
<Data>2017-01-31 13:34:17,871 [42] ERROR RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory [(null)] - Assuming alert data purged
System.Data.ObjectNotFoundException: Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel.GetHeadProcess(IEnumerable`1 allProcesses)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel..ctor(AlertDefinition alertTypeDefinition, AlertInstance alertInstance, IRepositoryDataPresenter dataPresenter, IQueryRangeProvider queryRangeProvider)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory.GetSpecificAlertTypeViewModel(AlertInstance alertInstance, AlertDefinition alertTypeDefinition, IRepositoryDataPresenter dataPresenter, IUtcDateTimeProvider utcDateTimeProvider, IAlertConfigurationProvider alertConfiguration, IAlertControllerHelper alertControllerHelper, IQueryRangeProvider queryRangeProvider, ISqlServerAliasRepository serverAliasRepository)System.Data.ObjectNotFoundException: Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel.GetHeadProcess(IEnumerable`1 allProcesses)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel..ctor(AlertDefinition alertTypeDefinition, AlertInstance alertInstance, IRepositoryDataPresenter dataPresenter, IQueryRangeProvider queryRangeProvider)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory.GetSpecificAlertTypeViewModel(AlertInstance alertInstance, AlertDefinition alertTypeDefinition, IRepositoryDataPresenter dataPresenter, IUtcDateTimeProvider utcDateTimeProvider, IAlertConfigurationProvider alertConfiguration, IAlertControllerHelper alertControllerHelper, IQueryRangeProvider queryRangeProvider, ISqlServerAliasRepository serverAliasRepository)
</Data>
</EventData>
</Event>
Let me know if you need me to provide any additional information.
Thanks.
Since upgrading to v6.0.18.6833 last Wednesday (1/25) the email alerts I receive from SQL Monitor display "The underlying data for this alert has been purged:" in the details section where the details of the alert would normally be shown and "unknown" for Process Name, Database, Host, User, etc.
Errors like this one are in the event log.
The one thing that stands out is that the time of the event in the event log is 1/31/2017 7:34:17 AM, but then in the error it says "Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM" which would be in the future. Perhaps this value is in GMT though.
Log Name: Red Gate Software
Source: SQL Monitor 6
Date: 1/31/2017 7:34:17 AM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: *****
Description:
2017-01-31 13:34:17,871 [42] ERROR RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory [(null)] - Assuming alert data purged
System.Data.ObjectNotFoundException: Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel.GetHeadProcess(IEnumerable`1 allProcesses)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel..ctor(AlertDefinition alertTypeDefinition, AlertInstance alertInstance, IRepositoryDataPresenter dataPresenter, IQueryRangeProvider queryRangeProvider)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory.GetSpecificAlertTypeViewModel(AlertInstance alertInstance, AlertDefinition alertTypeDefinition, IRepositoryDataPresenter dataPresenter, IUtcDateTimeProvider utcDateTimeProvider, IAlertConfigurationProvider alertConfiguration, IAlertControllerHelper alertControllerHelper, IQueryRangeProvider queryRangeProvider, ISqlServerAliasRepository serverAliasRepository)System.Data.ObjectNotFoundException: Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel.GetHeadProcess(IEnumerable`1 allProcesses)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel..ctor(AlertDefinition alertTypeDefinition, AlertInstance alertInstance, IRepositoryDataPresenter dataPresenter, IQueryRangeProvider queryRangeProvider)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory.GetSpecificAlertTypeViewModel(AlertInstance alertInstance, AlertDefinition alertTypeDefinition, IRepositoryDataPresenter dataPresenter, IUtcDateTimeProvider utcDateTimeProvider, IAlertConfigurationProvider alertConfiguration, IAlertControllerHelper alertControllerHelper, IQueryRangeProvider queryRangeProvider, ISqlServerAliasRepository serverAliasRepository)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SQL Monitor 6" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-01-31T13:34:17.000000000Z" />
<EventRecordID>1049</EventRecordID>
<Channel>Red Gate Software</Channel>
<Computer>*****</Computer>
<Security />
</System>
<EventData>
<Data>2017-01-31 13:34:17,871 [42] ERROR RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory [(null)] - Assuming alert data purged
System.Data.ObjectNotFoundException: Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel.GetHeadProcess(IEnumerable`1 allProcesses)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel..ctor(AlertDefinition alertTypeDefinition, AlertInstance alertInstance, IRepositoryDataPresenter dataPresenter, IQueryRangeProvider queryRangeProvider)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory.GetSpecificAlertTypeViewModel(AlertInstance alertInstance, AlertDefinition alertTypeDefinition, IRepositoryDataPresenter dataPresenter, IUtcDateTimeProvider utcDateTimeProvider, IAlertConfigurationProvider alertConfiguration, IAlertControllerHelper alertControllerHelper, IQueryRangeProvider queryRangeProvider, ISqlServerAliasRepository serverAliasRepository)System.Data.ObjectNotFoundException: Could not find blocking process with session id 308 and login time 1/31/2017 1:32:14 PM
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel.GetHeadProcess(IEnumerable`1 allProcesses)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.BlockingSqlProcessViewModel..ctor(AlertDefinition alertTypeDefinition, AlertInstance alertInstance, IRepositoryDataPresenter dataPresenter, IQueryRangeProvider queryRangeProvider)
at RedGate.Response.Engine.Alerting.Base.Core.AlertTypeModels.AlertTypeViewModelFactory.GetSpecificAlertTypeViewModel(AlertInstance alertInstance, AlertDefinition alertTypeDefinition, IRepositoryDataPresenter dataPresenter, IUtcDateTimeProvider utcDateTimeProvider, IAlertConfigurationProvider alertConfiguration, IAlertControllerHelper alertControllerHelper, IQueryRangeProvider queryRangeProvider, ISqlServerAliasRepository serverAliasRepository)
</Data>
</EventData>
</Event>
Let me know if you need me to provide any additional information.
Thanks.
Comments
Please let me know if you would like information from my logs as well but the error message is the same as above, just a different spid.
We've seen several reports of this issue and it is being investigated under internal reference SRP-11016. I'll update here when we have any further information (or if we need more information from you TUellner).
Thanks for letting us know!
Kind regards,
Alex
Have you visited our Help Center?