WebSphere Application Server & Liberty

 View Only
Expand all | Collapse all

Why is the WebSphere Application Server v8.5.5.x messaging engine failing with DSRA9534E error?

  • 1.  Why is the WebSphere Application Server v8.5.5.x messaging engine failing with DSRA9534E error?

    Posted Thu April 04, 2024 02:35 PM

    My WebSphere Application Server v8.5.5.24 messaging engine fails to start and I see the following error in the SystemOut.log:

    CWSIS1501E: The data source has produced an unexpected exception: java.sql.SQLException: DSRA9534E: JMS failed to get an optimized connection.
    The jmsOnePhaseOptimization datasource checkbox must be checked.WTRN0074E: Exception caught from before_completion synchronization operation: com.ibm.ws.sib.msgstore.MessageStoreRuntimeException: CWSIS1002E: An unexpected exception was caught during transaction completion. Exception: com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The data source has produced an unexpected exception: java.sql.SQLException: DSRA9534E: JMS failed to get an optimized connection.
    The jmsOnePhaseOptimization datasource checkbox must be checked. at com.ibm.ws.sib.msgstore.transactions.MSDelegatingLocalTransactionSynchronization.beforeCompletion(MSDelegatingLocalTransactionSynchronization.java:141) at com.ibm.ws.sib.api.jmsra.impl.JmsJcaManagedConnectionSynchronizationProvider$JmsJcaSynchronization.beforeCompletion(JmsJcaManagedConnectionSynchronizationProvider.java:281) at com.ibm.tx.jta.impl.RegisteredSyncs.coreDistributeBefore(RegisteredSyncs.java:291) at com.ibm.ws.tx.jta.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:153) at com.ibm.ws.tx.jta.TransactionImpl.prePrepare(TransactionImpl.java:2442) at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:632) at com.ibm.tx.jta.impl.TransactionImpl.processCommit(TransactionImpl.java:1030) at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:964) at com.ibm.ws.tx.jta.TransactionImpl.commit(TransactionImpl.java:3790) at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:439) at com.ibm.tx.jta.impl.TranManagerSet.commit(TranManagerSet.java:191) at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:949) at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:262) at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:569) at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4500) at com.ibm.ws.ejbcontainer.mdb.MessageEndpointHandler.afterDelivery(MessageEndpointHandler.java:1544) at com.ibm.ws.ejbcontainer.mdb.MessageEndpointHandler.invokeMessageEndpointMethod(MessageEndpointHandler.java:872) at com.ibm.ws.ejbcontainer.mdb.MessageEndpointHandler.invoke(MessageEndpointHandler.java:833) at com.sun.proxy.$Proxy27.afterDelivery(Unknown Source) at com.ibm.ws.sib.ra.inbound.impl.SibRaTransactionalDispatcher.afterDelivery(SibRaTransactionalDispatcher.java:517) at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:931) at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:597) at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:670) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)Caused by: com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The data source has produced an unexpected exception: java.sql.SQLException: DSRA9534E: JMS failed to get an optimized connection.  The jmsOnePhaseOptimization datasource checkbox must be checked. at com.ibm.ws.sib.msgstore.persistence.impl.BatchingContextImpl.executeBatch(BatchingContextImpl.java:311) at com.ibm.ws.sib.msgstore.persistence.impl.PersistentMessageStoreImpl.beforeCompletion(PersistentMessageStoreImpl.java:1208) at com.ibm.ws.sib.msgstore.transactions.MSDelegatingLocalTransactionSynchronization.beforeCompletion(MSDelegatingLocalTransactionSynchronization.java:129) ... 23 moreCaused by: java.sql.SQLException: DSRA9534E: JMS failed to get an optimized connection.  The jmsOnePhaseOptimization datasource checkbox must be checked. at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:801) at com.ibm.ws.sib.msgstore.persistence.impl.WASDatasourceWrapper$1.run(WASDatasourceWrapper.java:394) at com.ibm.ws.sib.msgstore.persistence.impl.WASDatasourceWrapper$1.run(WASDatasourceWrapper.java:389) at com.ibm.ws.sib.security.impl.BusUtilities.doInBusDomain(BusUtilities.java:159) at com.ibm.ws.sib.security.impl.BusSecurityImpl.doAsBus(BusSecurityImpl.java:675) at com.ibm.ws.sib.msgstore.persistence.impl.WASDatasourceWrapper.getLockConnection(WASDatasourceWrapper.java:408) at com.ibm.ws.sib.msgstore.persistence.impl.WASDatasourceWrapper.getConnection(WASDatasourceWrapper.java:362) at com.ibm.ws.sib.msgstore.persistence.impl.DatasourceController.performAction(DatasourceController.java:519)

    How can I fix the error?



    ------------------------------
    Sai Vamsi Gude
    ------------------------------


  • 2.  RE: Why is the WebSphere Application Server v8.5.5.x messaging engine failing with DSRA9534E error?
    Best Answer

    Posted Thu April 04, 2024 02:36 PM

    To fix the error:

    1.Either configure the messaging engine to use a xa-capable datasource(Recommended)

    OR

    2.Enable the "Enable JMS one-phase optimization support" checkbox on the datasource used by the messaging engine
    https://www.ibm.com/docs/en/was/8.5.5?topic=cdsuac-websphere-application-server-data-source-properties


    Additional details on the jmsOnePhaseOptimization feature:
    https://www.ibm.com/docs/en/was/8.5.5?topic=ads-sharing-connections-benefit-from-one-phase-commit-optimization-1



    ------------------------------
    GEETA NADELLA
    ------------------------------