Support #5524
[SCP ID :##2809##] : Some report for OFI Nacha Generation Report W1 & W2 are not available for retrieval at Corus.
| Status: | Closed - End of life cycle | Start date: | October 05, 2015 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY IBG | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
No email notification at 8.00am on the status for OFI W2 Nacha File Generation and Some report for OFI Nacha Generation Report W1 & W2 are not available for retrieval at Corus when we perform 1st IBG System Disaster Recovery Live Run Exercise on 2 October 2015.
History
#1
Updated by Zahir Abd Latif almost 9 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Hafizudin MD to Zahir Abd Latif
Update from Hafiz, Oct 5, 2015 04:20 PM:-
Please check cronjob to synchronize share folder between server. If this synchronization is include share folder at DR server because OFI file W1 & W2 is regenerate at DR server. Similar problem happen at last year DR Exercise.
We also found error connection to database
15:31:10,313 WARN [JDBCExceptionReporter] SQL Error: 17002, SQLState: null
15:31:10,313 ERROR [JDBCExceptionReporter] Io exception: Connection timed out
15:31:10,316 ERROR [STDERR] org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1722)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at net.penril.engine.NachaReaderReport.retrieveData(NachaReaderReport.java:114)
at net.penril.engine.NachaReaderReport.<init>(NachaReaderReport.java:57)
at net.penril.engine.NachaReader.process(NachaReader.java:295)
at net.penril.scheduler.job.NachaReaderWin3.execute(NachaReaderWin3.java:22)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
Caused by: java.sql.SQLException: Io exception: Connection timed out
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.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:815)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 12 more
15:31:10,325 ERROR [STDERR] java.lang.ClassCastException: org.hibernate.exception.GenericJDBCException
15:31:10,326 ERROR [STDERR] at net.penril.engine.NachaReaderReport.retrieveData(NachaReaderReport.java:119)
15:31:10,326 ERROR [STDERR] at net.penril.engine.NachaReaderReport.<init>(NachaReaderReport.java:57)
15:31:10,326 ERROR [STDERR] at net.penril.engine.NachaReader.process(NachaReader.java:295)
15:31:10,326 ERROR [STDERR] at net.penril.scheduler.job.NachaReaderWin3.execute(NachaReaderWin3.java:22)
15:31:10,326 ERROR [STDERR] at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
15:31:10,326 ERROR [STDERR] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
15:45:36,088 WARN [JDBCExceptionReporter] SQL Error: 17002, SQLState: null
15:45:36,088 ERROR [JDBCExceptionReporter] Io exception: Connection timed out
15:45:36,089 WARN [NewPooledConnection] [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
15:45:36,089 WARN [NewPooledConnection] [c3p0] Another error has occurred [ java.sql.SQLException: Closed Connection ] which will not be reported to listeners!
java.sql.SQLException: Closed Connection
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:208)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1133)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:217)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)
at net.penril.hibernate.util.WarehouseUtils.getCreditingList(WarehouseUtils.java:916)
at net.penril.engine.CreditingEngine.creditIntoBeneficiaryCASA(CreditingEngine.java:137)
at net.penril.engine.CreditingEngine.creditIntoBeneficiaryCASA(CreditingEngine.java:88)
at net.penril.scheduler.job.CreditingEngineJob3.execute(CreditingEngineJob3.java:27)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
15:45:36,089 ERROR [JDBCTransaction] JDBC rollback failed
java.sql.SQLException: Closed Connection
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:208)
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1133)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:217)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)
at net.penril.hibernate.util.WarehouseUtils.getCreditingList(WarehouseUtils.java:916)
at net.penril.engine.CreditingEngine.creditIntoBeneficiaryCASA(CreditingEngine.java:137)
at net.penril.engine.CreditingEngine.creditIntoBeneficiaryCASA(CreditingEngine.java:88)
at net.penril.scheduler.job.CreditingEngineJob3.execute(CreditingEngineJob3.java:27)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
#2
Updated by Zahir Abd Latif almost 9 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
- % Done changed from 0 to 100
#3
Updated by Zahir Abd Latif almost 9 years ago
- Status changed from Closed - End of life cycle to Pending Customer Feedback
#4
Updated by Zahir Abd Latif almost 9 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Email user to verify based on our finding and purposed solutions.
Issue closed in SCP.