Existing code is not working in TDM portal v 220.127.116.11
~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~"
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.
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.
Release : 4.8
Component : CA Test Data Manager
Patch TDMWeb-18.104.22.168 has the fix for this issue.
Please download the latest FDM patch from below link. Install the patch and verify the issue.