Error registering multiple tables in TDM Web Portal when manual relationships are present
Article ID: 451802
Updated On:
Products
Issue/Introduction
When attempting to register Data Model tables in the TDM Web Portal, the process fails if the operation involves more than two tables and these tables have manual relationships added.
The following error is observed in the TDMModelService.log: org.hibernate.NonUniqueObjectException: A different object with the same identifier value was already associated with the session
This may also be accompanied by SQL errors related to missing SYSCAT.CHECKS during the metadata retrieval phase.
Environment
- Product: CA Test Data Manager
- Versions: 4.11 and 5.0
Cause
This behavior is identified as a product defect (DE686232) where the relationship handling logic in the ObjectService fails to correctly process multiple tables with manual relationships.
Resolution
Broadcom Engineering has released a fix for this defect. Please apply the following patch to your TDM environment:
- Patch File: TDMWeb-4.11.5058.0.zip
- Patch File: TDMWeb-5.0.60.0.zip
The patches are available for download from the Test Data Manager (TDM) Support Patches page.
Steps to Apply the Fix:
- Download the patch file.
- Apply the patch to your TDM environment following your organization's standard patching procedures for the TDM Web Portal. For specific instruction for applying the patch, see "How to Patch TDM Web Portal".
- Restart the TDM services to ensure the changes take effect.
- Verify that connection profile permissions are being enforced by testing the publishing operation with a restricted user account.
If the issue persists after applying the patch, please open a support case and provide updated server logs for further investigation.
Additional Information
This patch also address the following two defects:
- DE683733 - connection profile permissions ignored during publishing
- DE686390 - column names not visible in related tables drawer
Feedback
