When you delete an object in the SAS Risk Governance Framework, the object is removed from the live tables in the database, but the history tables retain any references to the object. Any attachments to the object remain in the WebDAV repository of the SAS^® Content Server.

A new capability enables you to purge an object and delete all references to the object. The purge includes records from the history and live tables in the database, the associated workflow instances from the SAS^® Shared Services database, and any attachments associated with the object. If the purged object is linked to any other objects, the link instances are purged, but the linked objects remain.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After you install the hot fix, ensure that you follow all of the post-installation steps for the hot fix. These steps include instructions to copy the purgeObjects.groovy script that is required for the new purge capability.

To purge an object, follow the steps below:

1. Run the verifydb command to verify the integrity of the SAS Risk Governance Framework database. 
2. Create a backup copy of the SAS Risk Governance Framework database and of the SAS Shared Services database.
3. Create a Microsoft Excel data loader file. The sheet in the file must be named PurgeObjects. See the sample PurgeObjects.zip file on the Downloads tab of this note. The data file should contain the following columns:

• Business Object.Type Name
• Business Object.Source System
• Business Object.ID

4. In the data file, specify the values for the objects that you want to purge.
5. Execute the removexlsdata command in test mode first to ensure that no errors are identified. In the command, specify the data file containing the objects to be purged, as shown in the example below:

6. Execute the removexlsdata command to purge the objects, as shown in the example below:

7. Run the verifydb command after the purge to verify the integrity of the SAS Risk Governance Framework database.

Notes:

• Only a user with the super-user global capability can purge an object.
• The purge capability is available only from the command line. You cannot purge an object through the user interface of the web application. 

Operating System and Release Information

A fix for this issue for SAS Risk Governance Framework 7.4 is available at: