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


Release : 4.8

Component : CA Test Data Manager


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. 


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.