Support #5045: [SCP ID :##2505##] : No email generation and report unavailable in Corus ( OFI & RFI process ) - KFH Support - Penril Support System

Support #5045

[SCP ID :##2505##] : No email generation and report unavailable in Corus ( OFI & RFI process )

Added by Ahmad Hazri almost 10 years ago. Updated over 9 years ago.

Status:

Work Completed-End life cycle

Start date:

December 10, 2014

Priority:

Normal

Due date:

Assignee:

Hafizudin MD

% Done:

100%

Category:

MY IBG

Spent time:

Target version:

Description

Hi Hapiz

Kindly attend below request

There is no email generated for OFI window 1 and the report is not available when retrieved from Corus. Futhermore, OFI and RFI recon process for OFI window 1 is also having unsuccessful status.

History

#1 Updated by Zahir Abd Latif over 9 years ago

Dear Hafiz/KFH Support Team,

Kindly assist to update the current status in Redmine.

Thanks.

#2 Updated by Zahir Abd Latif over 9 years ago

Dear Hafiz/KFH Support team,

Please respond and update the current status in Redmine.

Thanks.

#3 Updated by Hafizudin MD over 9 years ago

1) Ofi win1 unsuccessful because of error at database
2) Ofi &Rfi recon win1 cannot execute because cannot found pec12100700.txt & ped12100700.txt at MEPS directory

please refer below log for details

Ofi win 1

2014-12-10 05:01:04,738 INFO [net.penril.engine.GenerateNacha] (MyScheduler_Worker-2) reportDate = 10122014
2014-12-10 05:01:04,771 ERROR [net.penril.engine.GenerateNacha] (MyScheduler_Worker-2) 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.GenerateNachaWin1.execute(GenerateNachaWin1.java:24)
at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)

Ofi recon win 1

2014-12-10 10:15:00,067 INFO  [net.penril.scheduler.job.OFIReconEngineWin1] (MyScheduler_Worker-4) class net.penril.scheduler.job.OFIReconEngineWin1 scheduled at Wed Dec 10 10:15:00 MYT 2014 fire at Wed Dec 10 10:15:00 MYT 2014
2014-12-10 10:15:00,072 ERROR [net.penril.engine.OFIReconEngine] (MyScheduler_Worker-4) java.io.FileNotFoundException: /home/jbadmin/IBGCore/MEPS/MEPSRpt/pec12100700.txt (No such file or directory)
java.io.FileNotFoundException: /home/jbadmin/IBGCore/MEPS/MEPSRpt/pec12100700.txt (No such file or directory)
    at java.io.FileInputStream.open(Native Method)
    at java.io.FileInputStream.&lt;init&gt;(FileInputStream.java:106)
    at java.io.FileInputStream.&lt;init&gt;(FileInputStream.java:66)
    at net.penril.hibernate.util.WarehouseUtils.readFile(WarehouseUtils.java:218)
    at net.penril.engine.OFIReconEngine.matchEntryWithReconFile(OFIReconEngine.java:136)
    at net.penril.engine.OFIReconEngine.reconcileWithGeneratedEntries(OFIReconEngine.java:89)
    at net.penril.engine.OFIReconEngine.manualReconcileWithGeneratedEntries(OFIReconEngine.java:81)
    at net.penril.scheduler.job.OFIReconEngineWin1.execute(OFIReconEngineWin1.java:28)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)

Rfi recon win 1

2014-12-10 10:15:00,137 INFO  [net.penril.scheduler.job.RFIReconEngineWin1] (MyScheduler_Worker-1) class net.penril.scheduler.job.RFIReconEngineWin1 scheduled at Wed Dec 10 10:15:00 MYT 2014 fire at Wed Dec 10 10:15:00 MYT 2014
2014-12-10 10:15:00,139 ERROR [net.penril.engine.RFIReconEngine] (MyScheduler_Worker-1) java.io.FileNotFoundException: /home/jbadmin/IBGCore/MEPS/MEPSRpt/ped12100700.txt (No such file or directory)
java.io.FileNotFoundException: /home/jbadmin/IBGCore/MEPS/MEPSRpt/ped12100700.txt (No such file or directory)
    at java.io.FileInputStream.open(Native Method)
    at java.io.FileInputStream.&lt;init&gt;(FileInputStream.java:106)
    at java.io.FileInputStream.&lt;init&gt;(FileInputStream.java:66)
    at net.penril.hibernate.util.WarehouseUtils.readFile(WarehouseUtils.java:218)
    at net.penril.engine.RFIReconEngine.matchEntryWithReconFile(RFIReconEngine.java:135)
    at net.penril.engine.RFIReconEngine.reconcileWithGeneratedEntries(RFIReconEngine.java:88)
    at net.penril.engine.RFIReconEngine.manualReconcileWithGeneratedEntries(RFIReconEngine.java:80)
    at net.penril.scheduler.job.RFIReconEngineWin1.execute(RFIReconEngineWin1.java:27)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)

#4 Updated by Zahir Abd Latif over 9 years ago

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

#5 Updated by Hafizudin MD over 9 years ago

Hi Ashikin/Surianie,

Patches for issue is ready to deploy. Please get patches from below path:-

\\10.20.8.35\InternetBanking\Production\20150119_2505_no_email_and_report

#6 Updated by Zahir Abd Latif over 9 years ago

Status changed from Development / Work In Progress to Work Completed-End life cycle
% Done changed from 0 to 100

Dear Hafiz,

Please provide Root cause and Solution for our record and monitoring purposes.

Refer email : Re: [Request ID :##2505##] : No email generation and report unavailable in Corus ( OFI & RFI process )

Case closed.

#7 Updated by Hafizudin MD over 9 years ago

root course

1) Ofi win1 unsuccessful because of error at hibernate when get data from database
2) Ofi &Rfi recon win1 cannot execute because cannot found pec12100700.txt & ped12100700.txt at MEPS directory

solution

1) advice from chee ping change throw exception. so can detect root error of hibernate later
2) the no solution for issue no. 2. because the system is not found that file and not system error

Also available in: Atom PDF

B - Production Support » KFH Support

Issues