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

 NAGA RAMU GOTTAM (NAGARAMU)
COFORGE
Lead System Architect
COFORGE
GB
NAGARAMU Member since 2015 6 posts
COFORGE
Posted: Sep 25, 2019
Last activity: Sep 25, 2019
Posted: 25 Sep 2019 7:10 EDT
Last activity: 25 Sep 2019 9:34 EDT
Closed

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****

To see attachments, please log in.
Pega Platform
Low-Code App Development

Posted: 5 years ago
Posted: 25 Sep 2019 7:22 EDT
Sravani Mojjada (mojjs)
PEGA
Senior Engineer, Technical Support
Pegasystems Inc.
IN

Hi, 

Can you send the stacktrace of error for debugging. 

Also refer to these articles and implement changes mentioned and check. 

https://community.pega.com/support/support-articles/there-are-large-number-sql-timeout-errors-mssql

 

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