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

Document ID : KB000111163
Last Modified Date : 15/08/2018
Show Technical Document Details
Issue:
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).
 
 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.
 
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