Unable to create Data Model for a specific connection

Products

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

Issue/Introduction

Trying to create a data model and do a PII audit scan for a specific connection but getting the error:

Failed to scan entities for profile NAME_XX, reason: TDMDatabaseException: failed to open connection profile: Failed to scan entities for profile NAME_XX, reason: TDMDatabaseException: failed to open connection profile: NAME_XX: RuntimeException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied : Exception raised: TDMDatabaseException: failed to open connection profile: NAME_XX: RuntimeException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied : RuntimeException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied : Exception raised: TDMDatabaseException: failed to open connection profile: NAME_XX: RuntimeException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied 

Environment

TDM 4.6

Cause

DB password change caused the issue.

Resolution

Changing the password and restarting the TDM Portal service should resolve the issue.