Question

2
Replies
124
Views
NAGARAMU Member since 2015 5 posts
INCESSANT TECHNOLOGIES (UK) PVT LTD
Posted: 10 months ago
Last activity: 10 months 1 week ago

Issue with saving rule in 8.3

Webserver: Tomcat

Database: SQLServer

Issue:

When saving the rule, the query is driving to db but no response receiving from DB. This happening after upgrading from 8.2.2 to 8.3.

Query (attached) been running long hours with 4.4 million cycles of CPU, 65 million IO operations . It's causing all the other App spids to block behind it.

SELECT 4423823 65479286 09/25 00:34:09 Microsoft JDBC Driver for SQL Server 108 0

Exception in Logs:com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code : 0 SQLState: HY008 Message: The query has timed out

What could be the actual problem? Please help.

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Low-Code App Development
Share this page LinkedIn