Discussion
2
Replies
253
Views
Cognizant Technology Solutions
Posted: May 13, 2016
Last activity: April 6, 2018
Closed
DB issue after upgrading to Pega 7.2
A long query of approx 5500 lines is running on pr_index_reference table after upgrade which makes the server very slow.
What could be the reason?
**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.
Posted: 4 years ago
Updated: 4 years ago
Run RULES_SCHEMA.SPPR_REBUILD_INDEXES to rebuild the indexes.
After this verify the PegaAlertLogs for any alerts from pr_index_reference table.
Please let us know if this helped.
Did you run the rebuild indexes stored procedure after the upgrade?. This is one of the root cause for slow running query.