Has anyone ever seen this error "Invalid object nanme "ScaleGroupDeployment"

Question

We get this error when starting Dynamics CRM 4.0 . We don't know what may have caused it. 

Server Error in '/' Application.

---

Invalid object name 'ScaleGroupDeployment'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'ScaleGroupDeployment'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Invalid object name 'ScaleGroupDeployment'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2811 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +87 System.Data.SqlClient.SqlDataReader.get_MetaData() +112 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +2476580 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +2478113 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +211 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +21 Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command) +373 Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate) +72 Microsoft.Crm.SharedDatabase.DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns) +573 Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions) +431 Microsoft.Crm.ServerLocatorService.GetScaleGroupDeploymentIdFromDatabase(Guid scaleGroupId) +385 Microsoft.Crm.ServerLocatorService.GetDeploymentIdFromDatabase() +233 Microsoft.Crm.ServerLocatorService.GetDeploymentId() +194 Microsoft.Crm.ServerLocatorService.GetDeploymentSetting(String settingName) +74 Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender, EventArgs e) +1150 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171

Answer 1

Hi,

i never seen this error message bevor. What you have done on the server or the crm?

 

---

Viele Grüße

Michael Sulz
MVP für Microsoft Dynamics CRM

Answer 2

It's hard to say there are multiple developers on the system.   plug-in registration would have been one of the things that was done.

Right now cant start CRM

Async doesn't load

Here is more information from the trace log.

The exception information is:
System.InvalidOperationException: Cannot open log for source 'ConfigDB'. You may not have write access. ---> System.ComponentModel.Win32Exception: Access is denied
   --- End of inner exception stack trace ---
   at System.Diagnostics.EventLog.OpenForWrite(String currentMachineName)
   at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
   at System.Diagnostics.EventLog.WriteEvent(EventInstance instance, Byte[] data, Object[] values)
   at Microsoft.Crm.CrmEventLog.WriteEntry(EventLogEntryType eventType, Int64 eventId, Boolean traceFailure, Object[] values)
[2010-03-31 07:10:24.6] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    1 |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Error | DatabaseService.Retrieve
>Exception when executing query: SELECT Id, DeploymentId FROM ScaleGroupDeployment  WHERE (((ScaleGroupId = '00000000-0000-0000-0000-000000000000')) ) AND (IsDeleted = 0) Exception: System.Data.SqlClient.SqlException: Invalid object name 'ScaleGroupDeployment'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 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.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
   at Microsoft.Crm.SharedDatabase.DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
[2010-03-31 07:10:24.6] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    1 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | DatabaseService.LogSqlError
 at DatabaseService.LogSqlError(String error)
 at DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
 at DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
 at ServerLocatorService.GetScaleGroupDeploymentIdFromDatabase(Guid scaleGroupId)
 at ServerLocatorService.GetDeploymentIdFromDatabase()
 at ServerLocatorService.GetDeploymentId()
 at ServerLocatorService.GetDeploymentSetting(String settingName)
 at AuthenticationEngine.Execute(Object sender, EventArgs e)
 at SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
 at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
 at ApplicationStepManager.ResumeSteps(Exception error)
 at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
 at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
 at HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
 at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
>Failed to write the following event message to the Event Log.
EventType:Error
EventId=3221243904
Contents:System.Data.SqlClient.SqlException: Invalid object name 'ScaleGroupDeployment'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 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.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
   at Microsoft.Crm.SharedDatabase.DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
The exception information is:
System.InvalidOperationException: Cannot open log for source 'ConfigDB'. You may not have write access. ---> System.ComponentModel.Win32Exception: Access is denied
   --- End of inner exception stack trace ---
   at System.Diagnostics.EventLog.OpenForWrite(String currentMachineName)
   at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
   at System.Diagnostics.EventLog.WriteEvent(EventInstance instance, Byte[] data, Object[] values)
   at Microsoft.Crm.CrmEventLog.WriteEntry(EventLogEntryType eventType, Int64 eventId, Boolean traceFailure, Object[] values)
[2010-03-31 07:10:24.6] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError
>MSCRM Error Report:
--------------------------------------------------------------------------------------------------------
Error: Invalid object name 'ScaleGroupDeployment'.

Error Message: Invalid object name 'ScaleGroupDeployment'.

Source File: Not available

Line Number: Not available

Request URL: https://snap1.enotarytrust.com/default.aspx

Stack Trace Info: [SqlException: Invalid object name 'ScaleGroupDeployment'.]
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, 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.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
   at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
   at Microsoft.Crm.SharedDatabase.DatabaseService.ExecuteBaseReader(CrmDbConnection connection, IDbCommand command, String[] columns)
   at Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
   at Microsoft.Crm.ServerLocatorService.GetScaleGroupDeploymentIdFromDatabase(Guid scaleGroupId)
   at Microsoft.Crm.ServerLocatorService.GetDeploymentIdFromDatabase()
   at Microsoft.Crm.ServerLocatorService.GetDeploymentId()
   at Microsoft.Crm.ServerLocatorService.GetDeploymentSetting(String settingName)
   at Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender, EventArgs e)
   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

[2010-03-31 07:10:24.7] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:    1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | MainApplication.Application_Error
>Application is not initialized and an error has occurred

Answer 3

Have you tried to restart your SQL Services and then restart the async crm service? This looks like a problem with your security settings/mappings within sql server. 

---

Gruß Carsten Groth http://carstengroth.spaces.live.com

Answer 4

another try is to enable the tracing for the crm and analyse the trace files.

---

Viele Grüße

Michael Sulz
MVP für Microsoft Dynamics CRM