Close popover
Avisek Mondal (avisekmondal)
Cognizant Technology Solutions
System Architect
Cognizant Technology Solutions
avisekmondal Member since 2008 21 posts
Cognizant Technology Solutions
Posted: February 13, 2019
Last activity: July 3, 2019

WITH UR for Deadlock

We are upgrading an application from 7.1.5 to 7.4. We have few list views where the getContent has been customized to use WITH UR in the query. We came to know there were few deadlock scenarios earlier in tables for which DBA suggested to use WITH UR in queries.

As in 7.4, we are planning to move to RD, we won't be able to use this WITH UR in RD. As Pega also uses RD wherever possible, just want to check do they take care of this deadlock scenarios by themselves in RD if such scenarios occur in application?

***Edited by Moderator: Pallavi to update platform capability tags***

Data Integration Reporting System Administration Upgrades
Moderation Team has archived post