Getting invalid connection profile string for Oracle

Products

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

Issue/Introduction

When a connection profile for Oracle is created, TDM (Portal) automatically adds the string DelimitIdentifier='NO' to the addition parameter field. After upgrading this string is being appended to the connection string and causing the masking job to fail. This problem started to occur after upgrading to 4.10. In previous release the string was there but the Portal was not adding it to the connection string

Seen latest on 4.10.81

Masking logs show below error:

[INFO ] [SimpleAsyncTaskExecutor-2] --- [U:][M:][P:]                      c.c.t.f.s.CallFastDataMasker:  runFDM: job: 5262: fdm#: 0 state: FAILED schema: E.TRAVEL errors: (1) E.TRAVEL: Connection error: java.sql.SQLRecoverableException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Environment

Release : 4.10

Component : TDM Web Portal

Cause

Product Defect

Resolution

This issue has been fixed in version 4.10.90 and later

Test Data Manager (TDM) Support Patches

To apply the patch build follow:

How to apply patches for TDM