This is to list the steps on how to RE-CREATE Policy Store manually on MSSQL.
Policy Server 12.8.x
Policy Store : MSSQL
At times the Policy Store may not have been upgraded properly and can report error when creating objects.
Recreate the Policy Store following the steps below.
Backup the database before performing the following so there's a way to revert.
Perform this in a testing environment first.
Although this procedure for MSSQL Policy Store, conceptually the steps will be the same for other Policy Stores.