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

Document ID : KB000130157
Last Modified Date : 27/03/2019
Show Technical Document Details
Issue:
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.
Environment:
TDM Portal 4.6
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 
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.