XrmApiServerError - Can't list flows, Approvals stopped working.

[pkochanowski]

Hi,

I have a flow that creates a simple approval proces for invoices. It worked fine for over two years, when suddenly - last friday evening it stopped working. No approvals where sent.

When I try to access the flows through Flows > Cloud flows I get the following "XrmApiServerError":

Request to XRM API failed with server error: 'Message: Timeout occurred when calling the XRM api' Code: InnerError: Type: System.Threading.Tasks.TaskCanceledException Message: A task was canceled. StackTrace: at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Net.Http.HttpClient.d__58.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.WindowsAzure.ResourceStack.Common.EventSources.IHttpEventSourceExtensions.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult() at Microsoft.Azure.ProcessSimple.Data.DataProviders.XrmDataProvider.<>c__DisplayClass126_0`1.<b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.WindowsAzure.ResourceStack.Common.Algorithms.AsyncRetry.d__3`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult() at Microsoft.Azure.ProcessSimple.Data.DataProviders.XrmDataProvider.d__126`1.MoveNext() InternalException: '. The tracking Id is 'aec9023c-2087-4674-b50c-1f16da6f48f2'.

I managed to open run history for the flow, and I can see the following message in there:

Looks like your flow's operation is hitting an action limit designed to protect the connector service being called.

Redesign your flow to use fewer actions of this connector 'Approvals' to reduce the chances of hitting the throttling limits.

I checked Approvals connector limits, and apparently it's 500 requests per minute, my flow was not using anything near that, 1 request every few minutes at most. 

Another thing is that Approvals app in Teams is not working, when I try to access it, only thing I get is "Something went wrong. Open the app again, or try to create an approval if this is your first time using the app.".

EDIT: I drilled down to the error source in flow history, and I found the following error message:

{
  "error": {
    "code": "CdsInstanceProvisioningIncomplete",
    "message": "A Microsoft Dataverse database for this environment has not completed provisioning or does not yet support the requested approvals functionality. Please try again later."
  }
}

What can I do to fix this ?

Regards,

Piotr Kochanowski

[BetterM]

Did you manage to solve this issue?

[pkochanowski]

Hello,

Yes, I found this post - Power Automate Approval Flows Failing? (updated) (linkedin.com) and here - Solved: Power Pipelines Approval: The Approvals operation ... - Power Platform Community (microsoft....  it worked in my case with some extra steps. - my enviroment was only visible at https://make.powerautomate.com/ in 'Solutions' tab, and not in the Platform Admin Center (admin.powerplatform.microsoft.com).

Regards,

Piotr