Support #13378
[SCP ID :##6565##] : IBG Transaction Failed
| Status: | Closed - End of life cycle | Start date: | January 04, 2023 | |
|---|---|---|---|---|
| Priority: | High | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY IBG | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:-
Transaction enable in IBG but 1 customer failed to receive the transaction.
Attached is the window of the failed transaction.
Customer details as below;
Account Name : Lionel Chan Hock Chuan
Account number: 001401023360
Amount : RM 310.00
pnd010307002023.txt 
(167 KB)
History
#1
Updated by Zahir Abd Latif over 1 year ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Hafiz, Jan 6, 2023:-
From our investigation. we found error when process Rfi nacha, we suspect there are too many open connections to the database service at that time Action Taken 1) Identify the records not processed by comparing RFI Nacha file and DB records 2) Provide the list to IT to perform direct credit at CORE Suggestion 1) Increase database connection size. Log 2023-01-03 09:15:55,725 ERROR [net.penril.engine.NachaReader] (MyScheduler_Worker-3) java.sql.SQLException: Io exception: Got minus one from a read call java.sql.SQLException: Io exception: Got minus one from a read call at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:140) at net.penril.util.DBConnection.getConnection(DBConnection.java:30) at net.penril.engine.NachaReader.createCreditEntry(NachaReader.java:656) at net.penril.engine.NachaReader.createEntry(NachaReader.java:595) at net.penril.engine.NachaReader.proces(NachaReader.java:293) at net.penril.engine.NachaReader.process(NachaReader.java:139) at net.penril.scheduler.job.NachaReaderWin1.execute(NachaReaderWin1.java:25) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
Hafiz, Jan 9, 2023:-
Please get sql for IBG issue below path:- //10.20.8.35/internet banking/20230109_ibg_sql_script/
#2
Updated by Zahir Abd Latif over 1 year ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Issue closed in SCP.