Datamart database casm_dm not created at install

Article Id: 107099

Status: Published

Updated On: 25-09-2018 08:58

Products:

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS 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).