search cancel

TDMServiceException: execsqlcount: TDMServiceException-DBConnection Profile


Article ID: 186852


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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://;user=Maxx: Failed to obtain JDBC Connection; nested exception is [jcc][t4][2010][11246][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.