Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

File listener failed due to deadlock error

SA-31632

Summary



File listener sometimes fail to process files due to the below error.


Error Messages



[.PRPCWorkManager : 3] [ STANDARD] [ ] [ ] (l.access.ConnectionManagerImpl) ERROR File.DavoxFileFeed|process|A7B26C7EE7360724C88DEF835FBD89A61|1476971230358000|TesdtCaseData/Services/ProcessData testuser - Not returning connection 8 for database "pegadata" to the pool as it previously encountered the following error
User ID: testUser
Last SQL: UPDATE PRPC.TEST_CASE SET TERMCODE=?, ISTERMCODENULL='false' WHERE PROCESSDATE < TO_DATE('2016/10/20','yyyy/mm/dd') AND ISTERMCODENULL = ? AND PLATFORMCODE = ? AND ISSLADEADLINETIMENULL = ?
java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource


Steps to Reproduce



This issue is sporadic in nature.
Include a file listener that consume files.


Root Cause



The epilog activity on the file listeners employs RDB-Save calls. The last call needs to have a commit or else lock is not released by database.

Resolution



User to retrieve db trace log to confirm deadlock and modify RDB call to include commit.
 

 

Suggest Edit

Published December 24, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us