Dynamics Community Forum Thread Details

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

I got this error in a power automate flow while creating contact record, On Contact entity, there is a sync workflow triggered on creating contact record. Can anyone suggest how to solve this error?

"error": {

"code": "0x80040265",

"message": " Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 1205",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionSourceKey": "Plugin/Microsoft.Crm.Common.ObjectModel.ContactService",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepKey": "c5cdbb1b-ea3e-db11-86a7-000a3a5473e8",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiDepthKey": "2",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiActivityIdKey": "229ab597-a8f3-4115-92ec-d5b0d776b8b4",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiPluginSolutionNameKey": "System",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepSolutionNameKey": "System",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionCategory": "SystemFailure",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionMessageName": "unManagedidssqlerror",

"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionHttpStatusCode": "500",

"@Microsoft.PowerApps.CDS.ErrorDetails.OperationStatus": "0",

"@Microsoft.PowerApps.CDS.ErrorDetails.SubErrorCode": "-2146233088",

"@Microsoft.PowerApps.CDS.ErrorDetails.Plugin.PluginTrace": "[Microsoft.Crm.ObjectModel: Microsoft.Crm.ObjectModel.SyncWorkflowExecutionPlugin]\r\n[9c8f94e7-280b-e811-818b-e0071b67aa71: ]\r\nStarting sync workflow 'contact- add default parent if parent is null', Id: bc4b9ce1-280b-e811-818b-e0071b67aa71\r\nEntering ConditionStep1_step: check company is null then add dummy a default company\r\nEntering UpdateStep3_step: \r\nSync workflow 'contact- add default parent if parent is null' terminated with error ' Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 1205'",

"@Microsoft.PowerApps.CDS.TraceText": "\r\n[Microsoft.Crm.ObjectModel: Microsoft.Crm.ObjectModel.SyncWorkflowExecutionPlugin]\r\n[9c8f94e7-280b-e811-818b-e0071b67aa71: ]\r\nStarting sync workflow 'contact- add default parent if parent is null', Id: bc4b9ce1-280b-e811-818b-e0071b67aa71\r\nEntering ConditionStep1_step: check company is null then add dummy a default company\r\nEntering UpdateStep3_step: \r\nSync workflow 'contact- add default parent if parent is null' terminated with error ' Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 1205'\r\n",

"@Microsoft.PowerApps.CDS.InnerError.Message": " Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 1205"

}

Quick Links

Leaderboard