How to resolve the issue - "System.Data.SqlClient.SqlException 0x80131904 Could Not Allocate Space For Object dbo.Ledger PKdboLedger In Database UiPathOrchestratorQANew...." ?
Error Message:
Sometimes the below exception message is observed in the Event Viewer logs:
System.Data.SqlClient.SqlException (0x80131904): Could not allocate space for object 'dbo.Ledger'.'PK_dbo.Ledger' in database 'xxxx because the 'PRIMARY' filegroup is full.
Resolution:
The error suggests that the primary file group on the database server is running out of space, due to which no operation is no longer possible from the Orchestrator side. Below resolution steps should be helpful in mitigating this issue:
- The DBA team should be informed of the error and advised to increase the space or perform a cleanup.
- Refer to Maintenance Considerations (uipath.com) for DB maintenance and archival of older data. The steps are specific to the version therefore check the orchestrator version and match it with the guide version.
- Unwanted files should be removed from the database server, if feasible.
- The instructions in Could Not Allocate Space For Object can be referred to for more details.