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

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Risk Governance Framework	Microsoft Windows 8 Pro 32-bit	7.4		9.4 TS1M5
		Microsoft Windows 8 Enterprise x64	7.4		9.4 TS1M5
		Microsoft Windows 8 Enterprise 32-bit	7.4		9.4 TS1M5
		Microsoft® Windows® for x64	7.4		9.4 TS1M5
		Microsoft Windows 8 Pro x64	7.4		9.4 TS1M5
		Microsoft Windows 8.1 Enterprise 32-bit	7.4		9.4 TS1M5
		Microsoft Windows 8.1 Enterprise x64	7.4		9.4 TS1M5
		Microsoft Windows 8.1 Pro 32-bit	7.4		9.4 TS1M5
		Microsoft Windows 8.1 Pro x64	7.4		9.4 TS1M5
		Microsoft Windows 10	7.4		9.4 TS1M5
		Microsoft Windows Server 2008	7.4		9.4 TS1M5
		Microsoft Windows Server 2008 R2	7.4		9.4 TS1M5
		Microsoft Windows Server 2008 for x64	7.4		9.4 TS1M5
		Microsoft Windows Server 2012 Datacenter	7.4		9.4 TS1M5
		Microsoft Windows Server 2012 R2 Datacenter	7.4		9.4 TS1M5
		Microsoft Windows Server 2012 R2 Std	7.4		9.4 TS1M5
		Microsoft Windows Server 2012 Std	7.4		9.4 TS1M5
		Microsoft Windows Server 2016	7.4		9.4 TS1M5
		Windows 7 Enterprise 32 bit	7.4		9.4 TS1M5
		Windows 7 Enterprise x64	7.4		9.4 TS1M5
		Windows 7 Home Premium 32 bit	7.4		9.4 TS1M5
		Windows 7 Home Premium x64	7.4		9.4 TS1M5
		Windows 7 Professional 32 bit	7.4		9.4 TS1M5
		Windows 7 Professional x64	7.4		9.4 TS1M5
		Windows 7 Ultimate 32 bit	7.4		9.4 TS1M5
		Windows 7 Ultimate x64	7.4		9.4 TS1M5
		Linux for x64	7.4		9.4 TS1M5

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

PurgeObjects.zip

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

https://tshf.sas.com/techsup/download/hotfix/HF2/D4Z.html#68492

---

With the new purge capability, you can delete an object and all references to the object.

Type:	Usage Note
Priority:

Date Modified:	2021-11-01 09:00:52
Date Created:	2021-10-08 15:23:27