TDM: Dynamic record count issue

Document ID : KB000110230
Last Modified Date : 09/08/2018
Show Technical Document Details
Issue:
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.   It seems to pick up the last value.  Is it being cached somewhere?
Environment:
TDM 4.5 Portal
Resolution:
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~)^
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://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html