Hello,
I recently tried to create an account from power automate and it failed.
Power automate error
"body": {
"error": {
"code": "0x80044150",
"message": " Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 547",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionSourceKey": "Plugin/Microsoft.Crm.Common.ObjectModel.AccountService",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepKey": "6e3b8615-ecd8-db11-b397-0019b9204da9",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiDepthKey": "1",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiActivityIdKey": "c66bddeb-490b-4ec6-b6b3-995221ec2af7",
"@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.InnerError.Message": " Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 547"
}
}
Likewise, I tried to create the account
and also to edit
what could be the possible problem.
This is a sampe of the downloaded log file
Exception Message: Account does not exist.
ErrorCode: -2147220222
HexErrorCode: 0x80040502
ErrorDetails:
ApiExceptionSourceKey: Plugin/Microsoft.Crm.Common.ObjectModel.AccountService
ApiStepKey: 63cdbb1b-ea3e-db11-86a7-000a3a5473e8
ApiDepthKey: 1
ApiActivityIdKey: d5b86d1c-8f57-4c8a-99e0-4bd585c2ffc3
ApiPluginSolutionNameKey: System
ApiStepSolutionNameKey: System
ApiExceptionCategory: ClientError
ApiExceptionMessageName: AccountDoesNotExist
ApiExceptionHttpStatusCode: 400
HelpLink: go.microsoft.com/.../
Activity Id: 9ded7789-8936-463f-8853-dd88c4a2825f
Kindly help
