1.DB connection profile is not working as expected due to Authentication issue. 2.After Modifying the credential its not getting reflected during the Tile execution time.
The error is <resolve_meta_data_item: TDMServiceException: execsqlcount: TDMServiceException: Failed to connect: TDMDatabaseException: getDBConnection: Unable to connect to database jdbc:db2://abc.xyz.com:33098/DTG1;user=Maxx: Failed to obtain JDBC Connection; nested exception is com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][4.12.55] Connection authorization failure occurred. Reason: Local security service non-retryable error. ERRORCODE=-4214, SQLSTATE=28000> End date and time: 2020/03/18 13:43:54
1. Even though we cleared cache, we noticed it was using the same connection string.
2. Error said Connection authorization failure occurred. Reason: Local security service non-retryable error. ERRORCODE=-4214, SQLSTATE=28000> Looks like Server Encrypt was not set. You need to add a property in the Additional Connection Properties field. This might be new to the DB2 environment
3. Two DB connection profiles with the same name CIT-TIX with different username /password, when trying to publish it was not connecting to the right DB connection profile because of that.
Release : 4.8
Component : CA Test Data Manager
1. Clear browser Cache 2. Delete all stale connections or old connections from the DB connection Profile 3. Recreate a new DB connection profile with the same name and use the new username /password. 4. If Sever is encrypted, use Authentication=SERVER_ENCRPT in the "Additional Connection Properties" 5. Test your connection and Publish the jobs.