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.
What we have tried till now?
Release : 4.8
Component : CA Test Data Manager