Question

2
Replies
130
Views
 Seshagiri Jogineedi (SeshagiriJogineedi)
Virtusa
Software Development
Virtusa
AU
SeshagiriJogineedi Member since 2013 3 posts
Virtusa
Posted: April 27, 2017
Last activity: April 27, 2017
Posted: 27 Apr 2017 6:58 EDT
Last activity: 27 Apr 2017 16:52 EDT
Closed

Data base Commit While pega has lock

Hi all,

I tried to update the record in the data base by using update query which is already open in Pega with lock, update query ran successfully without any error.

So we can update a record from database which has a lock entry in Pr_Sys_Locks.

Data Integration
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.
Posted: 4 years ago
Posted: 27 Apr 2017 16:44 EDT
Tigran Airapetian (TigranAirapetian)
PEGA
Software Solutions Engineer
Pegasystems Inc.
US

Hi SeshagiriJogineedi,


I am not sure what the question is, please let us know what you are trying to accomplish.


What is the update query and which table are you updating? Kindly specify the Pega/PRPC version.


Thanks,

Tigran
Posted: 4 years ago
Posted: 27 Apr 2017 16:52 EDT
Kurt Waltz (KurtW_GCS)
PEGA
Principal GCS Solutions Engineer
Pegasystems Inc.
US

Hi,


To clarify, are you performing direct database actions (outside of Pega) on objects that have a lock on them from within Pega?  If yes, I wouldn't expect the Pega lock to have any impact on whether or not the object could be explicitly updated via a direct database action.  Per the below PDN article, a lock within Pega is separate from any locking mechanisms provided by the database:


https://pdn.pega.com/sites/pdn.pega.com/files/help_v722/procomhelpmain.htm#concepts/concepts2/conceptslocking.htm?Highlight=lock


Hope this helps!


-Kurt