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

SOLVED
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

message

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

exception

javax.servlet.ServletException: Servlet.init() for servlet appiqServlet threw exception
	org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:150)
	org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
	org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:54)
	org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:139)
	org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
	java.lang.Thread.run(Thread.java:662)

 

root cause

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

 

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(T4CTTIoer.java:439)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)
 at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564)
 at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
 at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
 at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)
 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:151)

 

1 REPLY
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

U:\>sqlplus

SQL*Plus: Release 11.2.0.1.0 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 11.2.0.1.0 - 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