Environment
Situation
Where can i find the VPC 5.6 SP2 SQL database cleanup script?
Resolution
The VPC 5.6 SP2 SQL database cleanup script located:
VPC Installation Path\database\cleanup\VPCSP2Cleanup_Script.sql
Steps to execute the cleanup script
- Stop the VigilEnt Policy Center services
- Execute the SQL script, 'VPCSP2Cleanup_Script.sql'. It is very important that you execute this script with the name of the user was selected in the NetIQ-VPC installation process. The default user account is the vpc_user.
- Start the VigilEnt Policy Center services
Cause
VPC 5.6 service pack 2 includes a SQL database cleanup script to ensure that all existing users have the documents that they have read correctly assigned to them in the VigilEnt Policy Center database. This script is saved to the VigilEnt Policy Center computer when you install the service pack, but is not automatically executed. If you have a small database or the documents in your database are already correctly assigned to users, the script will take a short time to execute. However, if your database is large or there are users in your database that do not have the correct documents assigned to them, the script could take up to two hours to execute. You should first install the service pack and then run the script at night or another convenient time when users do not need access to VigilEnt Policy Center. For more information about running the database cleanup script, see Installing This Service Pack. (ENG303729)
Additional Information
If you are installing service pack 2 in a new installation of VigilEnt Policy Center 5.6, you do not need to run this database cleanup script. The script is intended only for existing customers whose database may require some cleanup.