I am using a sql query to populate a variable and uses System values (specifically LD_DESC) as default value for a multi-select list. This works in GTDatamaker, but fails in the portal.
NullPointerException error when using sql query to assign variable.
Here is a breakdown of the User Defined and System Defined variables in play:
*REP_KEY_DEF user defined variable expansion:
@execsql(PTDM,SELECT DEF_KEYS FROM TDM_DEF_REPKEYS WHERE USER_ID ='~USER~' AND FLW_NM='@element(~Flw_Nm~,~SPACE~,1)@')@
*~Flw_Nm~ user defined variable expansion:
*~LD_DESC~ - this is the System variable that is not getting resolved and is the NULL POINTER that is returned and referenced in the error message.
It is an error.
This has been resolved in TDMWeb-22.214.171.124.zip. Please contact BC Support for this version or a later one. Please note that this did NOT get into the 4.8 GA Release. If you have a GA Release after 4.8, please verify that this fix made it into it by contacting BC Support.
Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://comm.support.ca.com/kb/How-to-Download-Test-Data-Manager/KB000009671.
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.