Question

1
Replies
31
Views
Close popover
Sai Prakash Gundu (SaiPrakashG)
Incessant

Incessant
IN
SaiPrakashG Member since 2015 4 posts
Incessant
Posted: 1 week 3 days ago
Last activity: 2 days 11 hours ago
Solved

Users acquiring lock on FW-Work class instance

We are facing an issue in production where oftentimes users are acquiring lock on ORG-FW-AppFW-Work class instance (we do have a blank instance in this class with pzInskey = "NBFC-FW-UWWBFW-Work"). Due to this other users were unable to create any new case until the lock on this instance is released from system locks.

We do verified the logs at the time of instance is locked and below is the exception reported every time. There were few HFixes suggested in pega community to resolve the below timeout exception. However firstly I'm not sure whether this exception can result in acquiring the lock on FW class instance. Please share your thoughts.

[jsse-nio-443-exec-25] [  STANDARD] ( rd.queryexec.SqlQueryExecutor) An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out. DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.  | SQL Code: 0 | SQL State: HY008

User lock on FW class

***Edited by Moderator: Pooja Gadige to add platform capability tag***
Pega Underwriting for Insurance 7.4 Project Delivery Case Management Insurance System Architect