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

Article Id: 110973

Status: Published

Updated On: 06-12-2019 15:46

Products:

CLARITY PPM FOR ITG , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM

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.