Problem Note 56055: The getDBMirrorData.sas job fails and returns "ERROR: Some character data was lost during transcoding in the dataset WORK.EAM_ALERT_DEFINITION..."
 |  |  |  |
The getDBMirrorData.sas job called by the master_apm_etl.sh and master_acm_etl.sh flows fails under UNIX when the following conditions apply:
- The SAS session executing the getDBMirrorData.sas job is using latin9 encoding.
- The WORK.EAM_ALERT_DEFINITION table has an entry containing the following description:
Zombies Processes are leftover bits of dead processes that haven't been cleaned up. Indication of a application problem.
In this scenario, the getDBMirrorData.sas job fails with the following error message:
ERROR: Some character data was lost during transcoding in the dataset WORK.EAM_ALERT_DEFINITION. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.
To work around the problem, complete the following steps:
- Open the alerts.xml file located here: SAS-configuration-directory/Lev1/Web/SASEnvironmentManager/emi-framework/ConfigureFiles/Kits/emi-framework/sasev/alerts.xml.
- In this file, change haven't to have not.
- Reload the kit installer step by running ./bin/ev_kit_installer.sh -f -k emi-framework. This forces the installer to reload and replace the alert definitions.
- Rerun the step that failed and triggered the error. For example, if the step in which you enable Agent-Collected Metric (ACM) failed, then you need to rerun ./emi_init.sh --enable ACM.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Environment Manager Enablement Kit Server | 64-bit Enabled AIX | 2.4 | 2.5 | 9.4 TS1M2 | 9.4 TS1M4 |
| HP-UX IPF | 2.4 | 2.5 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Linux for x64 | 2.4 | 2.5 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Solaris for x64 | 2.4 | 2.5 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 2.4 | 2.5 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-06-28 16:23:30 |
| Date Created: | 2015-06-24 14:52:02 |