Tiles failing with database profile connection issue after password for userid was changed

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

During the weekend the password for TDMAPPLICATIONS01 was changed to a 15 character password to align with our corporate security requirements.  TDMAPPLICATIONS01 is a non human id that we used to connect to several systems. When we execute tiles it’s failing with error as below

 

“Publish to: Database: CATDMDataMart and Schema: dbo using Profile: TDMMart

ERROR: Publish failed for job 69595, resolve_meta_data_item: TDMServiceException: execsql: CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'TDMAPPLICATIONS01'. ClientConnectionId:303f6c5a-4c7e-4187-ab11-f7d1111cec9f

End date and time: 2020/05/19 12:40:13”

 

This issue is observed for few tiles and other tiles are running without any issues.

In terms of user, for few users its working fine but for few users its getting failed.

 

What we have tried till now?

 

1. Checked and updated the password in TDMMart profile and re-execute. But issue still there.
2. Gave admin privilege to profile and executed. But issue still there.
3. Checked Javelin flow for connection details and it has correct connection details for database user.
4. Asked user to clear the cache and history log and re-run the tile.

 

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

We noticed that, you have not updated user details in application.properties file with modified password. After we adding the password details and restarting the portal service, you are able to publish the jobs correctly.