FDM Masking Fails with 'No TDMAdmin value set' Error on Oracle RDS

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Users attempting to perform masking using an RDP seed list in Fast Data Masker (FDM) 5.0.21 may encounter a failure before the masking job starts. The process terminates with the following error:

No 'TDMAdmin' value set for connection.

This issue typically occurs when using an Oracle RDS database as the Seed Table Database, even if the connection to the database is successful within the FDM tool.

Environment

• Product: CA Test Data Manager (TDM)
• Component: Fast Data Masker (FDM)
• Version: 5.0.21
• Database: Oracle RDS

Cause

A product defect in FDM 5.0.21 prevents the TDMAdmin parameter from being correctly recognized or processed when connecting to Oracle RDS instances, particularly after migration from on-premises to RDS where metadata case-sensitivity may differ.

Resolution

A fix has been released in FastDataMasker-5.0.27.0.

Steps to Resolve:

1. Navigate to the Test Data Manager (TDM) Support Patches page.
2. Download the patch: FastDataMasker-5.0.27.0.zip (or .tar.gz).
3. Apply the patch to your FDM installation according to standard update procedures.

Workaround (If Patch Cannot Be Applied Immediately)

If you cannot upgrade immediately, verify the following in your connection file (e.g., connect_RDS_Seed.txt):

1. Manual Parameter Entry: Add TDMAdmin=<schema_name> to the file.
2. Case Sensitivity: For Oracle RDS, ensure the schema name is in UPPERCASE (e.g., TDMAdmin=SCRAMBLE).
3. Parameter Placement: Move the TDMAdmin line to the top of the file, immediately below the password line, to ensure it is processed early.

Note: If these workarounds fail, the 5.0.27.0 patch is required.