My Oracle Support Banner

All Users Are Unable To Login to Web Client & Java Client - Error: 'Your account is not active. Please contact your PLM Administrator.' (Doc ID 2445756.1)

Last updated on MAY 25, 2020

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

All users are unable to login to Web Client & Java Client

Error
Your account is not active. Please contact your PLM Administrator.

stdout.log
<Sep 6, 2018, 10:34:49,916 AM PDT> <Error> <JTA> <BEA-110412> <Xid=BEA1-070025B80E5119E35F55(304241110),Status=Rolled back. [Reason=Unknown],HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=3600,useSecure=false,activeThread=Thread[Timer-9,1,Pooled Threads],XAServerResourceInfo[ContentDataSource_agileDomain]=(ServerResourceInfo[ContentDataSource_agileDomain]=(state=rolledback,assigned=us05swdplmapp-Agile),xar=weblogic.jdbc.wrapper.JTSEmulateXAResourceImpl@33bd3a85,re-Registered = false),SCInfo[agileDomain+<hostname>-Agile]=(state=rolledback),properties=({weblogic.transaction.assignableOnlyToEnlistingSCs=[ContentDataSource_agileDomain], weblogic.jdbc.remote.ContentDataSource=t3://<hostname>:7001, weblogic.transaction.partitionName=DOMAIN}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescriptor=(CoordinatorURL=<hostname>-Agile+<hostname>:7001+agileDomain+t3+ CoordinatorNonSecureURL=<hostname>-Agile+<hostname>:7001+agileDomain+t3+ coordinatorSecureURL=null, XAResources={eis/oracle/in-memory, WSATGatewayRM_<hostname>-Agile_agileDomain, tangosol.coherenceTxCCI, WLStore_agileDomain__WLS_<hostname>-Agile, ContentDataSource_agileDomain, tangosol.coherenceTx},NonXAResources={})],CoordinatorURL=<hostname>-Agile+<hostname>:7001+agileDomain+t3+) completed heuristically: (ContentDataSource_agileDomain, HeuristicHazard, (javax.transaction.xa.XAException: Two rollbacks failed. The first one threw No more data to read from socket. The second one threw No more data to read from socket)) .>

stderr.log
java.sql.SQLException: Invalid column name
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:5690)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:647)
at oracle.jdbc.driver.GeneratedResultSet.getInt(GeneratedResultSet.java:3735)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_ForwardOnlyResultSet.getInt(Unknown Source)
at com.agile.pc.cmserver.base.BaseUserDAO.setBasicUserInfo(BaseUserDAO.java:458)
at com.agile.pc.cmserver.user.UserDAO.getUserInfo(UserDAO.java:3726)
at com.agile.pc.cmserver.user.UserDAO.getUserProfile(UserDAO.java:587)
at com.agile.pc.cmserver.user.UserService.getUserInfo(UserService.java:4726)
at com.agile.pc.cmserver.user.UserCoverPageDAO.loadTable(UserCoverPageDAO.java:78)
at com.agile.pc.cmserver.base.BaseCache.loadVOTable(BaseCache.java:318)
at com.agile.pc.cmserver.user.UserCache.getUserProfile(UserCache.java:237)
at com.agile.pc.cmserver.base.BaseUserService.getUserProfile(BaseUserService.java:371)
at com.agile.pc.cmserver.base.AUser.getAllowEscalations(AUser.java:35)
at com.agile.pc.cmserver.notification.ChangeHistoryService.processEscalation(ChangeHistoryService.java:960)
at com.agile.pc.cmserver.notification.ChangeHistoryService.processEscalations(ChangeHistoryService.java:707)
at com.agile.pc.cmserver.notification.NotifyTask.processEscalations(NotifyTask.java:723)
at com.agile.pc.cmserver.notification.NotifyTask.run(NotifyTask.java:503)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)


Steps
The issue can be reproduced at will with the following steps:
1. Login to Web Client & Java Client
2. Get error message:  "Your account is not active. Please contact your PLM Administrator."

Changes

Refreshing an Agile 9.3.6 instance

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.