Storage Essentials Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

SE 9.3 - Win 2008; Login error: java.sql.SQLException: ORA-28001: the password has expired

Go to Solution
Occasional Advisor

SE 9.3 - Win 2008; Login error: java.sql.SQLException: ORA-28001: the password has expired

Error trying to open Storage Essentials page. This appears to be password expiration/login issue to me. Which account we are talking about here? And if possible, how to reset it ?


We do not seem to have HP SIM running on this server (no connection to 50000 port, and no service running) - is this OK?


HTTP Status 500 -

type Exception report


description The server encountered an internal error () that prevented it from fulfilling this request.


javax.servlet.ServletException: Servlet.init() for servlet appiqServlet threw exception


root cause

javax.ejb.EJBException: null; CausedByException is: Unexpected Error; nested exception is: java.lang.NoClassDefFoundError: Could not initialize class com.appiq.service.base.BeanFactory.getCommandProcessor( com.appiq.client.ControllerServlet.init( ..


From the log file D:\HP\StorageEssentials\logs\appstorm.20111009-201507.log :


Caused by: java.sql.SQLException: ORA-28001: the password has expired

 at oracle.jdbc.driver.T4CTTIoer.processError(
 at oracle.jdbc.driver.T4CTTIoer.processError(
 at oracle.jdbc.driver.T4CTTIoer.processError(
 at oracle.jdbc.driver.T4CTTIfun.processError(
 at oracle.jdbc.driver.T4CTTIoauthenticate.processError(
 at oracle.jdbc.driver.T4CTTIfun.receive(
 at oracle.jdbc.driver.T4CTTIfun.doRPC(
 at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(
 at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(
 at oracle.jdbc.driver.T4CConnection.logon(
 at oracle.jdbc.driver.PhysicalConnection.<init>(
 at oracle.jdbc.driver.T4CConnection.<init>(
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(
 at oracle.jdbc.driver.OracleDriver.connect(
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(


Occasional Advisor

Re: SE 9.3 - Win 2008; Login error: java.sql.SQLException: ORA-28001: the password has expired

This appears due to underlying Oracle 11g's default policy of expiring accounts after 180 days.

Two critical Oracle accounts created/used by Storage Essentials: appiq_system with default password

and report_user appiq  - both accounts expired after 180 days.


We had to reset these accounts in SQLplus:


D:\HP\StorageEssentials\install\database\Oracle> sqlplus


SQL*Plus: Release Production on Tue Oct 11 17:15:30 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Enter user-name: appiq_system
Enter password:


Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production With the Partitioning option


 ** It mentioned something about password expiration in 7 days. So, we changed/reset the password to the same password (so that application will continue to work correctly):


SQL> alter user appiq_system identified by new_password;

SQL> alter user report_user identified by new_password;

SQL> quit


After this was done, the Storage Essentials application started working again.


Thanks all

//Add this to "OnDomLoad" event