Problem Note 64894: Configuration of the Reference Data Manager component fails with the error "Failed to create the database dmmondashuser"
 |  |  |  |  |
The configuration of the Reference Data Manager component fails, generating the following error:
When the failure occurs, the following message is displayed in the configuration log:
BUILD FAILED
/sso/sfw/sas/940/SASReferenceDataManager/3.3/Config/dmrdmmid_config.xml:222: The following error occurred while executing this line:
/sso/sfw/sas/940/SASReferenceDataManager/3.3/Config/dmrdmmid_config.xml:2102: ========== An error occurred trying to create dmmondashuser ==========
/sso/sfw/sas/940/SASReferenceDataManager/3.3/Config/dmrdmmid_config.xml:222: The following error occurred while executing this line:
/sso/sfw/sas/940/SASReferenceDataManager/3.3/Config/dmrdmmid_config.xml:2102: ========== An error occurred trying to create dmmondashuser ==========
To work around this problem, you need to replace the dmrdmmid_config.xml file, which is located in the $SASHOME/SASReferenceDataManager/3.3/Config/ folder, with this file.
After you replace the dmrdmmid_config.xml file, click Retry. Then the configuration should complete successfully.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Business Data Network | Microsoft® Windows® for x64 | 3.3 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 3.3 | 9.4 TS1M6 | ||||
| 64-bit Enabled Solaris | 3.3 | 9.4 TS1M6 | ||||
| HP-UX IPF | 3.3 | 9.4 TS1M6 | ||||
| Linux for x64 | 3.3 | 9.4 TS1M6 | ||||
| Solaris for x64 | 3.3 | 9.4 TS1M6 | ||||
A fix for this issue for SAS Reference Data Manager 3.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G3I.html#64894
The configuration of the Reference Data Manager component fails with the error "Failed to create the database dmmondashuser." The failure occurs because two databases are configured for Reference Data Manager, and the wrong password is being retrieved.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-11-20 16:37:18 |
| Date Created: | 2019-10-09 09:16:22 |