Datamart initial data load fails - Error occurred while trying to connect to the database


Article ID: 125580


Updated On:


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


I am trying to run the initial data load per instructions at:

Configure Insights > Step 6: Run the Extract Transfer and Load (ETL) Job

I get these related errors:
 - The connection string contains a badly formed name or value.

I have checked '' that gets in 'NX_ROOT\Program Files\CA\Datamart\config' and I can log in to SQL with all of these credentials.

The datamart_std.log shows this error which I cannot find a reference:

" ERROR 2019-01-28 16:05:01,889 [Thread-78] pentaho.di.eventAdded() :: Check Connections - Cannot connect to database [${destination_database}] (connection [data_mart]). Exception : [org.pentaho.di.core.exception.KettleDatabaseException: Error occurred while trying to connect to the database
Error connecting to database: (using class
Login failed for user 'mdbadmin'. "


The reason for this error could be the password containing { and } or other kind of special character.


CA Service Desk Manager 17.1.x


I need you to change the password by a password without the special characters.
After you change dmadmin user password in SQL DBMS, you can update the connection password like this:

1. Back up file in Datamart\config folder
2. From NX_ROOT/bin, run
encrypt_pwd -sdme "password"
Where password is the same as you did in SQL DBMS dmadmin password.
Then copy and replace the encrypted password string in Datamart\config\ Save the changes
3. Run std-load again