Support #8123
SCP ID :##4320##] : KADA Bulk Payment Txn - still pending after approved
Status: | Closed - End of life cycle | Start date: | December 07, 2017 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | BIB | Spent time: | - | |
Target version: | - |
Description
Hi Kah Yan,
Kindly attend below request.
Bulk Payment transaction performed by KADA dated 05/11/2017, amounting RM 630.00. They said the beneficiary still not received fund until today.
Further checking was made with IBAM and BPS system, the status at IBAM shown as “Pending” whilst at BPS shown as “Validated”.
History
#1 Updated by Yap Kah Yan almost 7 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
Root Cause: deadlock
Suggestion: Add below in hibernate to enable batch update
<property name="hibernate.order_inserts">true</property>
<property name="hibernate.order_updates">true</property>
<property name="hibernate.jdbc.batch_size">5</property>
<property name="hibernate.jdbc.batch_versioned_data">true</property>
Logs:
[11/6/17 12:04:29:005 SGT] 00000029 SystemOut O [06/11/2017] [12:04:29:005] [ERROR] [AbstractFlushingEventListener]:324 - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: could not update: [net.penril.bib.core.BibTransactionHistory#20171105000000373917]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.
[11/6/17 12:04:29:005 SGT] 00000029 SystemOut O [06/11/2017] [12:04:29:005] [ERROR] [AbstractFlushingEventListener]:324 - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: could not update: [net.penril.bib.core.BibTransactionHistory#20171105000000373917]
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.
#2 Updated by Zahir Abd Latif almost 7 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.