search cancel

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 it's an NVARCHAR etc and when they go into the painter it says it's an integer.
Datamaker is also showing it is nvarchar.
Are we storing these as nvarchar and XSD rule?

Environment

TDM 4.5
Web Portal
test Data Manager

Resolution

We need to differentiate between 2 datatypes in Portal when it comes to XSD files:
 

  1. The data types show on the Data Generation window (when a user hovers over a column name).

  • 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.


 

 

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.

Attachments

1558697482613000111163_sktwi1f5rjvs16iyt.png get_app
1558697480617000111163_sktwi1f5rjvs16iys.png get_app