GTREP_owner schema is not resolving the through 4.8 TDM Portal.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Existing code is not working in TDM portal v 4.8.219.0

~USER_EMAIL~ =  @execsql(R,select SU_EMAIL from GTREP_SECURITY_USER where SU_NAME ='~USER~')@

The variable mentioned above is working in Datamaker.  ~USER_EMAIL~   is resolving properly.

The Variable is also resolving in TDM Portal Generator - Variables -> Data Painter, 

but while using the variable in Javelin call it is failing during the Publish in TDM Portal. 

Javelin call -> cmd /c "%ZRD_PATH%\Scripts\Javelin\ReleaseMagentaSIM\ReleaseMagentaSIM.bat ~SIM~ ~TMO_ENV~  ~TEST_ENV~ ~USER_EMAIL~ ~GROUPJOBID~"

 

Error:

2020-10-06 16:25:02 - Executing Step: LogActivity
2020-10-06 16:25:02 - ?DM??DM?
2020-10-06 16:25:02 - Executing Step: SendTestDataReport
2020-10-06 16:25:02 - Error executing SendTestDataReport: The specified string is not in the form required for an e-mail address.

 

 

Cause

 

The  user variable  is resolved to integrator instead of the  right UserID.  This is a known issue with  TestMatch jobs  executed by the TDMLegacyExecterService. The TDMLegacyExecuterService.log indicates a security issue with the 'integrator' user.

 

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

Patch TDMWeb-4.8.222.0  has the fix for this issue.

Please download the latest FDM patch from below link. Install the patch and verify the issue.

https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649