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.

Discussion

 Vuyyuru Srikanth (VSRIKANTH)
TECHMAHINDRA
Team Lead
TECHMAHINDRA
IN
VSRIKANTH Member since 2012 1 post
TECHMAHINDRA
Posted: Nov 9, 2015
Last activity: Nov 12, 2015
Posted: 9 Nov 2015 23:51 EST
Last activity: 12 Nov 2015 14:08 EST
Closed

Releasing lock of a DB instance explicitly

Can we release lock of a DB instance which was held by some other operator?

To see attachments, please log in.

  • Kemal Onur Demirtas
Posted: 9 years ago
Posted: 10 Nov 2015 7:22 EST
Sai Phaneendra (SaiYakkali)
Navy Federal Credit Union
Lead Platform Architect
Navy Federal Credit Union
US
WorkUnlock is the activity to release locks. Pass DifferentRequstor parameter as true. Note: Make sure your business scenarios before calling this
To see attachments, please log in.
Posted: 9 years ago
Posted: 10 Nov 2015 22:44 EST
Vuyyuru Srikanth (VSRIKANTH)
TECHMAHINDRA
Team Lead
TECHMAHINDRA
IN

Thanks Sai for your prompt response, I tried the activity: WorkUnlock and able to release the lock held by same operator in different session, whereas I couldnt able to release the lock held by different operator. Is it possible to do that.

To see attachments, please log in.
Posted: 9 years ago
Posted: 10 Nov 2015 23:00 EST
Narendra Chaganti (NarendraC9464)
Wipro Technologies Ltd

Wipro Technologies Ltd
AU

WorkLock activity is used still to release locks held by the same operator not the different operator but even under a different requestor.

To see attachments, please log in.
Posted: 9 years ago
Posted: 11 Nov 2015 2:39 EST
Bhavya Tyagi (Bhavya)
Coforge DPA
Senior Technical Lead
Coforge DPA
GB

Hi ,

 

Try using activity "ReleaseLock" of System-Locks class. Run this activity by passing the pzInsKey of the workitem which you want to unlock.

 

Regards

To see attachments, please log in.
Posted: 9 years ago
Posted: 12 Nov 2015 14:08 EST
Abhishek Sajjan (ANSAJJAN)
Tata Consultancy Services

Tata Consultancy Services
US

Hi,

 

Try using the activity 'WorkUnlock ' or 'WorkUnlock'. If these does not work you can execute delete SQL query on PR_SYS_LOCKS passing pxlockhandle(not recommended).

 

To see attachments, please log in.

Related content:

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