CA TDM Portal Generator Unable to resolve variable value

Products

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

Issue/Introduction

 

There is a query in my generator that fetches value based on 'client name', 'plan id', and 'participant name'.
All of these refer to its value set in the Variables section. However, recently the query is fetching no value/blank value when the 'Validate' button is clicked.

While testing, it was found that hard-coding the 'plan id' value in the query retrieved the data, but not with the variable which has the same value.

We did more testing with different variables, thinking it could be some problem with the original variable, but still the same issue exists.

So unless we hard-code the value for 'plan id', We're not able to retrieve the column value.

Example Queries in the generator -

@seqlov(0,@sqllist(~v_OLTP_Environment~,
SELECT * FROM BPS.PLAN_PARTICIPANT T1 WHERE T1.CLIENT_ID IN (~v_OLTP_CLIENT_ID~) AND T1.PLAN_ID IN (~V_OLTP_PLAN_ID~) AND T1.PARTICIPANT_ID IN (~v_OLTP_PARTICIPANT_ID~) )@,~COLUMN_NAME~)@ - Does not fetch the value for the column

@seqlov(0,@sqllist(~v_OLTP_Environment~,
SELECT * FROM BPS.PLAN_PARTICIPANT T1 WHERE T1.CLIENT_ID IN (~v_OLTP_CLIENT_ID~) AND T1.PLAN_ID IN ('422020') AND T1.PARTICIPANT_ID IN (~v_OLTP_PARTICIPANT_ID~) )@,~COLUMN_NAME~)@ - retrieves value from source

 

Environment

 

TDM Portal 4.9.1+

Cause

 

The variable had been created twice in the TDM Portal

Resolution

 

Do a select * from gtrep_tilda_vars in the GTREP database.
You should see the variable listed twice.

Do a manual delete of one of the variables from the table.

This will correct the issue.