When Login To Web Client, Get Error "The Session Has Been Terminated. Please Login Again." (Doc ID 1638720.1)

Last updated on JUNE 25, 2017

Applies to:

Oracle Agile PLM Framework - Version 9.3.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.3.1.2 version, when attempting to login Agile WebClient,
the following error occurs.

ERROR
The Session Has Been Terminated. Please Login Again

ERROR LOG
java.lang.NullPointerException

at com.agile.util.sql.LocalConnectionFactory.getJDBCConnection(LocalConnectionFactory.java:82)
at com.agile.util.sql.ConnectionFactory.getConnection(ConnectionFactory.java:37)
at com.agile.admin.security.userregistry.DBUserAdapter.getConnection(DBUserAdapter.java:203)
at com.agile.admin.security.userregistry.DBUserAdapter.checkPassword(DBUserAdapter.java:56)
at com.agile.admin.security.weblogic.WLSLoginModule.validate(WLSLoginModule.java:375)
at com.agile.admin.security.weblogic.WLSLoginModule.login(WLSLoginModule.java:166)

Cookie:
JSESSIONID=GNvkTNMJGvP10swTHYFxQSphymcR1rWHtyTnrJqr2J8J1rlbKHr4!284310265!1024205145;
j_password=xxx;
j_username=4839C73859281CD3;

]", which is more than the configured time (StuckThreadMaxTime) of "1,200" seconds. Stack trace:
java.net.SocketInputStream.socketRead0(Native Method)
...
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
com.agile.report.server.usage.UserUsageHandler.logout(UserUsageHandler.java:160)
...
com.agile.pc.cmserver.pcmhelper.PCMHelperSessionBean.logoutUser(PCMHelperSessionBean.java:336)
...
com.agile.ui.pcm.login.LoginHandler.logout(LoginHandler.java:1713)


STEPS
The issue can be reproduced at will with the following steps:
1. Open Internet Explorer and visit the Agile WebClient URL
2. Login as any active user
3. User will get error sometime "The Session Has Been Terminated. Please Login Again."


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms