Datamart database casm_dm not created at install

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

When installing Datamart from the CA Service Management DVD, no errors occurred, the installation seemed to complete successfully, but the casm_dm database was not created.

Cause

The password for the "sa" username, which is part of the specified connection parameters during installation of Datamart, includes one or more characters that are not alphanumeric English.  For example, a password that contains = or &.

Environment

CA Service Management 17.1
CA Service Management 17.1.0.1 (rollup #1)

Resolution

Change the password to simplified password, a password that does not contain special characters.
 
After Datamart is successfully installed, and the database has been created, change the password back to the original password.

Additional Information

The fix is planned to be included in 17.1.0.2 (rollup #2).