Question

12
Replies
2901
Views
RajasekharU0829 Member since 2013 98 posts
Techmahindra
Posted: 2 years ago
Last activity: 2 years 4 months ago
Closed
Solved

How to resolve Pega0005 alert due to pr_sys_locks

We are getting below alert in our log file. Please let us know how to resolve Pega0005 alert due to pr_sys_locks.

GMT*8*PEGA0005*6157*500*353fb4828f7466d25868b062e668e790*NA*NA*AE11AFC7DE5187BDBA2BD42BC8F9F7F82*none*XXX-XX-XXXX-Work*PegaRULES:07.10*02b8c3d24e72134941050057c14d21a3*N*0*AE11AFC7DE5187BDBA2BD42BC8F9F7F82*288*Thread-1530 (HornetQ-client-global-threads-1946063216)*STANDARD*com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl*EMAIL.XXXXEmailListener.Listener*NA***NA*****NA*NA*NA*NA*NA*NA*NA*Database query took more than the threshold of 500 ms: 6,157 ms SQL: select pxOwnerId as "pxOwnerId", pxUpdateOperator as "pxUpdateOperator", pxUpdateOpName as "pxUpdateOpName", pxExpireDateTime as "pxExpireDateTime", pxUpdateDateTime as "pxUpdateDateTime", pxLockHandle as "pxLockHandle", pxCreateDateTime as "pxCreateDateTime", pxUserHost as "pxUserHost" from DATAADM.pr_sys_locks where pzInsKey = ?*

***Edited by Moderator Marissa to update categories***

System Administration
Moderation Team has archived post
Share this page LinkedIn