Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 John Paul Raja Christu Raja (JohnPaulRaja,C)
Maantic Inc
Consultant
Maantic Inc
US
JohnPaulRaja,C Member since 2011 302 posts
Maantic Inc
Posted: Aug 9, 2018
Last activity: Aug 10, 2018
Posted: 9 Aug 2018 16:45 EDT
Last activity: 10 Aug 2018 2:37 EDT
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

To see attachments, please log in.
Case Management
Data Integration

Posted: 6 years ago
Posted: 9 Aug 2018 19:26 EDT
Arvind Malav (malaa) Technical Manager
Pegasystems Inc.
IN

Hi John,

Thanks for posting your query here.

Please go through sub-topic expire soft lock in below article, though it is for 7.4 but hold good for lower version of PRPC 7.

https://community.pega.com/sites/default/files/help_v74/procomhelpmain.htm#concepts/concepts2/conceptslocking.htm

To see attachments, please log in.
Posted: 6 years ago
Posted: 10 Aug 2018 0:15 EDT
Naveen Kumar Gattupally (Naveen Naanu)
Vodafone
Senior Manger
Vodafone
IN

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.).

To see attachments, please log in.

Related content:

Question

Wrong date getting insert into pr_sys_locks table on the pxExpireDateTime value

Question

OLD entries not getting removed from PR_SYS_LOCK post the pxexpiredatetime is reached

Question

DML list for pr_sys_locks etc

Question

Blocking on pr_sys_locks and pr_sys_locks_sla tables

Question

Defragmentation of pr_sys_locks while importing Application Jar

Question Solved

Lock cache, lock not present in pr_sys_locks while  performing  assignment (Pega v7.2)

Question Solved

How to resolve Pega0005 alert due to pr_sys_locks

Question

How to resolve PEGA0005 alert due to pr_sys_locks insert query

Question Solved

Is it best practice to create database index for 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)

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice