By the way – for those affected by this and still stuck on OpsMgr SP1 – this issue is exacerbated by letting your management group alerts run wild.  We generally see this in the worst run environments – when the alert count is extremely high.  It is generally in management groups where really old alerts are not closed out on a regular basis, alert repeat counts are really high, and alert retention is left at the default of 7 days.

You can really help with this issue by setting your console to “show all data” – then closing out the alerts with the super high repeat counts, closing out old alerts, tuning the alert generating rules, removing unused or unturned management packs, etc….   in addition to getting the private hotfix for the issue.

 you should open a case with PSS on this specific console crash/exception.  There is a private hotfix that addresses this issue you can request.  Much of this issue was fixed in R2.

I am running with SCOMSP1. Kindly advice me…

I am getting the following error every 10-15 min.  OpsMgr SDK Service stopping every 15 min.

Event Type:        Error

Event Source:    OpsMgr SDK Service

Event Category:                None

Event ID:              26319

Date:                     22/10/2009

Time:                     12:11:19

User:                     N/A

Computer:          xxxxxxxx

Description:

An exception was thrown while processing GetObjectsFromReader for session id uuid:614a5b9c-684a-4635-8879-7467cedde04e;id=2292.

 Exception Message: ExecuteScalar requires an open and available Connection. The connection's current state is closed.

 Full Exception:

Microsoft.EnterpriseManagement.Common.InvalidConnectionException: ExecuteScalar requires an open and available Connection. The connection's current state is closed. ---> System.InvalidOperationException: ExecuteScalar requires an open and available Connection. The connection's current state is closed.

   at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)

   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)

   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteScalar()

   at Microsoft.EnterpriseManagement.Mom.DataAccess.SqlRetryHandler.Execute[T](ExecuteArguments executeArguments, RetryPolicy retryPolicy, GenericExecute`1 genericExecute)

   --- End of inner exception stack trace ---

   at Microsoft.EnterpriseManagement.Mom.DataAccess.SqlRetryHandler.Execute[T](ExecuteArguments executeArguments, RetryPolicy retryPolicy, GenericExecute`1 genericExecute)

   at Microsoft.EnterpriseManagement.Mom.DataAccess.SqlRetryHandler.ExecuteReaderSingleRow(SqlDataReader sqlDataReader, SqlConnection sqlConnection, IList`1 prologEpilogList, RetryPolicy retryPolicy)

   at Microsoft.EnterpriseManagement.Mom.DataAccess.QueryResultsReader.Read()

   at Microsoft.EnterpriseManagement.Mom.ServiceDataLayer.ClientReaderManager.GetObjects(Guid id, Int32 count)

   at Microsoft.EnterpriseManagement.Mom.ServiceDataLayer.SdkDataAccess.GetObjectsFromReader(Guid readerId, Int32 count)

   at Microsoft.EnterpriseManagement.Mom.ServiceDataLayer.SdkDataAccessTieringWrapper.GetObjectsFromReader(Guid readerId, Int32 count)

   at Microsoft.EnterpriseManagement.Mom.ServiceDataLayer.SdkDataAccessExceptionTracingWrapper.GetObjectsFromReader(Guid readerId, Int32 count)

Any body faced this issue before….please advice me….

Many Thanks,

Narendra

DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/