TDM Portal mouse over column shows wrong data type for Integer on SQL Server

book

Article ID: 111163

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Customer cursors over a table in SQL server that was created from XSD. When the user does this it says its an NVARCHAR etc and when they go into the painter it says its an integer. Data maker is also showing it is nvarchar. Are we storing these as nvarchar and XSD rule?

Environment

TDM 4.5
Web Portal

Resolution

We need to differentiate between 2 datatypes in Portal when it comes to XSD files:
 
  1. The data types shows on the Data Generation window (when a user hovers over a column name).
 

<Please see attached file for image>

 As you can see here, the datatype is nvarchar. This is just the way the derived table (from the XSD file) is stored in the Repo DB.
 
  • As you can see here, the datatype is nvarchar. This is just the way the derived table (from the XSD file) is stored in the Repo DB.
 
  1. The data types shows in the Data Painter window.
 

<Please see attached file for image>

As for the Data Painter window, this is where the actual data types (which were defined in the XSD file) are being enforced. Here: a. Datatype is string (as I defined it in the XSD file). It’s not nvarchar anymore. b. A Male/Female rule is being enforced.  • When I validated the string “XYZ”, an error is show saying that only “Male” or “Female” are accepted as strings.
 
 
As for the Data Painter window, this is where the actual data types (which were defined in the XSD file) are being enforced. Here:
  1. Datatype is string (as I defined it in the XSD file). It’s not nvarchar anymore.
  2. A Male/Female rule is being enforced.
    • When I validated the string “XYZ”, an error is show saying that only “Male” or “Female” are accepted as strings.

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

Attachments

1558697482613000111163_sktwi1f5rjvs16iyt.png get_app
1558697480617000111163_sktwi1f5rjvs16iys.png get_app