Support #13300
Support #13197: [SCP ID :##6413##] : Performance issue when access transaction history - BIF-103803
[SCP ID :##6501##] : Credit Transfer Recapitulation Monthly, Proxy Status Monthly and Transaction Mothly September 2022. Ticket reference : WO0000000327454
| Status: | Closed - End of life cycle | Start date: | October 28, 2022 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Bramantyo Pujo Wiyono | % Done: | 100% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Credit Transfer Recapitulation Monthly, Proxy Status Monthly and Transaction Monthly September 2022 still not generated.
Edit : Based on information BIFAST Helpdesk Team only Monthly Credit Transfer Recapitulation is still not generated.
History
#1
Updated by Tan Lee Yong almost 2 years ago
- Status changed from New - Begin Life Cycle to Pending Prod Deployment
- Parent task set to #13197
This issue is related to the DB performance slowness issue and the action is being taken on the DB Partition task by PTAP and BI.
[SCP ID :##6413##] : Performance issue when access transaction history - BIF-103803
Follow Up #13312: DB Table Partition
#2
Updated by Bramantyo Pujo Wiyono almost 2 years ago
- Status changed from Pending Prod Deployment to User Acceptance Test
Patch update partition table for RPP_TRNX_LOG_DATA already implented on production. already infrom PTAP team to regenerate the related report and waiting for feedback
#3
Updated by Rayvandy Gabbytian 12 months ago
- Status changed from User Acceptance Test to Closed - End of life cycle
- % Done changed from 0 to 100
Bram,Oct 31, 2022:-
This is because of the DB transaction table ( RPP_TRNX_LOG_DATA) performance issue, we already had a plan to resolve this performance issue by updating the current transaction table into a partition, that may help the performance and efficiency for retention data purpose.
This Partition Update Patch is in progress to be implemented on production, so we will focus on this patch implementation that may resolve the slowness of generating the reports and will check back to this case after successfully implementing those patches.
Bram, Nov 29, 2022:-
The partition table (RPP_TRNX_LOG_DATA) already implemented on production.
Bram, Sep 5, 2023:
This case should be already solve by, apply table partition, Enhance Report generation use summary table