"ORA-28001: the password has expired" error while connecting to the GTREP repository database

Products

• CA Test Data Manager (Data Finder / Grid Tools)
• CA Agile Requirements Designer

Issue/Introduction

 "ORA-28001: the password has expired" error is seen while connecting to the Oracle repository database with the GTREP credentials.

(Please note that GTREP is the default username for connecting to the TDM gtrep repository database. In your environment, this username may be different)

Environment

 

Release : ARD 3.x, FDM all releases, TDM 4.8+ with Oracle GTREP Repository Database

Component : CA Agile Requirements Designer, GT Datamaker, FastDataMasker, TDM Portal

 

Cause

This issue is most likely happening because the Oracle password for the GTREP user has expired and needs to be reset.

The cause can be verified by connecting to the repository instance from command-line SQLPLUS.

For example, from the command prompt, run:

SQLPLUS GTREP/[email protected]

In this example the username and password are GTREP, and the Oracle Net service name is "XE".

Running this command should also give the same error message:

"ORA-28001: the password has expired"

Resolution

If you are experiencing this issue in a production or multi-user environment, please consult with your Oracle DBA for assistance with resetting the password for the GTREP (or appropriate) user, which is the credential to connect to the TDM repository DB.

If you are facing this issue with a non-production, personal copy of Oracle XE (or similar) database, and have the necessary approval to make administrative changes on the Oracle server, please follow these steps to reset the password for the GTREP user. You need the "SYSTEM" (or SYS) user credentials to reset the password.

 

1. From a Windows command-prompt, run the following command:
   
   sqlplus system/<password>@XE
   
        where XE is your Oracle Service Name
   
   You should see the SQL> prompt.
   
   
2. Reset the password of the GTREP user by the following command:
   
   ALTER user GTREP identified by <password>;
   
   Use the same password as earlier (that was indicated as expired) if you do not wish to change your configurations for  TDM Portal (application.properties), GT Datamaker connection profile, TDoD (GT Service) & Remote Publish services, and ARD "TDM Repository" Connection profile.
   
   
3. Use these two commands to ensure that the password does not expire in the future:
   
   • SELECT USERNAME, PROFILE from dba_users where username = 'GTREP';
     
     Suppose the "Profile" value returned is "DEFAULT". Next, run this SQL command:
     
     
   • ALTER PROFILE DEFAULT limit password_life_time UNLIMITED;
     
     Note: If a profile, other than DEFAULT, was returned in the previous step, replace the value "DEFAULT" appropriately in the above SQL.

Additional Information

If you are still experiencing issues, please open a support case by going to https://support.broadcom.com or call [phone]