web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Leco Lv Profile Picture
    Leco Lv on at

    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.

  • eminkoff Profile Picture
    eminkoff 5 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 46 Most Valuable Professional

#2
Pallavi Phade Profile Picture

Pallavi Phade 33

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 28 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
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