ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

TDMServiceException: execsqlcount: TDMServiceException-DBConnection Profile

book

Article ID: 186852

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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][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

Cause


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. 

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution


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.