It is possible to create and successfully deploy a SAS IT Resource Management job that includes aggregations, but yet still receive the following error messages when the job executes:

   ERROR: Cannot find metadata for aggregation transformation 
          output table with metadata id Axxxxxxxx.AGyyyyyyy.
   ERROR: Compiled macro failed in transform Aggregation 
          (Aaaaaaaa.Abbbbbbb). Trans_rc = 8.
   ERROR: Transform failed, trans_rc = 8.

These messages appear when the job attempts but fails to connect to the metadata server and update table status information, such as date range, number of observations, and so forth.

Some possible causes for these errors are as follows:

1. The metadata server is down.

   Several methods exist to verify whether the metadata server is down. One method is to attempt to connect to the metatdata server via SAS^® Data Integration Studio or SAS^® Management Console.

2. A data step inside the job failed to connect to the metadata server due to an authentication failure.

   An example of this condition would be if the password of the user ID associated with the job has changed since the job was deployed. To verify whether the authentication is causing the error, modify the generated code by inserting the following statement into the job where the first %LET xxxMETAxxx statements are visible:

   %LET METAPASSWORD=myClearPassword;

   If the same error persists, verify whether the password was changed after you generated the job: Inititate a connection, either by using SAS Data Integration Studio or SAS Mangement Console to access the metadata server with the user ID and password in question.

   If the password has changed, it is best to redeploy the job so as to update all applicable locations in the job with the new password. Another circumvention is to change, manually, all passwords that are referenced in the batch job.

3. You have attempted to access a metadata and application server that uses a version of SAS^® software that has been compiled for an encoding other than U.S. EBCDIC (W0).
   
   
4. The PhysicalTable object of concern—Axxxxxxxx.AGyyyyyyy—was removed from the metadata server after the job was generated.

   Note that the table ID is different from the name of the aggregation (Aaaaaaaa.Abbbbbbb).

   To verify that the table ID is defined to the metatdata server, you should review, update, and submit the sample code in SAS Note 31025, or use SAS^® Metadata Explorer.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS IT Resource Management 3.1.1 is available at: