Description:
******************************
TDOD tile is not working for dynamic records count in Bulk load wire payment tile
TDOD tile is not working for dynamic records count in Bulk load wire payment tile
We have a CSV file that changes in the number of rows potentially with each run. Say the row counts are 7, 14, 24, 30, 36. When we run it., the first run of 7 - 7 out. Next run with 14 - 7 out. Next run with 24 - 14 out. Next run with 30 - 24 out. Clear the cache - Next run with 36 - 30 out.
******************************
TDMWeb-4.5.28.0.zip resolves the above issue. Please contact CA support to get this or a later version. If getting a GA version after 03 August 2018, please contact CA support to verify that this change made it into the GA version.
Unfortunately, we found that you used the wrong metafunction to generate the number of rows in the iterations section. The link
https://docops.ca.com/ca-test-data-manager/4-5/en/reference/data-generation-functions-and-parameters has a reference to:
COUNTLIST(@SQLLIST(CONNECTION, SQL)@)
Returns the number of rows that are returned by specified SQL query.
Parameters: A SQL query of the following type @SQLLIST(CONNECTION, SQL)@
CONNECTION - Defines the dbms connection type. Choose one of the following:
S - Source
T - Target
Pprofilename - connection profile, for example Pmyconprof.
SQL - A SQL query. Only select statements are supported.
Return value: number of rows returned by the query
Example: @countlist(@sqllist(Ptravel, SELECT * FROM TRAVEL.COUNTRIES)@)@
In addition, we found that you had hardcoded the row number in a variable as opposed to using the actual variable for row number - ^GTMEPY.CUST_NBR(1)^ needs to be modified to ^GTMEPY.CUST_NBR(~PUBROW~)^