Support #4806

[SCP ID :##2469##] : IBG OFI w1 process report not generated and available at CORUS (ONG111120140700.txt).

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

Status:Closed - End of life cycleStart date:February 10, 2015
Priority:UrgentDue date:February 10, 2015
Assignee:Zahir Abd Latif% Done:

100%

Category:MY CORUSSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:

Report not available at Corus and no email notification received after files have been successfully processed at 6am (11/11/2014)

History

#1 Updated by Nor Shuhaida Subri almost 10 years ago

  • Assignee changed from Nor Shuhaida Subri to Hafizudin MD

#2 Updated by Zahir Abd Latif almost 10 years ago

Dear Hafiz,

Kindly assist to update the current status of this issue no response since November 11, 2014.

Thanks.

#3 Updated by Zahir Abd Latif almost 10 years ago

  • Status changed from New - Begin Life Cycle to Closed - End of life cycle
  • % Done changed from 0 to 100

Refer email :Re: [Request ID :##2469##] : IBG OFI w1 process report not generated and available at CORUS (ONG111120140700.txt)

Case Closed.

#4 Updated by Zahir Abd Latif over 9 years ago

  • Status changed from Closed - End of life cycle to Development / Work In Progress

Dear Hafiz,

Refer from last customer email on Dec 24, 2014 11:32 AM :Re: [Request ID :##2469##] : IBG OFI w1 process report not generated and available at CORUS (ONG111120140700.txt)

From Norashikin:
Last discussion with Hafiz, he needed the executable (.sh) file to further check on the issue. We have placed the executable at \\10.20.8.124\Shared\11122014_IBGCore\IBGCore.

Please update the current status in Redmine.
Please help to follow up to see whether we can closed this case or update the status.

Thanks.

#5 Updated by Norhaidah Md Dasuki over 9 years ago

11/11/14 - Updated by Hafiz,
From our investigation.. found the report fail to generate because of database error..

2014-11-11 06:01:10,427 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:376)
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)

our solution..
deploy menu util for report(similar to IBG_Core menu) to generate missing report.. only IBG_Core is effected for this changes (approval to deploy the shell script menu into production, since there is restriction to run from development and change the database pointing to production. done by IT)

We also advise IT to deploy this patches.
\\10.20.8.35\InternetBanking\Production\20141111_IBG_missing_report

7/1/14 - informed IT to fix path inside IBG_Rpt.sh
please replace IBG_Rpt.sh. change mod to 755(chmod 755)

#6 Updated by Zahir Abd Latif over 9 years ago

  • Status changed from Development / Work In Progress to Pending Customer Feedback

IT have scheduled the activity to apply the fixes on Thurday night, 15/01/2015 .

#7 Updated by Zahir Abd Latif over 9 years ago

Informed from Norashikin 26/1/2015,

Been informed by system admin that the patches yet to be deployed since on the scheduled date, Penril support engineer has advised us to hold 
the patches from being deployed since at that time we were facing a lot of issues on IBG. 
Have discussed with system admin earlier today, the patches is re-scheduled to be deployed this coming Thursday, 29/01/2015.

#8 Updated by Zahir Abd Latif over 9 years ago

Informed from Adhamuddin 05/02/2015,

Still unable to execute. below error prompted.

#9 Updated by Norhaidah Md Dasuki over 9 years ago

  • Due date set to February 10, 2015
  • Status changed from Pending Customer Feedback to Development / Work In Progress
  • Priority changed from Normal to Urgent
  • Start date changed from November 11, 2014 to February 10, 2015
  • % Done changed from 100 to 80

Hafiz, Kindly liaise with IT on the difficulty they faced during the deployment.

#10 Updated by Zahir Abd Latif over 9 years ago

Dear Hafiz,

Any updates regarding error prompted?

Thanks.

#11 Updated by Hafizudin MD over 9 years ago

Fix .sh file on ibg report.
Ask Adhamuddin to test the generate report function.

Root Cause: Required library not imported in .sh file (IBG_Rpt.sh)
Fix: To add quartz-all-1.7.0.jar in IBG_Rpt.sh

#12 Updated by Zahir Abd Latif over 9 years ago

  • Status changed from Development / Work In Progress to Closed - End of life cycle
  • Assignee changed from Hafizudin MD to Zahir Abd Latif
  • % Done changed from 80 to 100

Email from Adhamuddin, Apr 21, 2015 08:31 AM:-

Dear Team, 

Manage to re-gen OFI W1 process report dated 11 Nov 2014 
Report is available inside the folder. 

Thanks for the assistance given.

Also available in: Atom PDF