alert notification subscriptions encountered an error while attempting to run.
Hi All ,
Yesterday we had a patch management after that we are getting this following error. can anyone help me on this .
alert notification subscriptions encountered an error while attempting to run.
Context:
Date and Time: 12/18/2010 8:03:13 PM
Log Name: Operations Manager
Source: Health Service Modules
Event Number: 11402
Level: 1
Logging Computer: XYZZZ
User: N/A
Description:
Alert subscription data source module was unable to find alerts that match the subscription because of database errors. The following error(s) were encountered: Exception Message: SHUTDOWN is in progress. Login failed for user ' xxxx\yyyyy'. A severe error
occurred on the current command. The results, if any, should be discarded. One or more workflows were affected by this. Workflow name: ProductConnectorSubscriptiona6fcd139_5374_4fb7_9421_790236b107d0 Instance name: zzzzzz.xxxx.com
Instance ID: {C9B12C90-B7B1-0283-73FC-6097686B5088} Management group: Atl
Event Data:
December 20th, 2010 7:30am
Hi,
This alert was caused by the SQL server shutting down whilst OpsMgr was using it - possibly caused by the patching process. I would close the alert and only start to worry if it re-occurs.
Matt.Matt White
( http://systemcenterblog.hardac.co.uk/ )
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2010 8:50am
Hi,
Additionally, on the server, please also ensure the following related services are running and try restarting them:
System Center Data Access service
System Center Management service
System Center Management Configuration service
If the issue persists, please check the Event Log and let us know the details if there is any related errors.
Hope this helps.
Regards,
LeonLeon Liu - Technical Lead
December 22nd, 2010 2:26am