Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 SWASTIK BANERJEE (SWASTIKB)
Cognizant
Technical Lead
Cognizant
IN
SWASTIKB Member since 2014 1 post
Cognizant
Posted: Dec 26, 2019
Last activity: Jan 2, 2020
Posted: 26 Dec 2019 1:14 EST
Last activity: 2 Jan 2020 0:11 EST
Closed

JMS Listener is getting failed in the server side after receiving the request from Client side

We have two separate PEGA instances (Environments:Client and Server side) and corresponding Servers in Microsoft SQL Sever Management Studio having common Customer specific tables. What we do is if there is any change in the data/records available in any of the Customer Tables in one environment/server(client side), we fire a request via Connect JMS so that the changes made to one side are reflected in the other server (server side) as well. Our main purpose over here is to keep all the Customer tables in sync in both of these environments. There is a JMS MDB Listener and a Service JMS which receives the request in the server side, parses the data and saves the data available in the incoming request in the server side customer tables.

For a couple of days we are getting one issue. Whenever the request is getting triggered from the client side (via Connect JMS), the JMS MDB Listener is getting failed and in PEGA logs we can see the below error getting logged in the sever side PEGA instance:

Show More

We have two separate PEGA instances (Environments:Client and Server side) and corresponding Servers in Microsoft SQL Sever Management Studio having common Customer specific tables. What we do is if there is any change in the data/records available in any of the Customer Tables in one environment/server(client side), we fire a request via Connect JMS so that the changes made to one side are reflected in the other server (server side) as well. Our main purpose over here is to keep all the Customer tables in sync in both of these environments. There is a JMS MDB Listener and a Service JMS which receives the request in the server side, parses the data and saves the data available in the incoming request in the server side customer tables.

For a couple of days we are getting one issue. Whenever the request is getting triggered from the client side (via Connect JMS), the JMS MDB Listener is getting failed and in PEGA logs we can see the below error getting logged in the sever side PEGA instance:

2019-12-23 07:09:14,430 [stenerThreadPool : 0] [ STANDARD] [ ] [ ] ( mgmt.base.DatabaseStorage) ERROR - deleteRequestor(): Error while deleting saved context (AOCRLD4VISVNQ8E28ZUA13ANQSB69SYRD)
java.sql.SQLException: DSRA9350E: Operation Connection.commit is not allowed during a global transaction.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1106) ~[com.ibm.ws.runtime.jar:?]
As a result of this the Service JMS is not able to process and parse data and the purpose of performing the sync among the tables between the client and server side is not getting served.
Is there anyone who has earlier faced this issue or got some solution for this?
This has been correctly working for the last 6 months. We have been facing this issue on a daily basis for the last 3 weeks and no recent code changes have been done from PEGA/Application end.

***Edited by Moderator: Lochan to update platform capability tags***


Show Less
To see attachments, please log in.
Data Integration
System Administration

Posted: 4 years ago
Posted: 2 Jan 2020 0:11 EST
SWASTIK BANERJEE (SWASTIKB)
Cognizant
Technical Lead
Cognizant
IN

Hello Pawan,

Thank you for the shared link. We will check this with our infra team.

Thanks and Regards,

Swastik Banerjee

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice