SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 31188: CMPROCES produces errors and warnings related to CPTABLS macro variables

DetailsHotfixAboutRate It

The following error messages might occur in SAS® IT Resource Management when you execute the %CMPROCES macro with a list of tables:

   WARNING: Apparent symbolic reference CPTABLS1 not resolved.
   WARNING: Apparent symbolic reference CPTABLS2 not resolved.
   WARNING: Apparent symbolic reference CPTABLS3 not resolved.

ERROR: Migrate failed for table &CPTABLS. Check table spelling.

To circumvent these errors, make sure you have a working backup copy of your PDB and use one of these circumventions:

  1. Use the %CPPROCES macro instead of the %CMPROCES macro.
  2. Code the following SAS statements in your job prior to invoking the %CMPROCES macro:

    %GLOBAL CPTABLS1 CPTABLS2 CPTABLS3;
    

    Or, a less-instrusive change would be to add the following options to the configuration file used by the batch job to use the SAS System option IS= in order to define globally the macro variables CPTABLS1, CPTABLS2, CPTABLS3 as follows:

    IS="%GLOBAL CPTABLS1 CPTABLS2 CPTABLS3;"
    

  3. Do not specify a table list, and allow the default to all tables existing in the PDB to be processed, when appropriate.


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS IT Resource Management-Serverz/OS2.79.1 TS1M3 SP4
* 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.