CSV imported relations not translated to Diagrammer

Document ID : KB000009152
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When table relationships are created by importing from CSV, the relationships are shown in Datamaker. However when showing the tables in Diagrammer, the table relationships are not shown. 

Environment:
GT Datamaker 4.0
Cause:

Steps taken to test: 
1. Registered tables in Datamaker and imported relationships using CSV from Project > Table Relationships > Import Relationships from file.
2. Verified relationships exist in Datamaker by viewing table in Actions for registered objects. 
3. Selected tables and Open Tables in GTDiagrammer. 
4. Relationships do not exist between tables. 

Testing if relationships are translated to Diagrammer:
1. Created new version in project and registered same tables. 
2. Created relationships by adding manually to tables. 
3. Verified relationships exist in Datamaker by viewing table in Actions for registered objects. 
3. Selected tables and Open Tables in GTDiagrammer. 
4. Relationships now shown between tables.

rel_namerel_descrel_parent_ownerrel_parent_tablerel_parent_cardinalityrel_parent_sqlrel_child_ownerrel_child_tablerel_child_cardinalityrel_child_sqlrel_child_sqlParent KeyChild Key
fkAbcSvcInfClmdboClaimerZERO_OR_ONE dboHospitalSvcInformationZERO_OR_MORE 1ClaimSIDClaimSID
fkAbcSvcInfSLdboServiceLineZERO_OR_ONE dboHospitalvcInformationZERO_OR_MORE 1ServiceLineSIDServiceLineSID
fkClmAdjCOBInfdboCOBInformationONE dboClaimAdjustmentZERO_OR_MORE 1COBInformationSIDCOBInformationSID
Resolution:

It turns out that the table names in mixed-case caused the problem. If the table names are changed to either uppercase or lowercase, then it works.  The fix for upper and lower case names is in GTDataMakerPB-4.0.100.25.zip. Please contact CA Support to obtain this patch. You can open a case following this video. Ask support to determine if this patch is in the latest GA version of software delivered after June 13, 2017.  If one could not be included, CA Support team will work with you and development to make sure this fix can be adapted to your environment and specific version if appropriate.

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