Support #6573
Re: [SCP ID :##3365##] : pay transaction not updated in DB
| Status: | Closed - End of life cycle | Start date: | September 14, 2016 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | % Done: | 0% | ||
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Kah Yan
Kindly assist
History
#1
Updated by Yap Kah Yan about 8 years ago
- File epay recon.7z added
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Yap Kah Yan to Ahmad Hazri
As per our discussion, the logs are overwritten.
From the provided logs, I have found 2 cases due to DB deadlock. The other 2 cases I am unable to find in the logs.
Trnx ID: 20160824000005785300
App2 server1 SystemErr_16.08.24_23.00.00
[8/24/16 12:08:59:450 SGT] 0000005a SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserTransactionHistory]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 111) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Trnx ID: 20160819000005728100
App2 server 1 SystemErr_16.08.19_09.32.34
[8/19/16 9:26:54:516 SGT] 0000006f SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserTransactionHistory]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 118) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
#2
Updated by Tan Lee Yong almost 8 years ago
Hazri, please update status
#3
Updated by Ahmad Hazri over 7 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- The deadlock issue is being address in IB Assessment activity.
- Item closed at SCP.