TDM: Dynamic record count issue
Article ID: 110230
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?
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~)^
******************************
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.
Feedback
Yes
No
Powered by
