Unanswered

AsyncOperation table file capacity growing

(0) Share

Report

Posted on by nanenchanga

The Async Operation table has increased dramatically. The cause is currently unknown, and we have cleaned it up according to the following document, but we could not see any change in capacity.
I've made a few Power Fx plugins, but I'm suspecting that this has increased significantly. Does anyone have the same problem? And is there a solution to reduce the capacity?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Devikumari Krishna 988 Super User 2024 Season 1 on at

Like (0)

Report

Hi @nanenchanga ,

Hope you revisited the code? And did you see if there are any recursive jobs that are causing the table to grow.
If you are confident that coding is fine and there are no such jobs triggering in loop, please raise a support ticket with Microsoft.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
My Blog: Dynamics 365 Key Topics – https://d365topicsbydk.com/
My YouTube Channel : https://www.youtube.com/channel/UCxSIryP2ah2VpEFr-Z72t1A

Regards
Devi

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @nanenchanga ,

You mentioned cleaning up with the following article? Is it this? https://learn.microsoft.com/en-us/power-platform/admin/cleanup-asyncoperationbase-table

Was this reply helpful? Yes No
Parvez Ghumra 1,579 Moderator on at

Like (0)

Report

@nanenchanga Other than the clear down of the asyncoperationbase table using a recurring bulk data deletion job, I would also recommend that you configure your async plugin SDK Message Processing Steps to auto-delete the async job upon successful completion, and also ensure that you configure you workflows similarly to auto-delete the job upon successful completion and only retain jobs that encounter errors (for troubleshooting purposes)

Also note that the analytics reports in the Power Platform Admin Centre are not updated in real-time. I would suggest rechecking tomorrow. I think if your deletion job has completed successfully then you should notice a significant drop in the space consumed by the asyncoperationbase table

Was this reply helpful? Yes No