File listener failed due to deadlock error
File listener sometimes fail to process files due to the below error.
[.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.
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.
User to retrieve db trace log to confirm deadlock and modify RDB call to include commit.