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.
Pegasystems Inc.
IN
To resolve this issue , we need to follow below steps
- Run Rebuild all and reorganize all on the tables mentioned in the deadlock error
- Run update statistics on the same tables
- Run resume.bat to resume the rules upgrade
Below is the sample sql statement
ALTER INDEX ALL ON rules.pr_index_reference
REORGANIZE ;
GO
UPDATE STATISTICS rules.pr_index_reference
GO
TCS
GB
Hi,
When you run the upgrade, if the property "rebuild.indexes" in setupDatabase.properties file is set as true, then the upgrade step calls the SPPR_REBUILD_INDEXES procedure to rebuild indices and forces the re-computation of table stats for the purpose of upgrade performance.
By default, this property is set as FALSE for all DB except DB2 Z/oS. I understand that this step is time consuming.
Won't setting up this property avoided your problem in the first place ?
Thanks, Jaffer