Support #9944
SCP ID :##4976##] : Report for RFI nacha processing not generated
Status: | Closed - End of life cycle | Start date: | May 15, 2019 | |
---|---|---|---|---|
Priority: | High | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY IBG | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:
Currently no report were generate after RFI nacha processing complete. (report suppose be generated at 6:35 pm(w4) & 9:15 pm(w5)
History
#1 Updated by Yap Kah Yan over 5 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Yap Kah Yan to Zahir Abd Latif
Root Cause: Connection to database was unstable. Received timeout to database
Logs:
In nohup.out, found the below errors. We suspect the connection to database was unstable during report generation.
18:53:15,166 WARN [JDBCExceptionReporter] SQL Error: 17002, SQLState: null
18:53:15,166 ERROR [JDBCExceptionReporter] Io exception: Connection timed out
18:53:15,167 ERROR [STDERR] org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
21:33:40,750 WARN [JDBCExceptionReporter] SQL Error: 17002, SQLState: null
21:33:40,750 ERROR [JDBCExceptionReporter] Io exception: Connection timed out
21:33:40,751 ERROR [STDERR] org.hibernate.exception.GenericJDBCException: could not execute query
#2 Updated by Zahir Abd Latif over 5 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 0 to 100
Issue closed in SCP.