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 -
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
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.
The variable had been created twice in the TDM Portal
Component: TDM Web Portal
Test data manager
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.