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.
Release : 4.8
Component : CA Test Data Manager
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.
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