Support Article

JMS MDB CMT causes exceptions



The service activity run through MDB CMT will cause the exceptions shown below.

Error Messages

2016-10-18 09:44:19,930 ... (rnal.access.DBLockProviderImpl) ERROR ...... - Problem executing quick lock delete: The query was canceled. Problem executing quick lock delete: The query was canceled.: code: 0 SQLState: HY008 Message: The query was canceled.
DatabaseException caused by prior exception: The query was canceled.
| SQL Code: 0 | SQL State: HY008

Steps to Reproduce

Run specific MDB listener in CMT

Root Cause

A defect or configuration issue in the operating environment.


Make the following change to the operating environment: 

XA jdbc driver needs to be used to support MDB CMT. Also make sure to follow the Microsoft documentation for Sqlserver specific configuration for XA support.

Published November 11, 2016 - Updated November 19, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.