Support Article

JMS MDB CMT causes exceptions

SA-30296

Summary



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.
com.pega.pegarules.pub.database.DatabaseException: Problem executing quick lock delete: The query was canceled.: code: 0 SQLState: HY008 Message: The query was canceled.
DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: 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.

Resolution



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.