WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 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
    ------------------------------