Support #13481
[SCP ID :##6648##] : Anomaly Performance Access Transaction History and Generate Report to Participants Bank on CI Portal (WO0000000384894)
Status: | Closed - End of life cycle | Start date: | April 11, 2023 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Bramantyo Pujo Wiyono | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
Kindly need your help to advice issue below,
Anomaly Performance Access Transaction History and Generate Report to Participants Bank on CI Portal.
please find email attached for reference.
History
#1 Updated by Bramantyo Pujo Wiyono over 1 year ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- % Done changed from 0 to 20
This case happend because now the retention data for the table rpp_trnx_log_data are not active.
this table now had 200+ days data (suposedly only 90 days) that causing performace issue upon query to this table.
The retention data not active because last time this retention service causing cpu spike, and we already try to resolve that retention previously by implementing table partition and update the retention using drop partition that can impove retention performace. but upon implementing table partition we had a problem and decided to rollback.
informed by Herwin(ptap) and BI already planned to implement the table partition again, but the schedule still TBC (probably after eid holiday).
For temporary solution we suggest to manualy retention those table first periodically.
#2 Updated by Rayvandy Gabbytian about 1 year ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 20 to 100
Bram, Sep 5, 2023:
This case should be already solve by, apply table partition