Support #7017
[SCP ID :##3591##] : epay transaction not captured in DB, impacted epay recon file.
| Status: | Closed - End of life cycle | Start date: | January 10, 2017 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | RIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
Recently there are many epay transaction that not capture in IB which cause it not being generated in epay recon file.
Please help to check and fix.
Sample transaction as below:
History
#1
Updated by Yap Kah Yan over 7 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
30/11/2016 9:08 - Appserver1 - server1
[11/30/16 9:08:46:910 SGT] 00000025 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 103) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
- SystemOut.log only until [12/1/16 15:19:15:196 SGT]
[12/1/16 15:42:09:205 SGT] 00000025 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 102) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
10/12/2016 19:46 - No logs on this timestamp
16/12/2016 8:44 - Appserver1 - server2
[12/16/16 8:44:08:091 SGT] 00000029 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 89) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
16/12/2016 17:52 - Appserver1 - server2
[12/16/16 17:52:49:829 SGT] 00000029 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 76) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
20/12/2016 9:32 - No logs on this timestamp
20/12/2016 12:20 - Appserver1 - server2
[12/20/16 12:22:35:327 SGT] 00000023 SystemErr R org.hibernate.exception.LockAcquisitionException: could not update: [net.penril.ibss.core.hibernate.IbUserTransactionHistory#20161220000006907748]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
21/12/2016 7:58 - Appserver1 - server2
[12/21/16 7:58:15:814 SGT] 00000021 SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserPrintReceipt]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
[12/21/16 7:58:15:814 SGT] 00000021 SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserPrintReceipt]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
[12/21/16 7:58:20:822 SGT] 00000021 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 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
22/12/2016 9:03 - Appserver1 - server2
[12/22/16 9:03:39:166 SGT] 00000909 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 93) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
22/12/2016 9:04 - Appserver1 - server2
[12/22/16 9:04:48:333 SGT] 0000090e 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 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
22/12/2016 9:26 - Appserver1 - server2
[12/22/16 9:26:35:905 SGT] 00000915 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 84) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
22/12/2016 9:35 - Appserver1 - server2
[12/22/16 9:35:10:413 SGT] 0000090f SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserPrintReceipt]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 93) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
[12/22/16 9:35:10:413 SGT] 0000090f SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserPrintReceipt]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 93) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
[12/22/16 9:35:10:460 SGT] 00000915 SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserPrintReceipt]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 94) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
[12/22/16 9:35:10:460 SGT] 00000915 SystemErr R org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserPrintReceipt]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 94) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
22/12/2016 10:00 - Appserver1 - server2
[12/22/16 10:00:06:299 SGT] 00000186 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 101) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
22/12/2016 14:48
[12/22/16 14:48:55:965 SGT] 00000919 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 101) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
27/12/2016 17:17 - Appserver1 - server2
[12/27/16 17:18:06:129 SGT] 00000074 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 97) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
#2
Updated by Yap Kah Yan over 7 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
deadlock issue to be solve as separate project / development.
Please help to close this case.
#3
Updated by Zahir Abd Latif over 7 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 0 to 100
Issue closed in SCP.