search cancel

TDM Portal error: Failed to get Data Model tables ro register - 500: SQL Exception: The connection is closed.

book

Article ID: 254068

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After a PII Scan, trying to "Register Data Model Tables" meets with the error:

Failed to get Data Model tables ro register
500: SQL Exception: The connection is closed.


The issue seems to be that the error occurs when the _backup tables are in the database.  Remove those tables and do not get the error.

The backup tables only have the data, no FKs.  The _backup tables are used for the actual masking.  Have a script that replenishes these tables to retrieve production data and load it into the _backup tables.

https://api-broadcom-ca-user.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=DRD2Ym9uOp5bNP7HugQPmQ==

 

https://api-broadcom-ca-user.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=spxe/hujbbjiKtPjaetSkQ==

Environment

Release : 4.10.121.0

TDM Portal

Cause

Product defect.

Resolution

We have a fix for this issue. TDMWeb-4.10.124.0.zip.