The SAS Environment Manager master Agent-Collected Metric (ACM) extract, transform, and load (ETL) process might fail. The resulting SAS^® log file is located in the emi-framework/Logs directory. The filename has the following syntax: updateEVDM_YYYYMMDD_HHMM.sas.log. The log contains errors or notes that are similar to the following:

ERROR: The ID value "XXXXXX" occurs twice in the same BY group.
ERROR: Too many bad BY groups.
NOTE: *** Macro LOCKDS:  Called to LOCK table (ACM.HOSTPLATFORMS)***

This problem occurs when all of the following conditions apply:

• SAS Environment Manager is installed.
• The Service Architecture ACM ETL has been enabled.
• The ACM ETL process is interrupted for more then nine days.

When there is at least a nine-day lapse of collected ACM ETL data, the data-extract step attempts to pull more than nine days' worth of data. The extracted data is stored in a rolling set of tables, which is where an older table is dropped when a new table is read in. In this case, some tables are queried multiple times and the same data is extracted repeatedly. These duplicate records result in the failure of the master ACM ETL process.

To work around this issue, submit the following SORT procedure:

libname evdmraw 'SAS-configuration-directory/Web/SASEnvironmentManager/emi-framework/Datamart/evdmraw';

proc sort data=evdmraw.hq_metric_data nodupkey;
   by datetime measurement_id;
run;

This procedure eliminates the duplicate records from the appropriate data set, which enables the ACM ETL process to run successfully.

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 Environment Manager Enablement Kit Server 2.1 is available at: