Support #12955: [SCP ID :##6263##] : Difference Data Between Document DPSI with DPSI Query Portal and Fee Portal Report (MLTI Ticket INC000000461912) - BI FAST Support - Penril Support System

Support #12955

[SCP ID :##6263##] : Difference Data Between Document DPSI with DPSI Query Portal and Fee Portal Report (MLTI Ticket INC000000461912)

Added by Zahir Abd Latif over 2 years ago. Updated over 2 years ago.

Status:

Work Completed-End life cycle

Start date:

April 28, 2022

Priority:

High

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 difference Data Between Document DPSI with DPSI Query Portal and Fee Portal Report (MLTI Ticket INC000000461912)
Transaction date 27 Apr 2022 have difference, transaction data CT success (U000) BNINIDJA is OFI between transaction data from DPSI with query Portal and Fee Report Portal
please find document attached for referenc

20220427_TRX_BIFAST.XLSX (114 KB) Zahir Abd Latif, April 28, 2022 09:12

CreditTransferFeeAdmin_27042022_Daily.xlsx (25.5 KB) Zahir Abd Latif, April 28, 2022 09:12

Query Portal Trx CT U000 BNI as OFI.DOCX (510 KB) Zahir Abd Latif, April 28, 2022 09:12

RPP_TRNX_LOG_DATA.txt - QUERY 1 DATA (1.01 MB) Bramantyo Pujo Wiyono, April 29, 2022 01:30

IPF_TRANS_LOG.txt - QUERY 2 DATA (1.01 MB) Bramantyo Pujo Wiyono, April 29, 2022 01:30

RPP_TRNX_LOG_DATA.jpeg - QUERY 1 IMG (56 KB) Bramantyo Pujo Wiyono, April 29, 2022 01:30

IPF_TRANS_LOG.jpeg - QUERY 2 IMG (162 KB) Bramantyo Pujo Wiyono, April 29, 2022 01:30

2204270147986109.csv (8.21 KB) Bramantyo Pujo Wiyono, May 01, 2022 01:48

2204270147986109.csv (8.21 KB) Bramantyo Pujo Wiyono, May 01, 2022 01:56

History

#1 Updated by Sarifah Nurhafizah Nasihah Ibnuhajar over 2 years ago

Assignee changed from Sarifah Nurhafizah Nasihah Ibnuhajar to Bramantyo Pujo Wiyono

Need help to check on this issue. Thank you

#2 Updated by Bramantyo Pujo Wiyono over 2 years ago

File RPP_TRNX_LOG_DATA.txt added
File IPF_TRANS_LOG.txt added
File RPP_TRNX_LOG_DATA.jpeg added
File IPF_TRANS_LOG.jpeg added
Status changed from New - Begin Life Cycle to Investigation

Based on our invesitagion pull data use this query to check total trnx for OFI BNINIDJA

From DB Portal:
select count(*) from rpp_trnx_log_data where
COMPLETED_DATE >= TO_DATE('27042022 000000', 'DDMMYYYY HH24MISS') AND
COMPLETED_DATE < TO_DATE('28042022 000000', 'DDMMYYYY HH24MISS') AND
(TRNX_STATUS='ACTC' OR TRNX_STATUS='ACSP') AND SERVICE in ('010') and OFI_CODE = 'BNINIDJA';
Result: 53038

From DB Hub NRT:
Select count(*) from ipf_trans_log where ORIGINAGT_FI_BICFI = 'BNINIDJA' AND
PAYMENT_TYPE = '010' AND
LAST_MODIFIED >= TO_DATE('26042022 170000', 'DDMMYYYY HH24MISS') AND
LAST_MODIFIED < TO_DATE('27042022 170000', 'DDMMYYYY HH24MISS') AND
STATUS_CODE IN ('ACSP','ACTC');
Result: 53039

there is 1 volume difference different
The trn that missing on portal: 2204270147986109

still need do futher investigation

#3 Updated by Bramantyo Pujo Wiyono over 2 years ago

File 2204270147986109.csv added

on the log got this error:

39284 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 12899, SQLState: 72000
39284 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-12899: value too large for column "CI_PORTAL"."RPP_TRNX_LOG_DATA"."RFI_ACCT_NO" (actual: 34, maximum: 30)

org.hibernate.QueryTimeoutException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
at net.penril.rpp.core.hibernate.RppTrnxLogData.createRppTrnxLogData(RppTrnxLogData.java:773)
at com.rpp.batch.job.trnx.TrnxDataTransformationBatchMain.main(TrnxDataTransformationBatchMain.java:694)
Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "CI_PORTAL"."RPP_TRNX_LOG_DATA"."RFI_ACCT_NO" (actual: 34, maximum: 30)

at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9723)
        at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1447)
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9499)
        at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:237)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
        ... 9 more
00:18:16.389 [main] ERROR com.rpp.batch.job.trnx.TrnxDataTransformationBatchMain - Failed to create trnx log data for trnx id: 2204270147986109
00:18:16.389 [main] ERROR com.rpp.batch.job.trnx.TrnxDataTransformationBatchMain - org.hibernate.QueryTimeoutException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
        at net.penril.rpp.core.hibernate.RppTrnxLogData.createRppTrnxLogData(RppTrnxLogData.java:773)
        at com.rpp.batch.job.trnx.TrnxDataTransformationBatchMain.main(TrnxDataTransformationBatchMain.java:694)

Check on data those field got this value :
CdtrAcct:{"Id":{"Othr":{"Id":"1050439379 a\/n Habibillah Bank BSI"}}

#4 Updated by Bramantyo Pujo Wiyono over 2 years ago

File 2204270147986109.csv added
Status changed from Investigation to Development / Work In Progress
% Done changed from 0 to 100

So in summary

there is 1 volume difference different
The trn that missing on portal: 2204270147986109

root cause:
invalid crediting account number field on transaction data.
value on from data hub for trn 2204270147986109 endtoendid 20220427BNINIDJA010O0205719207 =
CdtrAcct:{"Id":{"Othr":{"Id":"1050439379 a\/n Habibillah Bank BSI"}}

#5 Updated by Bramantyo Pujo Wiyono over 2 years ago

Status changed from Development / Work In Progress to Work Completed-End life cycle

Also available in: Atom PDF

B - Production Support » BI FAST Support

Issues