findings scheduler.log.2015-01-27 2015-01-27 16:15:00,058 INFO [net.penril.scheduler.job.OFIReconEngineWin3] (MyScheduler_Worker-5) class net.penril.scheduler.job.OFIReconEngineWin3 scheduled at Tue Jan 27 16:15:00 MYT 2015 fire at Tue Jan 27 16:15:00 MYT 2015 2015-01-27 16:15:00,116 INFO [net.penril.scheduler.job.RFIReconEngineWin3] (MyScheduler_Worker-1) class net.penril.scheduler.job.RFIReconEngineWin3 scheduled at Tue Jan 27 16:15:00 MYT 2015 fire at Tue Jan 27 16:15:00 MYT 2015 2015-01-27 16:15:06,038 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd' 2015-01-27 16:15:06,038 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection user: 'BIB' 2015-01-27 16:15:06,163 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connected 2015-01-27 16:15:06,166 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd' 2015-01-27 16:15:06,166 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection user: 'BIB' 2015-01-27 16:15:06,295 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connected 2015-01-27 16:15:06,297 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd' 2015-01-27 16:15:06,297 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection user: 'BIB' 2015-01-27 16:15:06,372 ERROR [net.penril.engine.RFIReconEngine] (MyScheduler_Worker-1) org.hibernate.NonUniqueResultException: query did not return a unique result: 2 org.hibernate.NonUniqueResultException: query did not return a unique result: 2 at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:844) at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835) at net.penril.hibernate.util.WarehouseUtils.loadRfiEntryByTraceNo(WarehouseUtils.java:985) at net.penril.engine.RFIReconEngine.matchWithEntry(RFIReconEngine.java:214) at net.penril.engine.RFIReconEngine.matchEntryWithReconFile(RFIReconEngine.java:159) at net.penril.engine.RFIReconEngine.reconcileWithGeneratedEntries(RFIReconEngine.java:88) at net.penril.engine.RFIReconEngine.manualReconcileWithGeneratedEntries(RFIReconEngine.java:80) at net.penril.scheduler.job.RFIReconEngineWin3.execute(RFIReconEngineWin3.java:25) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543) 2015-01-27 16:15:06,376 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd' 2015-01-27 16:15:06,376 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection user: 'BIB' 2015-01-27 16:15:06,420 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connected 2015-01-27 16:15:06,450 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd' 2015-01-27 16:15:06,450 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection user: 'BIB' 2015-01-27 16:15:06,484 INFO [org.quartz.jobs.ee.mail.SendMailJob] (MyScheduler_Worker-2) Sending message 'OFI RECONCILIATION PROCESS executed on 27/01/2015 16:15: Successful' to: ibgops@kfh.com.my 2015-01-27 16:15:06,542 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connected 2015-01-27 16:15:06,544 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd' 2015-01-27 16:15:06,544 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection user: 'BIB' 2015-01-27 16:15:06,664 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connected 2015-01-27 16:15:06,668 INFO [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-5) job executed 2015-01-27 16:15:06,789 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connected 2015-01-27 16:15:06,791 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd' 2015-01-27 16:15:06,791 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection user: 'BIB' 2015-01-27 16:15:06,910 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connected 2015-01-27 16:15:06,934 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd' 2015-01-27 16:15:06,934 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection user: 'BIB' 2015-01-27 16:15:06,982 INFO [org.quartz.jobs.ee.mail.SendMailJob] (MyScheduler_Worker-4) Sending message 'null executed on 27/01/2015 16:15: Unsuccessful' to: ibgops@kfh.com.my 2015-01-27 16:15:07,060 INFO [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connected 2015-01-27 16:15:07,063 INFO [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-1) job executed 2015-01-27 16:15:11,230 INFO [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-2) Email sent 2015-01-27 16:15:11,230 INFO [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-2) job executed 2015-01-27 16:15:11,729 INFO [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-4) Email sent 2015-01-27 16:15:11,729 INFO [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-4) job executed 2015-01-27 16:22:45,096 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry 2015-01-27 16:22:45,096 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry 2015-01-27 16:22:45,104 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues 2015-01-27 16:22:45,104 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Transfer Limit : 500000.0 | Amount : 66750.0 2015-01-27 16:22:45,105 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Bank Account No Length validation : 8002549603(10) 2015-01-27 16:22:45,106 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Beneficiary ID Validation 2015-01-27 16:22:45,492 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354145: Transfer 0.10 From 001105017988 to 01-01-001-01-01-41200010 2015-01-27 16:22:45,601 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354146: Transfer 66750.00 From 001105017988 to 01-10-152-01-08-22001501 2015-01-27 16:23:38,440 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry 2015-01-27 16:23:38,440 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry 2015-01-27 16:23:38,446 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues 2015-01-27 16:23:38,447 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Transfer Limit : 500000.0 | Amount : 72500.0 2015-01-27 16:23:38,447 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Bank Account No Length validation : 564119410954(12) 2015-01-27 16:23:38,447 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Beneficiary ID Validation 2015-01-27 16:23:38,840 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354151: Transfer 0.10 From 001105017988 to 01-01-001-01-01-41200010 2015-01-27 16:23:38,940 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354152: Transfer 72500.00 From 001105017988 to 01-10-152-01-08-22001501 2015-01-27 16:32:25,768 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry 2015-01-27 16:32:25,768 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry 2015-01-27 16:32:25,774 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues 2015-01-27 16:32:25,774 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Transfer Limit : 500000.0 | Amount : 2222.77 2015-01-27 16:32:25,774 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Bank Account No Length validation : 164810051006(12) 2015-01-27 16:32:26,166 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354183: Transfer 0.10 From 011103013155 to 01-01-011-01-01-41200010 2015-01-27 16:32:26,290 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354184: Transfer 2222.77 From 011103013155 to 01-10-152-01-08-22001501 2015-01-27 16:34:48,365 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry 2015-01-27 16:34:48,365 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry 2015-01-27 16:34:48,371 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues 2015-01-27 16:34:48,371 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Transfer Limit : 500000.0 | Amount : 150.0 2015-01-27 16:34:48,371 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Bank Account No Length validation : 0540029871595772(16) 2015-01-27 16:34:48,859 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354189: Transfer 0.10 From 017103000011 to 01-01-017-01-01-41200010 2015-01-27 16:34:48,989 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354190: Transfer 150.00 From 017103000011 to 01-10-152-01-08-22001501 2015-01-27 16:35:41,119 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry 2015-01-27 16:35:41,119 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry 2015-01-27 16:35:41,125 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues 2015-01-27 16:35:41,125 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Transfer Limit : 500000.0 | Amount : 243.45 2015-01-27 16:35:41,125 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Bank Account No Length validation : 151017247520(12) 2015-01-27 16:35:42,016 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354197: Transfer 243.45 From 001103036254 to 01-10-152-01-08-22001501 2015-01-27 16:40:09,654 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry 2015-01-27 16:40:09,654 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry 2015-01-27 16:40:09,659 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues 2015-01-27 16:40:09,660 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Transfer Limit : 500000.0 | Amount : 400.0 2015-01-27 16:40:09,660 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Bank Account No Length validation : 4363467004210500(16) 2015-01-27 16:40:10,109 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354206: Transfer 400.00 From 001103014986 to 01-10-152-01-08-22001501 2015-01-27 16:46:12,661 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry 2015-01-27 16:46:12,661 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry 2015-01-27 16:46:12,666 INFO [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues 2015-01-27 16:46:12,667 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Transfer Limit : 500000.0 | Amount : 1000.0 2015-01-27 16:46:12,667 INFO [net.penril.util.IBGGenericUtils] (http-0.0.0.0-4242-2) Bank Account No Length validation : 4365010001715689(16) 2015-01-27 16:46:13,076 INFO [net.penril.engine.TransferFund] (http-0.0.0.0-4242-2) 0000-1008354218: Transfer 1000.00 From 001103014986 to 01-10-152-01-08-22001501 2015-01-27 16:48:19,869 INFO [net.penril.ws.IBGGFS] (http-0.0.0.0-4242-2)