Support #6382
[SCP ID :##3207##] : IBG transaction details not display in AGRONet Trnx History.
| Status: | Closed - End of life cycle | Start date: | June 27, 2016 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | RIB | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
IBG transaction details not display in AGRONet Trnx History as below:
History
#1
Updated by Yap Kah Yan about 8 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
[6/23/16 10:02:00:203 SGT] 0000031c SystemOut O [23/06/2016] [10:02:00:203] [ERROR] [AbstractFlushingEventListener]:324 - Could not synchronize database state with session
org.hibernate.exception.LockAcquisitionException: could not insert: [net.penril.ibss.core.hibernate.IbUserTransactionHistory]
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 100) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
[6/23/16 10:02:00:203 SGT] 0000031c SystemOut O ---------------------------------------------------------------
[6/23/16 10:02:00:203 SGT] 0000031c SystemOut O Failure Time Stamp:Thu Jun 23 10:02:00 SGT 2016
[6/23/16 10:02:00:203 SGT] 0000031c SystemOut O allowReceipt: 0
amount: 575
channel: 1
details: Transaction Type|Favourite Interbank GIRO Transfer or Instant Transfer|Beneficiary Bank|RHB Bank
effectiveDate: Thu Jun 23 10:01:51 SGT 2016
fromAccountNo: 1006281000109745
gstCharges: 0
hostIpAddress: 172.16.51.24
persistentClass: class net.penril.ibss.core.hibernate.IbUserTransactionHistory
remoteIpAddress: 183.171.29.236
serviceCode: FUNFER
session: SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])
sessionId: D653TAVK5BbJOyVi_3qF3cI
status: Accepted
toAccountNo: 510080017800
totalChargeAmount: 0.11
transactionDatetime: Thu Jun 23 10:01:51 SGT 2016
transactionDescription: Favourite Interbank GIRO Transfer or Instant Transfer
transactionId: 20160623000005282619
userAgent: Mobile_Browser
userId: 0
userName:
[6/23/16 10:02:00:203 SGT] 0000031c SystemOut O ---------------------------------------------------------------
#2
Updated by Yap Kah Yan about 8 years ago
- Status changed from Development / Work In Progress to Pending Customer Feedback
Provided script to patch data due to deadlock.
insert into IB_USER_TRANSACTION_HISTORY
VALUES ('20160623000005282619', 'FUNFER', '2016-06-23 10:01:51', 'Favourite Interbank GIRO Transfer or Instant Transfer',
'D653TAVK5BbJOyVi_3qF3cI', '5075', 'Accepted', null, '1006281000109745', '510080017800', '575', '2016-06-23 10:01:51',
'0', '183.171.29.236', 'Transaction Type|Favourite Interbank GIRO Transfer or Instant Transfer|Beneficiary Bank|RHB Bank', '172.16.51.24',
'0.1', null, '1', 'Mobile_Browser', '0');
#3
Updated by Zahir Abd Latif about 8 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
- % Done changed from 0 to 100
Issue closed in SCP.