Active Alerts Error opening Event ID 33333
Anyone have any ideas what might be causing this error? and yes i checked the database and that object does not exist. Running: SCOM 2007R2 Update 3, Windows 2003, SQL 2005. Error in Event Log Event Type: Warning Event Source: DataAccessLayer Event Category: None Event ID: 33333 Date: 11/11/2010 Time: 3:11:55 PM User: N/A Computer: NV-SCOM Description: Data Access Layer rejected retry on SqlError: Request: AlertViewWithChangesNoContext -- (LanguageCode1=ENU), (LanguageCode2=), (LastModified=11/4/2010 8:11:54 PM), (StateLastModified=11/4/2010 8:11:54 PM), (MMLastModified=11/4/2010 8:11:54 PM) Class: 16 Number: 208 Message: Invalid object name 'dbo.fn_AlertViewChangesNoContext'. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Error in Event Log Event Type: Error Event Source: OpsMgr SDK Service Event Category: None Event ID: 26319 Date: 11/11/2010 Time: 3:11:55 PM User: N/A Computer: NV-SCOM Description: An exception was thrown while processing SetupAlertsByCriteriaAndMonitoringClassReaderWithProperties for session id uuid:7a0dadf9-8b80-4ae7-ab43-deb0bb19cdcb;id=2. Exception Message: The creator of this fault did not specify a Reason. Full Exception: System.ServiceModel.FaultException`1[Microsoft.EnterpriseManagement.Common.UnknownDatabaseException]: The creator of this fault did not specify a Reason. (Fault Detail is equal to Invalid object name 'dbo.fn_AlertViewChangesNoContext'. QueryDefinition 'AlertViewWithChangesNoContext'.Invalid object name 'dbo.fn_AlertViewChangesNoContext'. QueryDefinition 'AlertViewWithChangesNoContext'.). For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Error In Client Date: 11/11/2010 3:17:24 PM Application: System Center Operations Manager 2007 R2 Application Version: 6.1.7221.49 Severity: Warning Message: Microsoft.EnterpriseManagement.Common.ServerDisconnectedException: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection. ---> System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state. Server stack trace: at System.ServiceModel.Channels.CommunicationObject.ThrowIfFaulted() at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.EnterpriseManagement.Common.IInstanceSpaceDataAccess.SetupAlertsByCriteriaAndMonitoringClassReaderWithProperties(String criteria, Guid monitoringClassId, Boolean recurse, String languageCode, Nullable`1 lastModified, Byte[] alertProperties) at Microsoft.EnterpriseManagement.DataAbstractionLayer.InstanceSpaceOperations.SetupAlertsByCriteriaAndMonitoringClassReaderWithProperties(MonitoringAlertCriteria criteria, Guid monitoringClassId, TraversalDepth traversalDepth, String languageCode, Nullable`1 lastModified, MonitoringAlertProperty[] properties) --- End of inner exception stack trace --- at Microsoft.EnterpriseManagement.DataAbstractionLayer.SdkDataAbstractionLayer.HandleIndigoExceptions(Exception ex) at Microsoft.EnterpriseManagement.DataAbstractionLayer.InstanceSpaceOperations.SetupAlertsByCriteriaAndMonitoringClassReaderWithProperties(MonitoringAlertCriteria criteria, Guid monitoringClassId, TraversalDepth traversalDepth, String languageCode, Nullable`1 lastModified, MonitoringAlertProperty[] properties) at Microsoft.EnterpriseManagement.OperationalDataManagement.GetPartialMonitoringAlertReaderInternal(MonitoringAlertCriteria criteria, ManagementPackClass managementPackClass, TraversalDepth traversalDepth, Nullable`1 lastModified, MonitoringAlertProperty[] properties) at Microsoft.EnterpriseManagement.OperationalDataManagement.GetPartialMonitoringAlertReader(ManagementPackClass managementPackClass, TraversalDepth traversalDepth, Nullable`1 lastModified, MonitoringAlertProperty[] properties) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Cache.AlertQuery.GetPartialMonitoringAlertReader(ManagementGroup managementGroup, MonitoringClass type, MonitoringAlertCriteria criteria, Nullable`1 lastModified, MonitoringAlertProperty[] fields) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Cache.AlertQuery.DoQuery(String criteria, Nullable`1 lastModified) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Cache.Query`1.DoUpdateQuery(IndexTable indexTable, String criteria, DateTime& timeLastUpdated) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Cache.Query`1.InternalSyncQuery(CacheSession session, IndexTable indexTable, UpdateReason reason, UpdateType updateType) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Cache.Query`1.InternalQuery(CacheSession session, UpdateReason reason) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Cache.Query`1.TryDoQuery(UpdateReason reason, CacheSession session) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Cache.Query`1.DoQueryJob(Object sender, ConsoleJobEventArgs args) at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ConsoleJobExceptionHandler.ExecuteJob(IComponent component, EventHandler`1 job, Object sender, ConsoleJobEventArgs args) System.ServiceModel.CommunicationObjectFaultedException: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state. Server stack trace: at System.ServiceModel.Channels.CommunicationObject.ThrowIfFaulted() at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.EnterpriseManagement.Common.IInstanceSpaceDataAccess.SetupAlertsByCriteriaAndMonitoringClassReaderWithProperties(String criteria, Guid monitoringClassId, Boolean recurse, String languageCode, Nullable`1 lastModified, Byte[] alertProperties) at Microsoft.EnterpriseManagement.DataAbstractionLayer.InstanceSpaceOperations.SetupAlertsByCriteriaAndMonitoringClassReaderWithProperties(MonitoringAlertCriteria criteria, Guid monitoringClassId, TraversalDepth traversalDepth, String languageCode, Nullable`1 lastModified, MonitoringAlertProperty[] properties) Sys Admin - MCSE
November 11th, 2010 3:24pm

Hi, >Message: Invalid object name 'dbo.fn_AlertViewChangesNoContext'. Are you applied sql scripts from Cumulative Update 3? It looks like you're don't. http://OpsMgr.ru/
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 12:30am

Hi, >Message: Invalid object name 'dbo.fn_AlertViewChangesNoContext'. Are you applied sql scripts from Cumulative Update 3? It looks like you're don't. http://OpsMgr.ru/
November 12th, 2010 12:30am

Thank you, I guess i missed that step of running the scripts, since in most Microsoft products the scripts are embedded in the update installer. In case someone else has this issue be sure to follow the entire set of instructions at http://support.microsoft.com/kb/2251525Sys Admin - MCSE
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2010 6:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics