CA TDM Portal Generator Unable to resolve variable value

book

Article ID: 222773

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

I have 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 I click on the 'Validate' button.

When checked, I found that hard-coding Plan id value to the query retrieved the data but not with the variable which has the same value.

I even tried with a different variable, thinking it could be some problem with the original variable, but still the same issue exists.

So unless I hard-code the value for plan id, I'm not able to retrieve the column value.
This wasn't happening earlier and the generator was working fine until a few days ago.

Can you look into this on priority since we are not able to subset until the issue is resolved.

This is the Query 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

Will e-mail you screenshots showing values exist in source, values updated in TDM Portal for Variables and Data generator when it fetches and when it does not fetch the value.

Cause

 

The variable had been created twice in the TDM Portal

Environment

 

TDM 4.9.1

Component: TDM Web Portal
Test data manager

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.