The following error might occur when you upgrade the MXG software that you use with SAS IT Resource Management to MXG 33.12 or later:

ERROR: File WORK.SUMSTSBP.DATA does not exist.

The _SDB2SBP macro is not invoked by SAS IT Resource Management. As a result, it does not create the WORK.SUMSTSBP data set, which is required by the _SDB2STS macro.

How you circumvent this problem depends upon your release of SAS IT Resource Management:

• SAS IT Resource Management release 3.6 (and earlier) sites

  To circumvent this problem, create the macro variable EPDBOUT to point to the _SDB2SBP 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= _SDB2SBP;
  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.

Operating System and Release Information