Related content:

Question DML list for pr_sys_locks etc Question OLD entries not getting removed from PR_SYS_LOCK post the pxexpiredatetime is reached Question Wrong date getting insert into pr_sys_locks table on the pxExpireDateTime value Question Blocking on pr_sys_locks and pr_sys_locks_sla tables Question Defragmentation of pr_sys_locks while importing Application Jar Question Lock cache, lock not present in pr_sys_locks while  performing  assignment (Pega v7.2) Question How to resolve Pega0005 alert due to pr_sys_locks Question INITRANS value(to allow multiple concurrent sessions to update the same data blocks ) for the Pega OOTB WORK and PR_SYS_LOCKS tables (current value 1 in our application) Question Is it best practice to create database index for pr_sys_locks? Discussion pr_sys_statusnodes purpose and population

Question

3
Replies
320
Views
JohnPaulRaja,C Member since 2011 246 posts
Cognizant
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed

purpose PXEXPIREDATETIME in PR_SYS_LOCKS

Hi,

What is the use PXEXPIREDATETIME column in PR_SYS_LOCKS.

To timeout the workobject lock, some value is force assigned in the column but still work object locked.

We read, lock information is in cache as well.

How to timeout work object lock from DB and cache?

#Helpme

Case Management Data Integration
Close popover
Moderation Team has archived post
Posted: 2 years ago

Hello John, 


pxExpireDateTime : Holds the locking expiring time.  This is the time stamp after calculating Release lock time span configured on caseType.(CaseType>>Settings>>Locking>>Release Lock after __ mins.).
Share this page LinkedIn
Copied!