TDM: Dynamic record count issue

book

Article ID: 110230

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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