Question

6
Replies
311
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 214 posts
Anthem
Posted: July 9, 2018
Last activity: May 28, 2019
Closed
Solved

Deadlock Queries @ Production Environment.

Hi Team,

Below mentioned Deadlock Queries has been observed @ Production Environment.

Please suggest.

1) SELECT TOP 1000 [pxAssignedOperatorID] ,[pxObjClass] ,[pxRefObjectClass] ,[pxRefObjectInsName] ,[pxRefObjectKey] ,[pxServiceLevelName] ,[pxUrgencyAssign] ,[pxWorkGroup] ,[pyAssignmentStatus] ,[pyFlowType] ,[pyInstructions] ,[pyLabel] ,[pzInsKey] ,[pxApplication] ,[Market] ,[ReceivedDate] ,MemberID ,ProviderID ,DocumentID ,MemberName FROM [pc_assign_workbasket] where pxobjclass='Assign-WorkBasket' and pxRefObjectClass like 'Antm-%' and pxAssignedOperatorID = ? and pyAssignmentStatus like 'Open-Assigned-%' and pxWorkGroup like 'CompassClinical%' Order by ReceivedDate asc

2) 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"."pzInsKey" AS "pzInsKey" FROM dbo.pc_assign_worklist "PC0" WHERE ( "PC0"."pxAssignedOperatorID" = ? ) AND "PC0"."pxObjClass" = ? ORDER BY 1 DESC, 7 ASC, 13 DESC

3) SELECT "MemberID" AS "MemberID" , "pxCreateDateTime" AS "pxCreateDateTime" , "pxObjClass" AS "pxObjClass" , "pyID" AS "pyID" , "pyDescription" AS "pyDescription" , "pyStatusWork" AS "pyStatusWork" , "WorkbasketName" AS "WorkbasketName" , "MemberLOB" AS "MemberLOB" , "MemberFullName" AS "MemberFullName" , "ProviderName" AS "ProviderName" , "ProviderNumber" AS "ProviderNumber" , "pxCreateOperator" AS "pxCreateOperator" , "DualMemberID" AS "DualMemberID" , "DocumentID" AS "DocumentID" , "FaxWOID" AS "FaxWOID" , "pyResolvedTimestamp" AS "pyResolvedTimestamp" , "pxUpdateDateTime" AS "pxUpdateDateTime" , "pzInsKey" AS "pzInsKey" from dbo.CPMHC_WORK WHERE ( "MemberID" = ? ) AND "pxCreateDateTime" >= ? AND "pxCreateDateTime" <= ? AND ( "pxObjClass" NOT LIKE ? ) AND "pxObjClass" IS NOT NULL ORDER BY "pxCreateDateTime" DESC

4) delete from dbo.pr_idx_MemberBilling_SSNDeductions where pxInsIndexedKey = ? and pxIndexPurpose = ?

5) select pzPVStream from dbo.CPMHC_WORK where pzInsKey = ?

6) select pzPVStream , pxCommitDateTime from dbo.pc_assign_workbasket where pzInsKey = ?

***Edited by Moderator Marissa to update SR Details***

System Administration Support Case Parallel
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.