Clarity PPM: Load DWH job fails with ORA-28000 error

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The following Oracle error is in the BG-DWH logs:

ORA-28000: the account is locked

Cause

The database user password was entered incorrectly for the maximum number of times specified by the profile parameter FAILED_LOGIN_ATTEMPTS,
or the DBA has locked the account

 

Resolution

Please have the DBA team review the schema user to check the reason why it locked and to unlock.