search cancel

TDM is getting error sending data to ALM

book

Article ID: 189193

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When a tester clicks on the button in ALM that activates the TDM code to call TDM that part works and the tester can go through those screens.  However after the TestMatch is completed an extra job ATTACH_TM_RESULTS pops up and is getting the following error:

Error occured while processing file. Exception : Error occured while calling GetTestMatchSummaryDataStart. Exception Information: Operation: GetTestMatchSummaryDataStart: Connection profile not found or stored password not set on profile.Ending GT ALM Batch Process at: 

 

Cause

The cause is most likely related to the user not being able to access the connection profile. To better understand what is going on, we need to place the TDoD (GTService) in debug mode and recreate the issue.

The tdod.log shows:
2020-04-17 13:08:08,900 [3] INFO  GTWCF.Repository - GetStoredConnectionProfiles sProfile = TDMDM  iSUID=1300
2020-04-17 13:08:08,900 [3] INFO  GTWCF.Repository - GetStoredConnectionProfiles sQuery = select distinct prof_name,       prof_dbms,       prof_database,       prof_servername,       prof_dbparm,       prof_userid,       prof_password,       prof_connectiontype,       prof_desc,       prof_db_dbms,       prof_schema,       prof_store_password,       coalesce (prof_sg_id, -1) from  gtrep_profile where (prof_su_id = @SU_ID OR prof_sg_id IN (SELECT sug_sg_id                   FROM gtrep_security_usergroup                   WHERE sug_su_id = @SU_ID)) and prof_name = @sProfile
 
2020-04-17 13:08:08,916 [3] INFO  GT.TDMoD.Services.Databases.DatabaseAccessor - ExecuteQuery sSQL=select distinct prof_name,       prof_dbms,       prof_database,       prof_servername,       prof_dbparm,       prof_userid,       prof_password,       prof_connectiontype,       prof_desc,       prof_db_dbms,       prof_schema,       prof_store_password,       coalesce (prof_sg_id, -1) from  gtrep_profile where (prof_su_id = @SU_ID OR prof_sg_id IN (SELECT sug_sg_id                   FROM gtrep_security_usergroup                   WHERE sug_su_id = @SU_ID)) and prof_name = @sProfile

2020-04-17 13:08:08,916 [3] INFO  GT.TDMoD.Services.Databases.DatabaseAccessor - ExecuteQuery >> ExecuteReader
2020-04-17 13:08:08,932 [3] ERROR GTWCF.GTService - Error occured in GetTestMatchSummaryDataStart
2020-04-17 13:08:08,932 [3] ERROR GTWCF.GTService - Exception Message Connection profile not found or stored password not set on profile.

Environment

Release : 4.8

Component : CA Test Data Manager - TDM Web Portal

Resolution

The error as suspected was caused by the user 1300 not having the access to the connection profile TDMDM.

Additional Information

How to enable debugging for Test Data Manager on Demand (TDoD)
https://knowledge.broadcom.com/external/article?articleId=38921