B - Production Support » BI FAST Support

Investigation MS W1 error:
1.Generate Member statement
2.get list total volume rfi
3.get list total volume ofi
4.combine list no2 and no3
CENAIDJA 2000
5.sort list no2 volume decending (error here)
6.assing multi thread based on no5
7.loop for each Participant to get report data and generate the report

Root cause:
There are rare ocation that sorting causing this error

Work around:

action (insert TRNX_ID = 2401249000000000 LFIBIDJ1= OFI)

1.Generate Member statement
2.get list total volume rfi
3.get list total volume ofi
4.combine list no2 and no3
CENAIDJA 2000
5.sort list no2 volume decending (error here)

action (delete TRNX_ID = 2401249000000000)

6.assing multi thread based on no5
7.loop for each Participant to get report data and generate the report

To insert dummy transaction data to prevent the sorting error, after flow no5 done, delete those data

Script work around

--(INSERT SCRIPT DUMMY TRANSACTION DATA)
Insert into CI_PORTAL.RPP_TRNX_LOG_DATA
(TRNX_ID,SETTLEMENT_CYCLE,INITIATION_DATE,MSG_ID,BUSINESS_MSG_ID,
SERVICE,SCHEME_ID,OFI_CODE,OFI_ACCT_NO,OFI_ACCT_TYPE,
OFI_ACCT_NAME,RFI_CODE,RFI_ACCT_NO,RFI_ACCT_TYPE,RFI_ACCT_NAME,

TRNX_AMOUNT,TRNX_STATUS,TRNX_SUB_CODE,COMPLETED_DATE,OUTBOUND_SCHEME_ID,
TERMINAL_ID,ACQUIRER_TRACE_NUMBER,SETTLEMENT_RETRY,SETTLEMENT_READY,ACTUAL_SETTLEMENT_DATE,
ACTUAL_SETTLEMENT_CYCLE,END_TO_END_ID,INITIATING_MSG_ID,ACTUAL_CUT_OFF_DATE,REGISTRATION_ID,

RECEIPT_REF,PAYMENT_DESC,MK_PENDING,CREDITOR_ACCT_NAME,MERCHANT_ID,
MERCHANT_SERVICE_ID,PRODUCT_ID,BILL_REF_NO,BILL_DESC,MERCHANT_NAME,
IP_ADDR,GPS,MANDATE_ID,COLLECT_START_DATE,COLLECT_END_DATE,

PRE_AUTH_AMOUNT,DEBTOR_ID,CHANNEL_TYPE,DEBTOR_TYPE,PRE_AUTH_ID,
PRE_AUTH_HOLD_DAY,PRE_AUTH_EXPIRED,FREQUENCY,PAYMENT_CATEGORY,CREDITOR_ID_TYPE,
CREDITOR_ID_VALUE,CREDITOR_TYPE,SELLER_ID,URL,EXPIRED_DATE,

SOURCE_OF_FUND,OFI_ACCT_NO_ENCRYPT,MESSAGE_ID,PURPOSE_OF_TRNX,OFI_CUST_ID,
OFI_HOME_TW,OFI_CUST_TYPE,OFI_RESI_TYPE,RFI_CUST_ID,RFI_HOME_TW,
RFI_CUST_TYPE,RFI_RESI_TYPE,PROXY_TYPE,PROXY_VALUE,TRNX_CCY,BATCH)
values
(2401249000000000,'002',to_timestamp('24-JAN-24 01.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'20230302LFIBIDJ101029353057','20230302SSPIIDJA010O0229353057',
'010','BIFAST','LFIBIDJ1','901024500642','SVGS',
'X','LFIBIDJ1','8890081212380325','OTHR','TOP UP D-WALLET',

0,'ACTC','U000',to_timestamp('24-JAN-24 01.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'-1',
'LFIBIDJ1','353057',0,0,null,
null,'20230302SSPIIDJA010O0229353057','26743970837',to_timestamp('24-JAN-24 12.00.00.000000000 AM','DD-MON-RR HH.MI.SSXFF AM'),null,

null,null,0,null,null,
null,null,null,null,null,
null,null,null,null,null,

null,null,'02',null,null,
null,null,null,null,null,
null,null,null,null,null,

null,null,null,01003,'3207306710980001',
null,null,null,null,null,
null,null,null,null,'IDR',null);

--(CHECKING SCRIPT DUMMY TRANSACTION DATA)
select * from RPP_TRNX_LOG_DATA where TRNX_ID = 2401249000000000;

--(DELETE SCRIPT DUMMY TRANSACTION DATA)
delete from RPP_TRNX_LOG_DATA where TRNX_ID = 2401249000000000;

Permanent solution:
we will prepare patch to fix the sorting mechanism to prevent this error

This patch has been send to PTAP
Date: 29/01/2024
Link: https://penrilsb-my.sharepoint.com/:f:/g/personal/haida_md_penril_net/Eq36wqI-dGVBlkXdd3xF0wgBGeZLPoHtRLfoi8n2lEvVyg?e=Sr37eE

Already deployed in prod 28FEB2024