NullPointerException error when using sql query to assign variable

book

Article ID: 130843

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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.

Error Reported:

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:
@element(~LD_DESC~,~SPACE~,1)@

*~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.
 

Cause

It is an error.

Environment

4.7

Resolution

This has been resolved in TDMWeb-4.7.92.0.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.

Additional Information

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