Discussion
2
Replies
207
Views
Posted: October 5, 2015
Last activity: April 6, 2018
Closed
Rules Upgrade Failed With Deadlock Issue in MS SQL Server
While upgrading to Pega 7 , the rules upgrade might fail with db deadlock issue in MS SQL Server database.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
To resolve this issue , we need to follow below steps
Below is the sample sql statement
ALTER INDEX ALL ON rules.pr_index_reference
REORGANIZE ;
GO
UPDATE STATISTICS rules.pr_index_reference
GO