Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Project for the Web: U...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Project for the Web: Unable to assign anyone - Generic SQL error

(0) ShareShare
ReportReport
Posted on by eminkoff 5

Good day, everyone.

I had been working on customizing Project for the Web app and it seems broke something.. as I'm unable to assign people to tasks any longer.

When I try to do so app throws error that it's unable to save changes. 

I went to PSS Error Log and found this error but it didn't help much to narrow it down:

Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 500

Ofc that had to happen day before presenting the app },"_callStack":null,"_responseText":"{\"error\":{\"code\":\"0x80044150\",\"message\":\" Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 500\",\"@Microsoft.PowerApps.CDS.HelpLink\":\"http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException:80044150&client=platform\",\"@Microsoft.PowerApps.CDS.TraceText\":\"[Microsoft.Dynamics.ProjectServiceCore.Plugins: Microsoft.Dynamics.ProjectServiceCore.Plugins.PostOperationbookableresourcebookingUpdate]\\r\\n[525b9b24-39ac-403b-aba2-5a22996b8ed1: Project Service Core - Update of bookableresourcebooking]\\r\\nFpsPlugin: PluginLocal.Create, Depth: 1\\r\\nFpsPlugin: PluginLocal.Create, Depth: 1\\r\\nFpsPlugin: PluginContext Start\\r\\nFpsPlugin: MessageName: Update\\r\\nFpsPlugin: PrimaryEntityName: bookableresourcebooking\\r\\nFpsPlugin: SecondaryEntityName: none\\r\\nFpsPlugin: Stage: 20\\r\\nFpsPlugin: PreEntityImages.Count: 0\\r\\nFpsPlugin: PostEntityImages.Count: 0\\r\\nFpsPlugin: UserId: d0af2219-40a3-4559-9f88-1028a11c3635\\r\\nFpsPlugin: InitiatingUserID: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\\r\\nFpsPlugin: IsolationMode: 1\\r\\nFpsPlugin: Mode: 0\\r\\nFpsPlugin: OrganizationName: unq83fed86a82054d9c8f0ce94fdb724\\r\\nFpsPlugin: OrganizationId: 83fed86a-8205-4d9c-8f0c-e94fdb72445b\\r\\nFpsPlugin: BusinessUnitId: 121fcffe-4e70-ec11-8941-000d3a59ef81\\r\\nFpsPlugin: CorrelationId: cd61352f-8ecf-4295-bdc6-662bf2a70bfb\\r\\nFpsPlugin: RequestId: 710ae855-33e4-4299-b93d-a7d90d803a38\\r\\nFpsPlugin: OperationId: 710ae855-33e4-4299-b93d-a7d90d803a38\\r\\nFpsPlugin: IsInTransaction: True\\r\\nFpsPlugin: Depth: 1\\r\\nFpsPlugin: IsExecutingOffline: False\\r\\nFpsPlugin: Parent PluginContext Start\\r\\nFpsPlugin: \\t\\tPluginContext Start\\r\\nFpsPlugin: \\t\\tMessageName: Delete\\r\\nFpsPlugin: \\t\\tPrimaryEntityName: msdyn_resourcerequirement\\r\\nFpsPlugin: \\t\\tPrimaryEntityId: e4301b25-eeb9-ed11-83ff-6045bd006ff2\\r\\nFpsPlugin: \\t\\tSecondaryEntityName: none\\r\\nFpsPlugin: \\t\\tStage: 30\\r\\nFpsPlugin: \\t\\tPreEntityImages.Count: 0\\r\\nFpsPlugin: \\t\\tPostEntityImages.Count: 0\\r\\nFpsPlugin: \\t\\tUserId: d0af2219-40a3-4559-9f88-1028a11c3635\\r\\nFpsPlugin: \\t\\tInitiatingUserID: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\\r\\nFpsPlugin: \\t\\tIsolationMode: 1\\r\\nFpsPlugin: \\t\\tMode: 0\\r\\nFpsPlugin: \\t\\tOrganizationName: unq83fed86a82054d9c8f0ce94fdb724\\r\\nFpsPlugin: \\t\\tOrganizationId: 83fed86a-8205-4d9c-8f0c-e94fdb72445b\\r\\nFpsPlugin: \\t\\tBusinessUnitId: 121fcffe-4e70-ec11-8941-000d3a59ef81\\r\\nFpsPlugin: \\t\\tCorrelationId: cd61352f-8ecf-4295-bdc6-662bf2a70bfb\\r\\nFpsPlugin: \\t\\tRequestId: 710ae855-33e4-4299-b93d-a7d90d803a38\\r\\nFpsPlugin: \\t\\tOperationId: 710ae855-33e4-4299-b93d-a7d90d803a38\\r\\nFpsPlugin: \\t\\tIsInTransaction: True\\r\\nFpsPlugin: \\t\\tDepth: 1\\r\\nFpsPlugin: \\t\\tIsExecutingOffline: False\\r\\nFpsPlugin: \\t\\tPluginContext End\\r\\nFpsPlugin: Parent PluginContext End\\r\\nFpsPlugin: PluginContext End\\r\\nFpsPlugin: PluginLocal.Create, Depth: 1\\r\\nFpsPlugin: PluginLocal.Create, Depth: 1\\r\\nFpsPlugin: InitializePlugin: local\\r\\nFpsPlugin: ConfigurePluginFlagsSupportInternal()\\r\\nFpsPlugin: CreateEntityOperation(bookableresourcebooking)\\r\\nFpsPlugin: Operation type: BookableResourceBookingOperation\\r\\nFpsPlugin: operation.Initialize()\\r\\nFpsPlugin: operation.Execute()\\r\\nFpsPlugin: PluginStage: 20 MessageName: Update\\r\\nFpsPlugin: Before calling message handler\\r\\nFpsPlugin: Before\\r\\nFpsPlugin: BeforeUpdate\\r\\nFpsPlugin: BeforeCreateOrUpdate\\r\\nFpsPlugin: BookingSetupMetadata: Cache miss for 3 BookingSetupMetadataDB records\\r\\nFpsPlugin: PipelineLocal.Value: Retrieving local\\r\\nFpsPlugin: PipelineLocal.Value: Retrieving soft\\r\\nFpsPlugin: PipelineLocal.Value: Retrieving hard\\r\\nFpsPlugin: Settings: Retrieving local\\r\\nFpsPlugin: Settings: Retrieving hard\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: REQUEST Timestamp: 6356733!03/21/2023 17:48:09, Metadata: \\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: RESPONSE Timestamp: 6356733!03/21/2023 17:48:09, Metadata: \\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET Expired: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\\r\\nFpsPlugin: After calling message handler\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 1\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 1\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 1\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 1\\r\\nEntered ScheduleCommon.Plugins.PreOperationBookableResourceBookingUpdate.Execute(), Correlation Id: cd61352f-8ecf-4295-bdc6-662bf2a70bfb, Initiating User: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\\r\\nExiting ScheduleCommon.Plugins.PreOperationBookableResourceBookingUpdate.Execute(), Correlation Id: cd61352f-8ecf-4295-bdc6-662bf2a70bfb, Initiating User: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\\r\\nFpsPlugin: PluginLocal.Create, Depth: 1\\r\\nFpsPlugin: PluginLocal.Create, Depth: 1\\r\\nFpsPlugin: PluginContext Start\\r\\nFpsPlugin: MessageName: Update\\r\\nFpsPlugin: PrimaryEntityName: bookableresourcebooking\\r\\nFpsPlugin: SecondaryEntityName: none\\r\\nFpsPlugin: Stage: 40\\r\\nFpsPlugin: PreEntityImages.Count: 0\\r\\nFpsPlugin: PostEntityImages.Count: 0\\r\\nFpsPlugin: UserId: d0af2219-40a3-4559-9f88-1028a11c3635\\r\\nFpsPlugin: InitiatingUserID: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\\r\\nFpsPlugin: IsolationMode: 1\\r\\nFpsPlugin: Mode: 0\\r\\nFpsPlugin: OrganizationName: unq83fed86a82054d9c8f0ce94fdb724\\r\\nFpsPlugin: OrganizationId: 83fed86a-8205-4d9c-8f0c-e94fdb72445b\\r\\nFpsPlugin: BusinessUnitId: 121fcffe-4e70-ec11-8941-000d3a59ef81\\r\\nFpsPlugin: CorrelationId: cd61352f-8ecf-4295-bdc6-662bf2a70bfb\\r\\nFpsPlugin: RequestId: 710ae855-33e4-4299-b93d-a7d90d803a38\\r\\nFpsPlugin: OperationId: 710ae855-33e4-4299-b93d-a7d90d803a38\\r\\nFpsPlugin: IsInTransaction: True\\r\\nFpsPlugin: Depth: 1\\r\\nFpsPlugin: IsExecutingOffline: False\\r\\nFpsPlugin: Parent PluginContext Start\\r\\nFpsPlugin: \\t\\tPluginContext Start\\r\\nFpsPlugin: \\t\\tMessageName: Delete\\r\\nFpsPlugin: \\t\\tPrimaryEntityName: msdyn_resourcerequirement\\r\\nFpsPlugin: \\t\\tPrimaryEntityId: e4301b25-eeb9-ed11-83ff-6045bd006ff2\\r\\nFpsPlugin: \\t\\tSecondaryEntityName: none\\r\\nFpsPlugin: \\t\\tStage: 30\\r\\nFpsPlugin: \\t\\tPreEntityImages.Count: 0\\r\\nFpsPlugin: \\t\\tPostEntityImages.Count: 0\\r\\nFpsPlugin: \\t\\tUserId: d0af2219-40a3-4559-9f88-1028a11c3635\\r\\nFpsPlugin: \\t\\tInitiatingUserID: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\\r\\nFpsPlugin: \\t\\tIsolationMode: 1\\r\\nFpsPlugin: \\t\\tMode: 0\\r\\nFpsPlugin: \\t\\tOrganizationName: unq83fed86a82054d9c8f0ce94fdb724\\r\\nFpsPlugin: \\t\\tOrganizationId: 83fed86a-8205-4d9c-8f0c-e94fdb72445b\\r\\nFpsPlugin: \\t\\tBusinessUnitId: 121fcffe-4e70-ec11-8941-000d3a59ef81\\r\\nFpsPlugin: \\t\\tCorrelationId: cd61352f-8ecf-4295-bdc6-662bf2a70bfb\\r\\nFpsPlugin: \\t\\tRequestId: 710ae855-33e4-4299-b93d-a7d90d803a38\\r\\nFpsPlugin: \\t\\tOperationId: 710ae855-33e4-4299-b93d-a7d90d803a38\\r\\nFpsPlugin: \\t\\tIsInTransaction: True\\r\\nFpsPlugin: \\t\\tDepth: 1\\r\\nFpsPlugin: \\t\\tIsExecutingOffline: False\\r\\nFpsPlugin: \\t\\tPluginContext End\\r\\nFpsPlugin: Parent PluginContext End\\r\\nFpsPlugin: PluginContext End\\r\\nFpsPlugin: PluginLocal.Create, Depth: 1\\r\\nFpsPlugin: PluginLocal.Create, Depth: 1\\r\\nFpsPlugin: InitializePlugin: local\\r\\nFpsPlugin: ConfigurePluginFlagsSupportInternal()\\r\\nFpsPlugin: CreateEntityOperation(bookableresourcebooking)\\r\\nFpsPlugin: Operation type: BookableResourceBookingOperation\\r\\nFpsPlugin: operation.Initialize()\\r\\nFpsPlugin: operation.Execute()\\r\\nFpsPlugin: PluginStage: 40 MessageName: Update\\r\\nFpsPlugin: Before calling message handler\\r\\nFpsPlugin: After\\r\\nFpsPlugin: AfterUpdate\\r\\nFpsPlugin: AfterCreateOrUpdate\\r\\nFpsPlugin: PipelineLocal.Value: Retrieving local\\r\\nFpsPlugin: PipelineLocal.Value: Retrieving soft\\r\\nFpsPlugin: PipelineLocal.Value: Retrieving hard\\r\\nFpsPlugin: Settings: Retrieving local\\r\\nFpsPlugin: PipelineLocal.Value: Retrieving local\\r\\nFpsPlugin: PluginLocal.Create, Depth: 2\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 2\\r\\nFpsPlugin: PluginLocal.Create, Depth: 2\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 2\\r\\nFpsPlugin: After calling message handler\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 1\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 1\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 1\\r\\nFpsPlugin: PluginLocal.Dispose, Depth: 1\",\"@Microsoft.PowerApps.CDS.InnerError.Message\":\" Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 500\"}}","_annotations":{"@Microsoft.PowerApps.CDS.HelpLink":"http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException:80044150&client=platform","@Microsoft.PowerApps.CDS.TraceText":"[Microsoft.Dynamics.ProjectServiceCore.Plugins: Microsoft.Dynamics.ProjectServiceCore.Plugins.PostOperationbookableresourcebookingUpdate]\r\n[525b9b24-39ac-403b-aba2-5a22996b8ed1: Project Service Core - Update of bookableresourcebooking]\r\nFpsPlugin: PluginLocal.Create, Depth: 1\r\nFpsPlugin: PluginLocal.Create, Depth: 1\r\nFpsPlugin: PluginContext Start\r\nFpsPlugin: MessageName: Update\r\nFpsPlugin: PrimaryEntityName: bookableresourcebooking\r\nFpsPlugin: SecondaryEntityName: none\r\nFpsPlugin: Stage: 20\r\nFpsPlugin: PreEntityImages.Count: 0\r\nFpsPlugin: PostEntityImages.Count: 0\r\nFpsPlugin: UserId: d0af2219-40a3-4559-9f88-1028a11c3635\r\nFpsPlugin: InitiatingUserID: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\r\nFpsPlugin: IsolationMode: 1\r\nFpsPlugin: Mode: 0\r\nFpsPlugin: OrganizationName: unq83fed86a82054d9c8f0ce94fdb724\r\nFpsPlugin: OrganizationId: 83fed86a-8205-4d9c-8f0c-e94fdb72445b\r\nFpsPlugin: BusinessUnitId: 121fcffe-4e70-ec11-8941-000d3a59ef81\r\nFpsPlugin: CorrelationId: cd61352f-8ecf-4295-bdc6-662bf2a70bfb\r\nFpsPlugin: RequestId: 710ae855-33e4-4299-b93d-a7d90d803a38\r\nFpsPlugin: OperationId: 710ae855-33e4-4299-b93d-a7d90d803a38\r\nFpsPlugin: IsInTransaction: True\r\nFpsPlugin: Depth: 1\r\nFpsPlugin: IsExecutingOffline: False\r\nFpsPlugin: Parent PluginContext Start\r\nFpsPlugin: \t\tPluginContext Start\r\nFpsPlugin: \t\tMessageName: Delete\r\nFpsPlugin: \t\tPrimaryEntityName: msdyn_resourcerequirement\r\nFpsPlugin: \t\tPrimaryEntityId: e4301b25-eeb9-ed11-83ff-6045bd006ff2\r\nFpsPlugin: \t\tSecondaryEntityName: none\r\nFpsPlugin: \t\tStage: 30\r\nFpsPlugin: \t\tPreEntityImages.Count: 0\r\nFpsPlugin: \t\tPostEntityImages.Count: 0\r\nFpsPlugin: \t\tUserId: d0af2219-40a3-4559-9f88-1028a11c3635\r\nFpsPlugin: \t\tInitiatingUserID: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\r\nFpsPlugin: \t\tIsolationMode: 1\r\nFpsPlugin: \t\tMode: 0\r\nFpsPlugin: \t\tOrganizationName: unq83fed86a82054d9c8f0ce94fdb724\r\nFpsPlugin: \t\tOrganizationId: 83fed86a-8205-4d9c-8f0c-e94fdb72445b\r\nFpsPlugin: \t\tBusinessUnitId: 121fcffe-4e70-ec11-8941-000d3a59ef81\r\nFpsPlugin: \t\tCorrelationId: cd61352f-8ecf-4295-bdc6-662bf2a70bfb\r\nFpsPlugin: \t\tRequestId: 710ae855-33e4-4299-b93d-a7d90d803a38\r\nFpsPlugin: \t\tOperationId: 710ae855-33e4-4299-b93d-a7d90d803a38\r\nFpsPlugin: \t\tIsInTransaction: True\r\nFpsPlugin: \t\tDepth: 1\r\nFpsPlugin: \t\tIsExecutingOffline: False\r\nFpsPlugin: \t\tPluginContext End\r\nFpsPlugin: Parent PluginContext End\r\nFpsPlugin: PluginContext End\r\nFpsPlugin: PluginLocal.Create, Depth: 1\r\nFpsPlugin: PluginLocal.Create, Depth: 1\r\nFpsPlugin: InitializePlugin: local\r\nFpsPlugin: ConfigurePluginFlagsSupportInternal()\r\nFpsPlugin: CreateEntityOperation(bookableresourcebooking)\r\nFpsPlugin: Operation type: BookableResourceBookingOperation\r\nFpsPlugin: operation.Initialize()\r\nFpsPlugin: operation.Execute()\r\nFpsPlugin: PluginStage: 20 MessageName: Update\r\nFpsPlugin: Before calling message handler\r\nFpsPlugin: Before\r\nFpsPlugin: BeforeUpdate\r\nFpsPlugin: BeforeCreateOrUpdate\r\nFpsPlugin: BookingSetupMetadata: Cache miss for 3 BookingSetupMetadataDB records\r\nFpsPlugin: PipelineLocal.Value: Retrieving local\r\nFpsPlugin: PipelineLocal.Value: Retrieving soft\r\nFpsPlugin: PipelineLocal.Value: Retrieving hard\r\nFpsPlugin: Settings: Retrieving local\r\nFpsPlugin: Settings: Retrieving hard\r\nFpsPlugin: CrmMetadataCache [16264768|248]: REQUEST Timestamp: 6356733!03/21/2023 17:48:09, Metadata: \r\nFpsPlugin: CrmMetadataCache [16264768|248]: RESPONSE Timestamp: 6356733!03/21/2023 17:48:09, Metadata: \r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET Expired: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: CrmMetadataCache [16264768|248]: GET: Result True\r\nFpsPlugin: After calling message handler\r\nFpsPlugin: PluginLocal.Dispose, Depth: 1\r\nFpsPlugin: PluginLocal.Dispose, Depth: 1\r\nFpsPlugin: PluginLocal.Dispose, Depth: 1\r\nFpsPlugin: PluginLocal.Dispose, Depth: 1\r\nEntered ScheduleCommon.Plugins.PreOperationBookableResourceBookingUpdate.Execute(), Correlation Id: cd61352f-8ecf-4295-bdc6-662bf2a70bfb, Initiating User: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\r\nExiting ScheduleCommon.Plugins.PreOperationBookableResourceBookingUpdate.Execute(), Correlation Id: cd61352f-8ecf-4295-bdc6-662bf2a70bfb, Initiating User: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\r\nFpsPlugin: PluginLocal.Create, Depth: 1\r\nFpsPlugin: PluginLocal.Create, Depth: 1\r\nFpsPlugin: PluginContext Start\r\nFpsPlugin: MessageName: Update\r\nFpsPlugin: PrimaryEntityName: bookableresourcebooking\r\nFpsPlugin: SecondaryEntityName: none\r\nFpsPlugin: Stage: 40\r\nFpsPlugin: PreEntityImages.Count: 0\r\nFpsPlugin: PostEntityImages.Count: 0\r\nFpsPlugin: UserId: d0af2219-40a3-4559-9f88-1028a11c3635\r\nFpsPlugin: InitiatingUserID: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\r\nFpsPlugin: IsolationMode: 1\r\nFpsPlugin: Mode: 0\r\nFpsPlugin: OrganizationName: unq83fed86a82054d9c8f0ce94fdb724\r\nFpsPlugin: OrganizationId: 83fed86a-8205-4d9c-8f0c-e94fdb72445b\r\nFpsPlugin: BusinessUnitId: 121fcffe-4e70-ec11-8941-000d3a59ef81\r\nFpsPlugin: CorrelationId: cd61352f-8ecf-4295-bdc6-662bf2a70bfb\r\nFpsPlugin: RequestId: 710ae855-33e4-4299-b93d-a7d90d803a38\r\nFpsPlugin: OperationId: 710ae855-33e4-4299-b93d-a7d90d803a38\r\nFpsPlugin: IsInTransaction: True\r\nFpsPlugin: Depth: 1\r\nFpsPlugin: IsExecutingOffline: False\r\nFpsPlugin: Parent PluginContext Start\r\nFpsPlugin: \t\tPluginContext Start\r\nFpsPlugin: \t\tMessageName: Delete\r\nFpsPlugin: \t\tPrimaryEntityName: msdyn_resourcerequirement\r\nFpsPlugin: \t\tPrimaryEntityId: e4301b25-eeb9-ed11-83ff-6045bd006ff2\r\nFpsPlugin: \t\tSecondaryEntityName: none\r\nFpsPlugin: \t\tStage: 30\r\nFpsPlugin: \t\tPreEntityImages.Count: 0\r\nFpsPlugin: \t\tPostEntityImages.Count: 0\r\nFpsPlugin: \t\tUserId: d0af2219-40a3-4559-9f88-1028a11c3635\r\nFpsPlugin: \t\tInitiatingUserID: cfd5ae0c-73b0-ec11-9840-0022480bd7f0\r\nFpsPlugin: \t\tIsolationMode: 1\r\nFpsPlugin: \t\tMode: 0\r\nFpsPlugin: \t\tOrganizationName: unq83fed86a82054d9c8f0ce94fdb724\r\nFpsPlugin: \t\tOrganizationId: 83fed86a-8205-4d9c-8f0c-e94fdb72445b\r\nFpsPlugin: \t\tBusinessUnitId: 121fcffe-4e70-ec11-8941-000d3a59ef81\r\nFpsPlugin: \t\tCorrelationId: cd61352f-8ecf-4295-bdc6-662bf2a70bfb\r\nFpsPlugin: \t\tRequestId: 710ae855-33e4-4299-b93d-a7d90d803a38\r\nFpsPlugin: \t\tOperationId: 710ae855-33e4-4299-b93d-a7d90d803a38\r\nFpsPlugin: \t\tIsInTransaction: True\r\nFpsPlugin: \t\tDepth: 1\r\nFpsPlugin: \t\tIsExecutingOffline: False\r\nFpsPlugin: \t\tPluginContext End\r\nFpsPlugin: Parent PluginContext End\r\nFpsPlugin: PluginContext End\r\nFpsPlugin: PluginLocal.Create, Depth: 1\r\nFpsPlugin: PluginLocal.Create, Depth: 1\r\nFpsPlugin: InitializePlugin: local\r\nFpsPlugin: ConfigurePluginFlagsSupportInternal()\r\nFpsPlugin: CreateEntityOperation(bookableresourcebooking)\r\nFpsPlugin: Operation type: BookableResourceBookingOperation\r\nFpsPlugin: operation.Initialize()\r\nFpsPlugin: operation.Execute()\r\nFpsPlugin: PluginStage: 40 MessageName: Update\r\nFpsPlugin: Before calling message handler\r\nFpsPlugin: After\r\nFpsPlugin: AfterUpdate\r\nFpsPlugin: AfterCreateOrUpdate\r\nFpsPlugin: PipelineLocal.Value: Retrieving local\r\nFpsPlugin: PipelineLocal.Value: Retrieving soft\r\nFpsPlugin: PipelineLocal.Value: Retrieving hard\r\nFpsPlugin: Settings: Retrieving local\r\nFpsPlugin: PipelineLocal.Value: Retrieving local\r\nFpsPlugin: PluginLocal.Create, Depth: 2\r\nFpsPlugin: PluginLocal.Dispose, Depth: 2\r\nFpsPlugin: PluginLocal.Create, Depth: 2\r\nFpsPlugin: PluginLocal.Dispose, Depth: 2\r\nFpsPlugin: After calling message handler\r\nFpsPlugin: PluginLocal.Dispose, Depth: 1\r\nFpsPlugin: PluginLocal.Dispose, Depth: 1\r\nFpsPlugin: PluginLocal.Dispose, Depth: 1\r\nFpsPlugin: PluginLocal.Dispose, Depth: 1","@Microsoft.PowerApps.CDS.InnerError.Message":" Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 500"},"_messages":[" Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 500"]},"_message":" Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 500","_exception":null,"_innerError":null,"_errorSource":3,"_blockErrorReporting":false,"_stack":null,"_faultedRequestIndex":-1,"_clientRequestId":"641827c0-fb18-4b5d-b561-4e1b4b9fe843","_serverResponseId":"c4c66694-a243-4013-aca2-87e7adb02348, 710ae855-33e4-4299-b93d-a7d90d803a38","_httpStatusCode":500,"_retryAfter":null,"_date":"2023-03-21T17:52:38.000Z","_isRequestTooLong":false,"message":" Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 500","name":"Error","stack":"No stack available.","__action":{"source":{"actionType":"modernDataSource.execute.odata.async","actionStack":"modernDataSource.execute.odata.async","contextId":"11ccfe3d-96ac-49d5-8f75-5e9946e07c4c"},"child":{"actionType":"oData.delete.async","actionStack":"oData.delete.async","contextId":"2bab02d1-e074-4533-b6af-368c7304f28d"}}} Activity Id: bdeb0835-3fbf-4706-a18b-1854cd629b81

  • eminkoff Profile Picture
    eminkoff 5 on at
    RE: Project for the Web: Unable to assign anyone - Generic SQL error

    I had been able to figure out the issue - it was due to custom PowerFX column added into Team Members table. I changed it to regular calculated column and that helped.

  • Leco Lv Profile Picture
    Leco Lv on at
    RE: Project for the Web: Unable to assign anyone - Generic SQL error

    Hi partner,

    According to the error message you gave, it seems that the specific cause of the error cannot be determined. It is recommended that you open a ticket to the MS Team.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Adis Profile Picture

Adis 136 Super User 2025 Season 1

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 81

#3
Jonas "Jones" Melgaard Profile Picture

Jonas "Jones" Melgaard 77 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans