Question

4
Replies
49
Views
PradeepPydi Member since 2017 202 posts
Anthem
Posted: 1 year ago
Last activity: 1 year 7 months ago
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 Low-Code App Development Testing Applications System Administration
Moderation Team has archived post
Share this page LinkedIn