Problem Note 45583: An error occurs when you upgrade Merrill Consultants' MXG software that is used with SAS® IT Resource Management to release 29.29 or later
The following error might occur when you upgrade the MXG software that you use with SAS IT Resource Management to MXG 29.29 or later:
ERROR: BY variables are not properly sorted on
data set WORK.DB2ST225
The _SDB2STS MXG macro merges the DB2ST225 data set into the MXG DB2STATS staged data set that is used by SAS IT Resource Management to create the XDBTATS data set. This task requires DB2ST225 to be sorted. The merge fails because the MXG macro _SDB2225 is not invoked by SAS IT Resource Management.
How you circumvent this problem depends upon your release of SAS IT Resource Management:
- SAS IT Resource Management release 3.2 sites
To circumvent this problem, create the macro variable EPDBOUT to point to the _SDB2225 macro. EPDBOUT is used by the MXG EXPDBOUT member and also honored by SAS IT Resource Management. To create the macro variable, use the following %LET SAS macro statement:
%let epdbout= _SDB2225;
You should place this statement inside the SAS IT Resource Management Release 3 deployed staging code, preferably at the top of the code for visibility.
Note: Any subsequent deployment of the staging job requires that you place the %LET SAS macro again. You must do this because any modifications to the staging job using the SAS IT Resource Management client are deleted when that job is redeployed.
- SAS IT Resource Management release 2.7 sites
SAS IT Resource Management 2.7 sites should create the EPDBOUT macro variable after you invoke the %CPSTART macro and immediately before the invocation of the %CxPROCES macro.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS IT Resource Management-Server | z/OS | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Server | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows XP 64-bit Edition | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Advanced Server | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Datacenter Server | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Professional | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows NT Workstation | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Datacenter Edition | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise Edition | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Standard Edition | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft Windows XP Professional | 2.7 | | 9.1 TS1M3 SP4 | |
Windows Vista | 2.7 | | 9.1 TS1M3 SP4 | |
Windows Vista for x64 | 2.7 | | 9.1 TS1M3 SP4 | |
64-bit Enabled AIX | 2.7 | | 9.1 TS1M3 SP4 | |
64-bit Enabled HP-UX | 2.7 | | 9.1 TS1M3 SP4 | |
64-bit Enabled Solaris | 2.7 | | 9.1 TS1M3 SP4 | |
HP-UX IPF | 2.7 | | 9.1 TS1M3 SP4 | |
Linux | 2.7 | | 9.1 TS1M3 SP4 | |
Tru64 UNIX | 2.7 | | 9.1 TS1M3 SP4 | |
Microsoft® Windows® for x64 | 3.2 | | 9.2 TS2M3 | |
Microsoft Windows Server 2003 for x64 | 3.2 | | 9.2 TS2M3 | |
Microsoft Windows Server 2008 | 3.2 | | 9.2 TS2M3 | |
Microsoft Windows Server 2008 for x64 | 3.2 | | 9.2 TS2M3 | |
Windows 7 Enterprise 32 bit | 3.2 | | 9.2 TS2M3 | |
Windows 7 Enterprise x64 | 3.2 | | 9.2 TS2M3 | |
Windows 7 Home Premium 32 bit | 3.2 | | 9.2 TS2M3 | |
Windows 7 Home Premium x64 | 3.2 | | 9.2 TS2M3 | |
Windows 7 Professional 32 bit | 3.2 | | 9.2 TS2M3 | |
Windows 7 Professional x64 | 3.2 | | 9.2 TS2M3 | |
Windows 7 Ultimate 32 bit | 3.2 | | 9.2 TS2M3 | |
Windows 7 Ultimate x64 | 3.2 | | 9.2 TS2M3 | |
Linux for x64 | 3.2 | | 9.2 TS2M3 | |
Solaris for x64 | 3.2 | | 9.2 TS2M3 | |
*
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.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2012-06-07 08:56:33 |
Date Created: | 2012-02-06 13:58:37 |