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


Article ID: 110973


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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

ORA-28000: the account is locked


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.


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.