There are several prerequisites for running the Clean_Database script.
The user running the script must be a novell user, and each script must have the permission set so that only the novell user is allowed to execute the cleanup script.
The user running the PostgreSQL script must have permission to access/execute all of the database tools and utilities. Run the script as a dbauser.
(Identity Cleanup only) The database must be in a healthy state and in good running condition because the Identity cleanup stored procedure disables and enables foreign key constraints.
(Identity Cleanup only) All Identity/Account loaders and Collectors, such as the Identity Vault Collector, should be stopped.
(Identity Cleanup only) Reports that are running queries against the Identity tables should be stopped.
The Identity cleanup DDL operations are atomic, so if one DDL statement execution fails, the script exits with errors written to the specified log file.
WARNING:If identity information is cleaned out of the database and then reloaded, the new identity information is not synchronized with any past events that had identity information injected. Therefore, attempts to perform identity lookups on past events (received before the cleanup) or run reports on past events with identity information is not successful.
Use this option with extreme caution.
For trademark and copyright information, see Legal Notices.