Support #5813

[SCP ID :##2893##] : OFI & RFI file not available.

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

Status:Closed - End of life cycleStart date:December 11, 2015
Priority:ImmediateDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:MY CORUSSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:

We received user complaint on unavailable files of OFI and RFI files for yesterday's window.

Yesterday's RFI/OFI processing was from DR environemnt. System admin has copied the generated files and reports and transferred
to production folder, however, user claimed there is no file for below :

OFI & RFI Window 3 - File not found / No Data.

RFI Window 4 & Window 5 - File not found / No Data.

Kindly seek your assistance urgently

History

#1 Updated by Zahir Abd Latif almost 9 years ago

  • Status changed from New - Begin Life Cycle to Pending Customer Feedback

Update by Hafiz, Dec 16, 2015 03:16 PM:-

Hi Ashikin

We found error on the logs. It happen because of system cannot retrieve data from database. either due connection or session close.

2015-12-10 11:26:55,818 ERROR [net.penril.engine.GenerateNacha] (MyScheduler_Worker-5) java.lang.ClassCastException: org.hibernate.exception.GenericJDBCException
java.lang.ClassCastException: org.hibernate.exception.GenericJDBCException
at net.penril.engine.NachaWriterReport.retrieveData(NachaWriterReport.java:142)
at net.penril.engine.NachaWriterReport.<init>(NachaWriterReport.java:54)
at net.penril.engine.GenerateNacha.process(GenerateNacha.java:389)
at net.penril.scheduler.job.GenerateNachaWin3.execute(GenerateNachaWin3.java:22)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)

2015-12-10 15:31:15,943 ERROR [net.penril.engine.NachaReader] (MyScheduler_Worker-3) java.lang.ClassCastException: org.hibernate.exception.GenericJDBCException
java.lang.ClassCastException: org.hibernate.exception.GenericJDBCException
at net.penril.engine.NachaReaderReport.retrieveData(NachaReaderReport.java:119)
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)

java.lang.ClassCastException: org.hibernate.exception.GenericJDBCException
    at net.penril.engine.NachaReaderReport.retrieveData(NachaReaderReport.java:119)
    at net.penril.engine.NachaReaderReport.&lt;init&gt;(NachaReaderReport.java:57)
    at net.penril.engine.NachaReader.process(NachaReader.java:295)
    at net.penril.scheduler.job.NachaReaderWin4.execute(NachaReaderWin4.java:22)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
2015-12-10 21:41:01,389 ERROR [net.penril.engine.NachaReader] (MyScheduler_Worker-1) java.lang.ClassCastException: org.hibernate.exception.GenericJDBCException
java.lang.ClassCastException: org.hibernate.exception.GenericJDBCException
    at net.penril.engine.NachaReaderReport.retrieveData(NachaReaderReport.java:119)
    at net.penril.engine.NachaReaderReport.&lt;init&gt;(NachaReaderReport.java:57)
    at net.penril.engine.NachaReader.process(NachaReader.java:295)
    at net.penril.scheduler.job.NachaReaderWin5.execute(NachaReaderWin5.java:22)
    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
  • Assignee changed from Hafizudin MD to Zahir Abd Latif
  • % Done changed from 0 to 100

Issue closed in SCP.

Also available in: Atom PDF