Skip to main content

Notifications

Announcements

Announcing Category Subscriptions!
News and Announcements icon
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

News and Announcements

Announcing Category Subscriptions!

Quick Links

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans