Hi

We are currently running CRM Dynamics 2011 roll up 8 and we have noticed the following errors on our application server which hosts the async and sandbox services. Users are reporting spurious errors when doing anything in CRM. "Unexpected Error" "SQL Server Timeout" "Business Process Error"

Error1:

The Web Service plug-in failed in OrganizationId: 07ae1f6f-237f-e111-83c6-005056b41d30; SdkMessageProcessingStepId: 1e4ce25a-3a37-4db1-a25e-6abfacdd57c5; EntityName: queueitem; Stage: 30; MessageName: AddToQueue; AssemblyName: Microsoft.Crm.Extensibility.InternalOperationPlugin, Microsoft.Crm.ObjectModel, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35; ClassName: Microsoft.Crm.Extensibility.InternalOperationPlugin; Exception: Unhandled Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.

   at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)

   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)

   at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IServiceProvider serviceProvider)

   at Microsoft.Crm.Extensibility.V5PluginProxyStep.ExecuteInternal(PipelineExecutionContext context)

   at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)

Inner Exception: System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.

   at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)

   at System.Data.SqlClient.SqlInternalTransaction.Rollback()

   at System.Data.SqlClient.SqlInternalTransaction.Dispose(Boolean disposing)

   at System.Data.SqlClient.SqlTransaction.Dispose(Boolean disposing)

   at Microsoft.Crm.CrmTransaction.RollbackTransaction(Boolean raiseException)

   at Microsoft.Crm.Extensibility.MessageProcessor.Execute(PipelineExecutionContext context)

   at Microsoft.Crm.Extensibility.InternalMessageDispatcher.Execute(PipelineExecutionContext context)

   at Microsoft.Crm.Extensibility.ExtensiblePlatformMessageDispatcher.Execute(PipelineExecutionContext pluginContext)

   at Microsoft.Crm.Extensibility.ExtensiblePlatformMessageDispatcher.CreateWithInvocationSource(BusinessEntity entity, Int32 invocationSource, ExecutionContext context)

   at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Create(IBusinessEntity entity, ExecutionContext context)

   at Microsoft.Crm.ObjectModel.QueueItemService.CreateInternal(IBusinessEntity queueItem, BusinessEntityMoniker queuedObjectMoniker, BusinessEntity queuedObject, ExecutionContext context)

   at Microsoft.Crm.ObjectModel.QueueItemService.CreateQueueItemForObject(BusinessEntityMoniker objectMoniker, Guid targetQueueId, BusinessEntity queueItem, BusinessEntity queuedObject, ExecutionContext context)

   at Microsoft.Crm.ObjectModel.QueueItemService.AddToQueueInternal(BusinessEntity existingQueueItem, BusinessEntityMoniker objectMoniker, Guid targetQueueId, IBusinessEntity queueItemProperties, BusinessEntity queuedEntity, ExecutionContext context)

   at Microsoft.Crm.ObjectModel.QueueItemService.AddToQueue(BusinessEntityMoniker objectMoniker, Guid sourceQueueId, Guid targetQueueId, IBusinessEntity queueItemProperties, ExecutionContext context)

Error2:

Host server.MSCRMAsyncService$maintenance.4b6a284f-76e5-4396-85f0-d6f8afe8630e: a config database error occured. Exception: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)

   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)

   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)

   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.SqlClient.SqlConnection.Open()

   at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()

   at Microsoft.Crm.CrmDbConnection.Open()

   at Microsoft.Crm.Asynchronous.JobDataAccess.ExecuteSqlOrganizationScopeAndProcessRecords(IDbCommand command, Guid organizationId, RecordProcessor recordProcessor)

   at Microsoft.Crm.Asynchronous.JobDataAccess.RetrieveSqlServerName(Guid orgId)

   at Microsoft.Crm.Asynchronous.JobDataAccess.UpdateJobTargetServer(AsyncJob job)

   at Microsoft.Crm.Asynchronous.JobDataAccess.GetNextJob(IList`1 orgsAvailableForMaintenance, DateTime startCycleTime, Int32 maxJobsToReturn)

Error3:

Sandbox SDK Listener - Access Denied.

Caller Information (Client/Host/Worker/Account): server; CrmAsyncService.exe (11632); 362FC37C/server; Microsoft.Crm.Sandbox.HostService.exe (2492); A3005D31/server; Microsoft.Crm.Sandbox.WorkerProcess.exe (2788); CDAC0F0B/-

Expected Account:-

Error4:

The Sandbox Host service has terminated a Sandbox Worker process.

Source: Microsoft.Crm.Sandbox.HostService.exe (2492)

Worker: {cdba7ed7-2eb1-46c7-a808-bde1e24cf52b}:8552

Reason: TerminateOther