Question

4
Replies
52
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 215 posts
Anthem
Posted: December 24, 2018
Last activity: December 28, 2018
Closed

Load Test dead lock queries @ pc_assign_worklist.

Hi Team,

Deadlock queries has been obtained on regular basis @ pc_assign_worklist during the load test.

PFB for the list of deadlock queries.

1) Database update took more than the threshold of 500 ms: 2,422 ms SQL: delete from dbo.pc_assign_worklist where pzInsKey = ? inserts:

2) Database update took more than the threshold of 500 ms: 2,232 ms SQL: INSERT INTO dbo.pc_assign_worklist (pzInsKey , pxCommitDateTime , "ElapsedWL" , "Level" , "Market" , "MethodOfReceipt" , "ParentCaseID" , "Priority" , "ReceivedDate" , "RequestType" , "Type" , "UrgencyLevel" , "WOID" , "WOStatus" , "pxApplication" , "pxAssignedOperatorID" , "pxAssignedOrg" , "pxAssignedOrgDiv" , "pxAssignedOrgUnit" , "pxAssignedUserName" , "pxCreateDateTime" , "pxCreateOpName" , "pxCreateOperator" , "pxCreateSystemID" , "pxDeadlineExecute" , "pxDeadlineTime" , "pxFlowInsKey" , "pxFlowName" , "pxGoalExecute" , "pxGoalTime" , "pxInsName" , "pxLateTime" , "pxObjClass" , "pxRefObjectClass" , "pxRefObjectInsName" , "pxRefObjectKey" , "pxRefQueueKey" , "pxSaveDateTime" , "pxServiceLevelName" , "pxStageID" , "pxStageLabel" , "pxSystemFlow" , "pxTaskLabel" , "pxTaskName" , "pxTimeFlowStarted" , "pxUpdateDateTime" , "pxUpdateOpName" , "pxUpdateOperator" , "pxUpdateSystemID" , "pxUrgency" , "pxUrgencyAssign" , "pxWorkGroup" , "pyActionTime" , "pyAssignmentStatus" , "pyEffortActual" , "pyErrorAssignment" , "pyErrorMessage" , "pyErrorStep" , "pyFlowInError" , "pyFlowType" , "pyInstructions" , "pyInterestPageClass" , "pyLabel" , "pyProcessOnNode" , "pyResolutionCost" , pzPVStream) VALUES (? , CURRENT_TIMESTAMP , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) inserts: > > > > > > > > > > > > 2018-12-22 19:19:12.734> > > > > > > 2018-12-22 19:19:12.739> > > > Auth Review> 2018-12-22 19:16:40.631> > > > > > 10> > > > > > > > Auth Requirements> > > [B@4f88f0d2>

3) Database operation took more than the threshold of 500 ms: 2,796 ms SQL: SELECT "PC0"."pxUrgencyAssign" AS "pxUrgencyAssign" , "PC0"."pxRefObjectInsName" AS "pxRefObjectInsName" , "PC0"."pyLabel" AS "pyLabel" , "PC0"."pyAssignmentStatus" AS "pyAssignmentStatus" , "PC0"."pyInstructions" AS "pyInstructions" , "PC0"."pyAssignmentStatus" AS "pyAssignmentStatus" , "PC0"."pxDeadlineTime" AS "pxDeadlineTime" , "PC0"."pxAssignedOperatorID" AS "pxAssignedOperatorID" , "PC0"."pxUpdateOperator" AS "pxUpdateOperator" , "PC0"."pxUpdateDateTime" AS "pxUpdateDateTime" , "PC0"."pxGoalTime" AS "pxGoalTime" , "PC0"."pxCreateOpName" AS "pxCreateOpName" , "PC0"."pxCreateDateTime" AS "pxCreateDateTime" , "PC0"."pxTaskLabel" AS "pxTaskLabel" , "PC0"."pxAssignedUserName" AS "pxAssignedUserName" , "PC0"."pxRefObjectClass" AS "pxRefObjectClass" , "PC0"."pyAssignmentStatus" AS "pyAssignmentStatus" , "PC0"."pzInsKey" AS "pzInsKey" FROM dbo.pc_assign_worklist "PC0" WHERE ( ( "PC0"."pxAssignedOperatorID" = ? AND ( "PC0"."pxRefObjectClass" = ? OR "PC0"."pxRefObjectClass" = ? OR "PC0"."pxRefObjectClass" = ? ) ) OR ( "PC0"."pxAssignedOperatorID" = ? AND "PC0"."pyAssignmentStatus"

Please suggest.

Low-Code App Development DevOps Testing Applications System Administration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.