Troubleshooting
Problem
During installation verification testing (IVT) of IBM® InfoSphere® Master Data Management (InfoSphere® MDM), a 'Resource manager unavailable' error can sometimes occur. This issue occurs when containerized InfoSphere MDM is deployed on Docker or Red Hat® OpenShift® environments with Oracle Database.
Symptom
The following is an example of the 'Resource manager unavailable' error that can occur as part of this issue:
[6/24/20 7:57:11:488 UTC] 00000157 EmbeddableTra I WTRN0041I: Transaction 00000172E552D88A0000000115200494443873BE8709685AA43D3ED6C2AFF879F9EA3D4900000172E552D88A0000000115200494443873BE8709685AA43D3ED6C2AFF879F9EA3D4900000001 has been rolled back.
[6/24/20 7:57:11:490 UTC] 00000157 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are:
The XA Error is : -7
The XA Error message is : Resource manager is unavailable.
The Oracle Error code is : 17008
The Oracle Error message is: Internal XA Error
The cause is : java.sql.SQLRecoverableException: Closed Connection.
[6/24/20 7:57:11:490 UTC] 00000157 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMFAIL (-7). Exception is: XAErr (-7): Resource manager is unavailable. ORA-17008 SQLErr (0)
[6/24/20 7:57:11:491 UTC] 00000157 XATransaction E J2CA0027E: An exception occurred while invoking end on an XA Resource Adapter from DataSource jdbc/DWLCustomer, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54),
data(00000172e552d88a0000000115200494443873be8709685aa43d3ed6c2aff879f9ea3d4900000172e552d88a0000000115200494443873be8709685aa43d3ed6c2aff879f9ea3d49000000010000000000000000000000000001)} : oracle.jdbc.xa.OracleXAException: XAErr (-7): Resource manager is unavailable. ORA-17008 SQLErr (0)
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1112)
Document Location
Worldwide
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSWSR9","label":"IBM InfoSphere Master Data Management"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.6.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
27 April 2022
UID
ibm16335149