RIB-RMS Publishers Down With XAConnection Error
(Doc ID 2981880.1)
Last updated on OCTOBER 20, 2023
Applies to:
Oracle Retail Integration Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
RIB-RMS publishers were down with below error and user manually started the publishers .
ERROR
-----------------------
We could see the below error in the adapter logs.
2023-09-25 02:25:02,439 ERROR [Timer-38] impl.GetNextPublisherEjb (GetNextPublisherEjb.java:194) - Rolling back the transaction.
java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource 'rib-rms-managed-datasource_RIBDomain': XAER_RMFAIL : Resource manager is unavailable
javax.transaction.xa.XAException: Unexpected error during start for XAResource 'rib-rms-managed-datasource': XA error: oracle.jdbc.xa.OracleXAException: XAErr (-7): Resource manager is unavailable. ORA-17410 SQLErr (0): OracleError = 17410; OracleSQLError = 0; XAError = -7: XAErr (-7): Resource manager is unavailable. ORA-17410 SQLErr (0)
at weblogic.jdbc.wrapper.XA.createException(XA.java:109)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Check the status of adaptors
2. If adaptors went down check adaptors logs
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, adaptors were down and user has to manually started the adaptors to bring back
Changes
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 |