Question

4
Replies
678
Views
Seri Charoensri (chars1)
PEGA
Sr. System Architect
Pegasystems Inc.
AU
chars1 Member since 2015 46 posts
PEGA
Posted: April 20, 2016
Last activity: February 20, 2017
Posted: 20 Apr 2016 3:16 EDT
Last activity: 20 Feb 2017 3:46 EST
Closed
Solved

Keep seeing deadlock on Log-RuleUsage-Details - why and what is the impact

Hi there,

In production logs, I keep seeing the error with the updating rules usage....   Can we do anything about this? e.g. Index needed? and what is the impact for the client?

Show More

Hi there,

In production logs, I keep seeing the error with the updating rules usage....   Can we do anything about this? e.g. Index needed? and what is the impact for the client?

2016-04-20 15:00:28,744 [  PegaRULES-Batch-3] [  STANDARD] [                    ] [    PegaRULES:07.10] (  internal.access.DatabaseImpl) ERROR  - Encountered problem when performing a Commit com.pega.pegarules.pub.database.DatabaseException: Database-General Problem saving instance of class Log-RuleUsage-Details 1205 40001 Transaction (Process ID 95) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. From: (BD9BB6F9DA5D71D538416E9F46A42EA18) SQL: MERGE INTO dbo.pr4_log_rule_usage_details t USING (VALUES (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) AS inputs ("pzInsKey" , "pxAssemblyCacheKey" , "pxClassName" , "pxCreateDateTime" , "pxDetailIndex" , "pxInsName" , "pxObjClass" , "pxParentRuleUsageKey" , "pxSystemNode" , "pxUpdateDateTime" , "pxUseCount" , "pyLabel") ON (t.pzInsKey = inputs."pzInsKey") WHEN MATCHED THEN UPDATE SET pxAssemblyCacheKey = inputs."pxAssemblyCacheKey" , pxClassName = inputs."pxClassName" , pxCreateDateTime = inputs."pxCreateDateTime" , pxDetailIndex = inputs."pxDetailIndex" , pxInsName = inputs."pxInsName" , pxObjClass = inputs."pxObjClass" , pxParentRuleUsageKey = inputs."pxParentRuleUsageKey" , pxSystemNode = inputs."pxSystemNode" , pxUpdateDateTime = inputs."pxUpdateDateTime" , pxUseCount = inputs."pxUseCount" , pyLabel = inputs."pyLabel" , pxCommitDateTime = CURRENT_TIMESTAMP WHEN NOT MATCHED THEN INSERT (pzInsKey , pxCommitDateTime , pxAssemblyCacheKey , pxClassName , pxCreateDateTime , pxDetailIndex , pxInsName , pxObjClass , pxParentRuleUsageKey , pxSystemNode , pxUpdateDateTime , pxUseCount , pyLabel) VALUES (inputs."pzInsKey" , CURRENT_TIMESTAMP , inputs."pxAssemblyCacheKey" , inputs."pxClassName" , inputs."pxCreateDateTime" , inputs."pxDetailIndex" , inputs."pxInsName" , inputs."pxObjClass" , inputs."pxParentRuleUsageKey" , inputs."pxSystemNode" , inputs."pxUpdateDateTime" , inputs."pxUseCount" , inputs."pyLabel"); SQL Inserts: Caused by SQL Problems. Problem #1, SQLState 40001, Error code 1205: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 95) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:257) at com.pega.pegarules.data.internal.access.Saver.addBatch(Saver.java:980) at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:796) at com.pega.pegarules.data.internal.access.Committer.performOps(Committer.java:236)

Regards

Seri

Message was edited by: Lochan to add Category

Show Less
System Administration
Moderation Team has archived post, 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.