ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Load DWH job fails with ORA-28000 error

book

Article ID: 110973

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When the Load Data Warehouse (DWH) job fails, the following Oracle error is in the BG-DWH logs:

ORA-28000: the account is locked

Cause

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

Resolution

Have your DBA team review the schema user to check the reason why the user is locked and unlock the user.

See Change Jaspersoft DB password integrated with Clarity for more details.