Problem Note 34430: The RMPURGDM macro fails when values of STAGE or AGG are specified in the whichTables parameter
 |  |  |  |  |
The RMPURGDM macro (which is available starting in hot fix 311IS04) will fail if you override the whichTables parameter with the value of "STAGE" or "AGG". You will see the following error message:
ERROR: The whichTables parameter must be set
to: ALL, STAGE, or AGG
There is no fix for this issue at this time.
The macro RMPURGDM in SAS® IT Resource Management is available with hot fix 311IS04, and can be used by SAS IT Resource Management installations that have implemented this hot fix. This macro will only work for IT data marts that are created with the Adapter Setup Wizard. For a detailed description of the functionality of this macro, review the comments inside the macro.
By default, the RMPURGDM macro has the parameter "whichTables= ALL", which will do the following:
- Attempt to find all the Staged and Aggregation tables in a given IT Resource Management data mart
- Delete all the records from each table
- Clear the aging information for the aggregation tables
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS IT Resource Management-Server | z/OS | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP 64-bit Edition | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft® Windows® for x64 | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Advanced Server | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled HP-UX | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled Solaris | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| HP-UX IPF | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Linux | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Tru64 UNIX | 3.1.1 | 3.1.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS IT Resource Management 3.1.1 is available at:
http://www.sas.com/techsup/download/hotfix/itrm311.html#034430| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-02-23 10:57:24 |
| Date Created: | 2009-01-09 11:16:31 |