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- SERVERCA Service Desk Manager - Unified Self ServiceKNOWLEDGE TOOLSCA Service Management - Asset Portfolio ManagementCA 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