CA TDM Portal Find and Reserve SQL Server Data Type Error: Failed to register Data Model tables

book

Article ID: 130157

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Create Model or Create Legacy Model via CA TDM portal – Modeling – Find & Reserve caused the following error.

" Failed to register Data Model tables 
500: Server encountered an error processing the request. See server logs for more details " 

TDMDataReservation.log 

[M:POST][P:/api/ca/v1/testDataModels/315/associations] c.c.t.d.c.AssociationController: Bad request 
com.ca.tdm.common.exception.BadRequestException: Data types for the join fields 'uniqueidentifier', 'uniqueidentifier' do not match. 

[M:POST][P:/api/ca/v1/testDataModels] c.c.t.d.g.GraphAPIHelper: Exception in a transaction. Transaction rolled back. 
com.ca.tdm.common.exception.ResourceConflictException: Test Data Model with the name tfcdemotest already exists.

Cause

We support uniqueidentifier as an attribute entity. However there is a bug in the product where we did not take it into account when linking tables using uniqueidentifiers 

Environment

TDM Portal 4.6

Resolution

We support uniqueidentifier as an attribute entity. However there is a bug in the product where we did not take it into account when linking tables using uniqueidentifiers
TDMWeb-4.6.45.0.zip resolves this issue.  Please contact BC Support to get this version or a later version.  If you are getting a GA built after March 27, 2019, pleases verify with BC Support if this fix made it into that GA version.