Dynamics CRM Support Blog
Problems configuring the CRM Outlook client? Use the wizard!
CRM Resource Center
FAQ About Technical SupportOnline | On-Premise
FAQ About Billing
Implementation Guide
Microsoft Dynamics CRM Developer Center and SDK
I am trying to create a few entities in Dynamics CRM 4.0. When I hit save, a message box comes up stating "An Error Has Occurred." I have all the proper permissions in the database to do whatever I want within CRM and I also have the System Admin and System Customizer roles assigned to me. I'm not sure why I keep receiving this error.
Can anyone point me in the right direction to get this fixed please?
Thanks,
Dave
Also since I'm sure it will help, here is the text from the Trace Log.
# CRM Tracing Version 2.0 # LocalTime: 2011-12-02 02:06:48.5 # Categories: # CallStackOn: No # ComputerName: CRM200 # CRMVersion: 4.0.7333.2542 # DeploymentType: OnPremise # ScaleGroup: # ServerRole: AppServer, AsyncService, DiscoveryService, WebService, ApiServer, HelpServer, DeploymentService
[2011-12-02 02:06:48.5] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 6(MSCRM:-NotificationManager.NotificationWatcherThreadProc) |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | NotificationManager.NotificationWatcherThreadProc at NotificationManager.NotificationWatcherThreadProc() at ThreadHelper.ThreadStart_Context(Object state) at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at ThreadHelper.ThreadStart() >ThreadAbort Exception in NotificationWatcherThreadProc Thread was being aborted. [2011-12-02 02:06:48.5] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 6(MSCRM:-NotificationManager.NotificationWatcherThreadProc) |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ThreadHelper.ThreadStart_Context >NotificationWatcherThreadProc Stopped. # CRM Tracing Version 2.0 # LocalTime: 2011-12-02 13:13:31.3 # Categories: # CallStackOn: No # ComputerName: CRM200 # CRMVersion: 4.0.7333.2542 # DeploymentType: OnPremise # ScaleGroup: # ServerRole: AppServer, AsyncService, DiscoveryService, WebService, ApiServer, HelpServer, DeploymentService
[2011-12-02 13:13:31.3] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 1 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | CrmException..ctor at CrmException..ctor(String message, Int32 errorCode) at CrmObjectNotFoundException..ctor(BusinessEntityMoniker moniker) at BusinessProcessObject.DoRetrievePublishableSingle(BusinessEntityMoniker moniker, EntityExpression entityExpression, Boolean includeUnpublished, ExecutionContext context) at BusinessProcessObject.RetrieveUnpublished(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context) at OrganizationUIService.RetrieveUnpublished(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context) at OrganizationUIService.RetrieveOldFormXml(BusinessEntityMoniker moniker, ExecutionContext context) at OrganizationUIService.ExtractAndSaveFormLabels(IBusinessEntity entity, ExecutionContext context) at OrganizationUIService.Create(IBusinessEntity entity, ExecutionContext context) at OrganizationUIHelper.CreateHelper(EntityCreateInfo entityCreateInfo, ExecutionContext context) at EntityService.CreateUIData(EntityCreateInfo entityInfo, ExecutionContext context, MetadataHelper metadataHelper, MetadataBusinessEntityMoniker[]& labelMonikers) at EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) at EntityService.Create(EntityCreateInfo entityInfo) at EntityCreate.Execute(IUser user, ParameterBag paramBag) at SystemCustomization.CreateEntity(XmlNode data) at RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at LogicalMethodInfo.Invoke(Object target, Object[] values) at WebServiceHandler.Invoke() at WebServiceHandler.CoreProcessRequest() at SyncSessionlessHandler.ProcessRequest(HttpContext context) at CallHandlerExecutionStep.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) >Crm Exception: Message: organizationui With Id = cd3f6299-544c-4b14-b403-13de4b142849 Does Not Exist, ErrorCode: -2147220969 # CRM Tracing Version 2.0 # LocalTime: 2011-12-02 13:13:33.5 # Categories: # CallStackOn: No # ComputerName: CRM200 # CRMVersion: 4.0.7333.2542 # DeploymentType: OnPremise # ScaleGroup: # ServerRole: AppServer, AsyncService, DiscoveryService, WebService, ApiServer, HelpServer, DeploymentService
[2011-12-02 13:13:33.5] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | SqlHelper.ExecuteNonQuery >Exception when executing non-query: CREATE TABLE dbo.New_accountsiteBase (New_accountsiteId uniqueidentifier NOT NULL , CreatedOn datetime NULL , CreatedBy uniqueidentifier NULL , ModifiedOn datetime NULL , ModifiedBy uniqueidentifier NULL , OwningUser uniqueidentifier NULL , OwningBusinessUnit uniqueidentifier NULL , statecode int NOT NULL , statuscode int NULL , DeletionStateCode int NULL , VersionNumber timestamp NULL , ImportSequenceNumber int NULL , OverriddenCreatedOn datetime NULL , TimeZoneRuleVersionNumber int NULL , UTCConversionTimeZoneCode int NULL , CONSTRAINT PK_New_accountsiteBase PRIMARY KEY CLUSTERED (New_accountsiteId) ) Exception: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) [2011-12-02 13:13:33.5] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | EntityService.Create >EntityService.Create caught exception: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, String sqlCommand) at Microsoft.Crm.Metadata.EntityCreateAction.DatabaseOperation() at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue() at Microsoft.Crm.Metadata.EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at Microsoft.Crm.Metadata.EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) [2011-12-02 13:13:34.2] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError >MSCRM Error Report: -------------------------------------------------------------------------------------------------------- Error: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'.
Error Message: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'.
Source File: Not available
Line Number: Not available
Request URL: http://crm200/PMSIbackup100/AppWebServices/SystemCustomization.asmx
Stack Trace Info: [SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'.] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, String sqlCommand) at Microsoft.Crm.Metadata.EntityCreateAction.DatabaseOperation() at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue() at Microsoft.Crm.Metadata.EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at Microsoft.Crm.Metadata.EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) at Microsoft.Crm.Metadata.EntityService.Create(EntityCreateInfo entityInfo) at Microsoft.Crm.Application.WebServices.SystemCustomization.EntityCreate.Execute(IUser user, ParameterBag paramBag) at Microsoft.Crm.Application.WebServices.SystemCustomization.SystemCustomization.CreateEntity(XmlNode data)
[2011-12-02 13:26:07.5] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 1 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | CrmException..ctor at CrmException..ctor(String message, Int32 errorCode) at CrmObjectNotFoundException..ctor(BusinessEntityMoniker moniker) at BusinessProcessObject.DoRetrievePublishableSingle(BusinessEntityMoniker moniker, EntityExpression entityExpression, Boolean includeUnpublished, ExecutionContext context) at BusinessProcessObject.RetrieveUnpublished(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context) at OrganizationUIService.RetrieveUnpublished(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context) at OrganizationUIService.RetrieveOldFormXml(BusinessEntityMoniker moniker, ExecutionContext context) at OrganizationUIService.ExtractAndSaveFormLabels(IBusinessEntity entity, ExecutionContext context) at OrganizationUIService.Create(IBusinessEntity entity, ExecutionContext context) at OrganizationUIHelper.CreateHelper(EntityCreateInfo entityCreateInfo, ExecutionContext context) at EntityService.CreateUIData(EntityCreateInfo entityInfo, ExecutionContext context, MetadataHelper metadataHelper, MetadataBusinessEntityMoniker[]& labelMonikers) at EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) at EntityService.Create(EntityCreateInfo entityInfo) at EntityCreate.Execute(IUser user, ParameterBag paramBag) at SystemCustomization.CreateEntity(XmlNode data) at RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at LogicalMethodInfo.Invoke(Object target, Object[] values) at WebServiceHandler.Invoke() at WebServiceHandler.CoreProcessRequest() at SyncSessionlessHandler.ProcessRequest(HttpContext context) at CallHandlerExecutionStep.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) >Crm Exception: Message: organizationui With Id = 03b563fc-90b3-4d55-ba17-5949611d00f8 Does Not Exist, ErrorCode: -2147220969 [2011-12-02 13:26:09.1] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | SqlHelper.ExecuteNonQuery >Exception when executing non-query: CREATE TABLE dbo.New_accountsiteBase (New_accountsiteId uniqueidentifier NOT NULL , CreatedOn datetime NULL , CreatedBy uniqueidentifier NULL , ModifiedOn datetime NULL , ModifiedBy uniqueidentifier NULL , OwningUser uniqueidentifier NULL , OwningBusinessUnit uniqueidentifier NULL , statecode int NOT NULL , statuscode int NULL , DeletionStateCode int NULL , VersionNumber timestamp NULL , ImportSequenceNumber int NULL , OverriddenCreatedOn datetime NULL , TimeZoneRuleVersionNumber int NULL , UTCConversionTimeZoneCode int NULL , CONSTRAINT PK_New_accountsiteBase PRIMARY KEY CLUSTERED (New_accountsiteId) ) Exception: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) [2011-12-02 13:26:09.1] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | EntityService.Create >EntityService.Create caught exception: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, String sqlCommand) at Microsoft.Crm.Metadata.EntityCreateAction.DatabaseOperation() at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue() at Microsoft.Crm.Metadata.EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at Microsoft.Crm.Metadata.EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) [2011-12-02 13:26:09.5] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError >MSCRM Error Report: -------------------------------------------------------------------------------------------------------- Error: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'.
[2011-12-02 13:26:54.2] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 1 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | CrmException..ctor at CrmException..ctor(String message, Int32 errorCode) at CrmObjectNotFoundException..ctor(BusinessEntityMoniker moniker) at BusinessProcessObject.DoRetrievePublishableSingle(BusinessEntityMoniker moniker, EntityExpression entityExpression, Boolean includeUnpublished, ExecutionContext context) at BusinessProcessObject.RetrieveUnpublished(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context) at OrganizationUIService.RetrieveUnpublished(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context) at OrganizationUIService.RetrieveOldFormXml(BusinessEntityMoniker moniker, ExecutionContext context) at OrganizationUIService.ExtractAndSaveFormLabels(IBusinessEntity entity, ExecutionContext context) at OrganizationUIService.Create(IBusinessEntity entity, ExecutionContext context) at OrganizationUIHelper.CreateHelper(EntityCreateInfo entityCreateInfo, ExecutionContext context) at EntityService.CreateUIData(EntityCreateInfo entityInfo, ExecutionContext context, MetadataHelper metadataHelper, MetadataBusinessEntityMoniker[]& labelMonikers) at EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) at EntityService.Create(EntityCreateInfo entityInfo) at EntityCreate.Execute(IUser user, ParameterBag paramBag) at SystemCustomization.CreateEntity(XmlNode data) at RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at LogicalMethodInfo.Invoke(Object target, Object[] values) at WebServiceHandler.Invoke() at WebServiceHandler.CoreProcessRequest() at SyncSessionlessHandler.ProcessRequest(HttpContext context) at CallHandlerExecutionStep.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) >Crm Exception: Message: organizationui With Id = 6c8fa28c-3c6e-46df-b49f-c819d96d69ad Does Not Exist, ErrorCode: -2147220969 [2011-12-02 13:26:55.0] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | SqlHelper.ExecuteNonQuery >Exception when executing non-query: CREATE TABLE dbo.New_accountsiteBase (New_accountsiteId uniqueidentifier NOT NULL , CreatedOn datetime NULL , CreatedBy uniqueidentifier NULL , ModifiedOn datetime NULL , ModifiedBy uniqueidentifier NULL , OwningUser uniqueidentifier NULL , OwningBusinessUnit uniqueidentifier NULL , statecode int NOT NULL , statuscode int NULL , DeletionStateCode int NULL , VersionNumber timestamp NULL , ImportSequenceNumber int NULL , OverriddenCreatedOn datetime NULL , TimeZoneRuleVersionNumber int NULL , UTCConversionTimeZoneCode int NULL , CONSTRAINT PK_New_accountsiteBase PRIMARY KEY CLUSTERED (New_accountsiteId) ) Exception: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) [2011-12-02 13:26:55.0] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | EntityService.Create >EntityService.Create caught exception: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, String sqlCommand) at Microsoft.Crm.Metadata.EntityCreateAction.DatabaseOperation() at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue() at Microsoft.Crm.Metadata.EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at Microsoft.Crm.Metadata.EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) [2011-12-02 13:26:55.4] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError >MSCRM Error Report: -------------------------------------------------------------------------------------------------------- Error: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'.
[2011-12-02 13:28:29.7] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 1 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | CrmException..ctor at CrmException..ctor(String message, Int32 errorCode) at CrmObjectNotFoundException..ctor(BusinessEntityMoniker moniker) at BusinessProcessObject.DoRetrievePublishableSingle(BusinessEntityMoniker moniker, EntityExpression entityExpression, Boolean includeUnpublished, ExecutionContext context) at BusinessProcessObject.RetrieveUnpublished(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context) at OrganizationUIService.RetrieveUnpublished(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context) at OrganizationUIService.RetrieveOldFormXml(BusinessEntityMoniker moniker, ExecutionContext context) at OrganizationUIService.ExtractAndSaveFormLabels(IBusinessEntity entity, ExecutionContext context) at OrganizationUIService.Create(IBusinessEntity entity, ExecutionContext context) at OrganizationUIHelper.CreateHelper(EntityCreateInfo entityCreateInfo, ExecutionContext context) at EntityService.CreateUIData(EntityCreateInfo entityInfo, ExecutionContext context, MetadataHelper metadataHelper, MetadataBusinessEntityMoniker[]& labelMonikers) at EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) at EntityService.Create(EntityCreateInfo entityInfo) at EntityCreate.Execute(IUser user, ParameterBag paramBag) at SystemCustomization.CreateEntity(XmlNode data) at RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at LogicalMethodInfo.Invoke(Object target, Object[] values) at WebServiceHandler.Invoke() at WebServiceHandler.CoreProcessRequest() at SyncSessionlessHandler.ProcessRequest(HttpContext context) at CallHandlerExecutionStep.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) >Crm Exception: Message: organizationui With Id = cda49435-96d2-4255-b934-9b827464fcd4 Does Not Exist, ErrorCode: -2147220969 [2011-12-02 13:28:30.8] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | SqlHelper.ExecuteNonQuery >Exception when executing non-query: CREATE TABLE dbo.New_accountsiteBase (New_accountsiteId uniqueidentifier NOT NULL , CreatedOn datetime NULL , CreatedBy uniqueidentifier NULL , ModifiedOn datetime NULL , ModifiedBy uniqueidentifier NULL , OwningUser uniqueidentifier NULL , OwningBusinessUnit uniqueidentifier NULL , statecode int NOT NULL , statuscode int NULL , DeletionStateCode int NULL , VersionNumber timestamp NULL , ImportSequenceNumber int NULL , OverriddenCreatedOn datetime NULL , TimeZoneRuleVersionNumber int NULL , UTCConversionTimeZoneCode int NULL , CONSTRAINT PK_New_accountsiteBase PRIMARY KEY CLUSTERED (New_accountsiteId) ) Exception: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) [2011-12-02 13:28:30.8] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Platform.Metadata |User: 00000000-0000-0000-0000-000000000000 |Level: Error | EntityService.Create >EntityService.Create caught exception: System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, IDbCommand sqlCommand) at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, String sqlCommand) at Microsoft.Crm.Metadata.EntityCreateAction.DatabaseOperation() at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue() at Microsoft.Crm.Metadata.EntityService.CreateInternal(EntityCreateInfo entityInfo, ExecutionContext context) at Microsoft.Crm.Metadata.EntityService.Create(EntityCreateInfo entityInfo, ExecutionContext context) [2011-12-02 13:28:31.1] Process: w3wp |Organization:7f1774f6-a88f-df11-8497-00505687083d |Thread: 1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError >MSCRM Error Report: -------------------------------------------------------------------------------------------------------- Error: CREATE TABLE permission denied in database 'PMSICRM_MSCRM'.
same problem here,
ANY help would be appreciated
Hi DS,
The Error message is clearly saying that CRETE permission is denied on table. It's not necessory that if you are the system admin you should not get this error message. Please check the permission of the Other CRM Group in SQL and make sure there is no explicit denied permission on these CRM groups and there is no SQL trigger on any CRM database table.
Mohammad