My Oracle Support Banner

エラー: 'Your account is not active. Please contact your PLM Administrator.'にて全てのユーザーがWeb ClientとJava Clientにログインできない (Doc ID 2673603.1)

Last updated on MAY 26, 2020

適用範囲:

Oracle Agile Product Collaboration - バージョン 9.3.6.0 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

全てのユーザーがWeb ClientとJava Clientにログインできない

エラー
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>:7001+agileDomain+t3+ CoordinatorNonSecureURL=<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)

手順
以下の手順で再現します:
1. Web Client や Java Clientにログイン
2. エラー:  "Your account is not active. Please contact your PLM Administrator."

変更点

Agile 9.3.6インスタンスの再構成

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.