Error Log
Upon further analysis, there is an error log seen on the Windows event viewer of the Policy Server indicating a database disk space error upon executing the stored procedure:
Solution
- Ensure that you have privileges to access the Policy Server and/or Policy Server Database (SQL Server).
- Open the SQL Server Management Studio (SSMS) then connect to the database of the policy server.
- Download and open the stored procedure to purge the Audit log using SSMS: sp_PurgeAuditLog.sql
- Type the below command to run the sp_PurgeAuditLog.sql (For example: "EXEC dbo.PurgeAuditLog 30")
Please make sure of how many days you want to keep the logs.
- Enable the purge function in the MMC.