TDM: The variable did not carry over the fixed value, it returned the DM default value of ‘N’ – this was not expected

book

Article ID: 74968

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Ran a quick test setting the flags like
Variable = checked
Use in TDOD = NOT
checked Fixed = checked
Resolve = checked With a value of ‘Y’
When I ran the publish The variable did not show on the screen – this was expected The variable did not carry over the fixed value, it returned the DM default value of ‘N’ – this was not expected.  The end results were not consistent with what I set when I ran the publish:

This appears to be a coding issue.  Is there a fix?

Cause

Error that was corrected in the program.

Environment

TDM 4.3

Resolution

New version for the Portal that contains this enhancement. TDMWeb-4.3.311.0.zip

You need to add 3 new columns to gtrep_publish_config_table table

ALTER TABLE gtrep_publish_config_table
ADD pct_tgt_profile nvarchar(254),
ADD pct_tgt_schema nvarchar(254),
ADD pct_tgt_table nvarchar(254);

Please contact Support for the fix if you run into this issue.  It will be in future GA builds after April 15.

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