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

book

Article ID: 125580

calendar_today

Updated On:

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

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

Configure Insights > Step 6: Run the Extract Transfer and Load (ETL) Job
https://docops.ca.com/ca-service-management/17-1/en/administering/configure-insights/#ConfigureInsights-Step6:RuntheExtractTransferandLoad(ETL)Job

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

I have checked 'config.properties' 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 com.microsoft.sqlserver.jdbc.SQLServerDriver)
Login failed for user 'mdbadmin'. "

Cause

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

Environment

CA Service Desk Manager 17.1.x

Resolution

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 config.properties 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\config.properties. Save the changes
3. Run std-load again