Support #5466: [SCP ID :##2777##] : SI Double Entry. - KFH Support - Penril Support System

Support #5466

[SCP ID :##2777##] : SI Double Entry.

Added by Zahir Abd Latif about 9 years ago. Updated about 9 years ago.

Status:

Closed - End of life cycle

Start date:

September 02, 2015

Priority:

High

Due date:

Assignee:

Zahir Abd Latif

% Done:

100%

Category:

MY RIB

Spent time:

Target version:

Description

Hi,
Kindly attend below request:

We received a complaint on the additional entries triggered around 3.30pm for SI transactions dated 1.9.15.
This has resulted double entries were debited from customer's account. Issue log as per attached.

Please check on this issue ASAP and revert accordingly.

Issue log 20150902 -SI Double Entries.rar (333 KB) Zahir Abd Latif, September 02, 2015 17:38

History

#1 Updated by Zahir Abd Latif about 9 years ago

Status changed from New - Begin Life Cycle to Development / Work In Progress

#2 Updated by Zahir Abd Latif about 9 years ago

Status changed from Development / Work In Progress to Pending Customer Feedback
Assignee changed from Aditya Prathama to Ngoh Chee Ping

Update from Chee Ping, Sep 4, 2015 06:12 PM:-

Hi Fizal and Shikin

Please look at log below. I already highlighted the some transaction id which is same on production and DR log. It is same like what we suspect, 
because DR also running the SI scheduler that cause the double entry problem. Some of the transaction do not have double entry because there is 
an error throw when want to perform transfer.

Production

2015-09-01 11:05:15,699 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201312020001117037
2015-09-01 11:05:15,699 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: inter 201312020001117037
2015-09-01 11:05:18,258 INFO [STDOUT] SI Charges: 2.0
2015-09-01 11:05:22,540 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201312020001117037' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 11:05:22,885 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201401080001165773
2015-09-01 11:05:22,885 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: inter 201401080001165773
2015-09-01 11:05:25,528 INFO [STDOUT] SI Charges: 2.0
2015-09-01 11:05:29,621 INFO [STDOUT] kfhonline@kfh.com.my, mexdelina.hussein@kfh.com.my, KFH Online Banking Interbank Transfer (IBG), 127.0.0.1, OK
2015-09-01 11:05:30,467 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201401080001165773' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 11:05:32,704 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201410040001587484
2015-09-01 11:05:32,704 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: billpayment 201410040001587484
2015-09-01 11:05:36,766 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201410040001587484' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 11:05:36,811 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201410040001587486
2015-09-01 11:05:36,812 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: billpayment 201410040001587486
2015-09-01 11:05:38,272 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201410040001587486' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 11:05:38,316 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201410060001588557
2015-09-01 11:05:38,317 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: billpayment 201410060001588557
2015-09-01 11:05:39,852 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201410060001588557' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 11:05:39,897 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201410060001588558
2015-09-01 11:05:39,897 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: billpayment 201410060001588558
2015-09-01 11:05:41,483 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201410060001588558' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')

2015-09-01 15:12:34,636 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201312020001117037
2015-09-01 15:12:34,636 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: inter 201312020001117037
2015-09-01 15:12:43,194 INFO [STDOUT] SI Charges: 2.0
2015-09-01 15:12:51,780 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201312020001117037' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 15:12:51,978 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201401080001165773
2015-09-01 15:12:51,978 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: inter 201401080001165773
2015-09-01 15:12:55,772 INFO [STDOUT] SI Charges: 2.0
2015-09-01 15:16:18,637 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201410040001587484
2015-09-01 15:16:18,638 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: billpayment 201410040001587484
2015-09-01 15:16:20,930 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201410040001587484' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 15:16:20,984 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201410040001587486
2015-09-01 15:16:20,984 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: billpayment 201410040001587486
2015-09-01 15:16:22,788 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201410040001587486' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 15:16:22,840 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201410060001588557
2015-09-01 15:16:22,841 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: billpayment 201410060001588557
2015-09-01 15:16:28,279 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201410060001588557' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')
2015-09-01 15:16:28,331 INFO [net.penril.scheduler.job.SIJobConsumer] ibSi.getTrnxID() 201410060001588558
2015-09-01 15:16:28,331 INFO [net.penril.scheduler.job.SIJobConsumer] consumer ibsi matched to run: billpayment 201410060001588558
2015-09-01 15:16:30,150 INFO [STDOUT] select {hist.*} from ib_si_history hist join ib_si si on si.trnx_id=hist.si_trnx_id where si.trnx_id='201410060001588558' and trunc(hist.trnx_date)=TO_DATE('01/09/2015','dd/mm/yyyy')

#3 Updated by Zahir Abd Latif about 9 years ago

Status changed from Pending Customer Feedback to Closed - End of life cycle
Assignee changed from Ngoh Chee Ping to Zahir Abd Latif
% Done changed from 0 to 100

Issue closed in SCP.

Also available in: Atom PDF

B - Production Support » KFH Support