Orchestrator is accessible but the user is unable to perform any action due to a database quota issue. How to resolve this?
Issue Description:
Orchestrator is accessible but the user is unable to perform any action in Orchestrator across tenants. The logs point to the Database quota.
Error Message in Orchestrator pod logs:
The following error is observed in the Orchestrator pod logs:
The database AutomationSuite_Orchestartor has reached its size quota. Partition or delete data, drop indexes or consult the documentation for possible resolutions.
Resolution:
- Check if the DB has space available. This error generally occurs if the assigned size quota gets maxed out.
- This generally happens due to the number of logs, however, it is good to analyze the cause of it being maxed out, if it logs over time then it could be expected and needs DB maintenance script to be run. If the logs need to be in the system for some reason then the DB space should be increased to solve the issue.
- If it is not that and an unexpected event caused the issue then it is important to figure out the reason behind it, check the table sizes, and see which one has grown unexpectedly and that could derive the reason.
- For example, if the logs table is affected then check the logs for the last 24 hours from the time the issue started and see what processes have been logged in most of the logs and analyze them. If it is not supposed to be there delete the logs, and stop the process.
- Once cleaned, ensure that enough space is available in DB and post that it will work as expected.
- If the issue persists, create a case with the UiPath Support team for further troubleshooting.