JMS MDB CMT causes exceptions
SummaryThe service activity run through MDB CMT will cause the exceptions shown below.
Error Messages2016-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 ReproduceRun specific MDB listener in CMT
Root CauseA defect or configuration issue in the operating environment.
ResolutionMake 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