findings.txt

Yap Kah Yan, January 29, 2015 09:17

Download (11.1 KB)

 
1
findings
2
scheduler.log.2015-01-27
3

    
4
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
5
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
6
2015-01-27 16:15:06,038 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd'
7
2015-01-27 16:15:06,038 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection user: 'BIB'
8
2015-01-27 16:15:06,163 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connected
9
2015-01-27 16:15:06,166 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd'
10
2015-01-27 16:15:06,166 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection user: 'BIB'
11
2015-01-27 16:15:06,295 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connected
12
2015-01-27 16:15:06,297 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd'
13
2015-01-27 16:15:06,297 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection user: 'BIB'
14
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
15
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
16
	at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:844)
17
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835)
18
	at net.penril.hibernate.util.WarehouseUtils.loadRfiEntryByTraceNo(WarehouseUtils.java:985)
19
	at net.penril.engine.RFIReconEngine.matchWithEntry(RFIReconEngine.java:214)
20
	at net.penril.engine.RFIReconEngine.matchEntryWithReconFile(RFIReconEngine.java:159)
21
	at net.penril.engine.RFIReconEngine.reconcileWithGeneratedEntries(RFIReconEngine.java:88)
22
	at net.penril.engine.RFIReconEngine.manualReconcileWithGeneratedEntries(RFIReconEngine.java:80)
23
	at net.penril.scheduler.job.RFIReconEngineWin3.execute(RFIReconEngineWin3.java:25)
24
	at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
25
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
26
2015-01-27 16:15:06,376 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd'
27
2015-01-27 16:15:06,376 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection user: 'BIB'
28
2015-01-27 16:15:06,420 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connected
29
2015-01-27 16:15:06,450 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd'
30
2015-01-27 16:15:06,450 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connection user: 'BIB'
31
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
32
2015-01-27 16:15:06,542 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connected
33
2015-01-27 16:15:06,544 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd'
34
2015-01-27 16:15:06,544 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection user: 'BIB'
35
2015-01-27 16:15:06,664 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-5) Connected
36
2015-01-27 16:15:06,668 INFO  [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-5) job executed
37
2015-01-27 16:15:06,789 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connected
38
2015-01-27 16:15:06,791 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd'
39
2015-01-27 16:15:06,791 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection user: 'BIB'
40
2015-01-27 16:15:06,910 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connected
41
2015-01-27 16:15:06,934 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection url: 'jdbc:oracle:thin:@kfhib07:1088:ibsprd'
42
2015-01-27 16:15:06,934 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connection user: 'BIB'
43
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
44
2015-01-27 16:15:07,060 INFO  [net.penril.util.DBConnection] (MyScheduler_Worker-1) Connected
45
2015-01-27 16:15:07,063 INFO  [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-1) job executed
46
2015-01-27 16:15:11,230 INFO  [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-2) Email sent
47
2015-01-27 16:15:11,230 INFO  [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-2) job executed
48
2015-01-27 16:15:11,729 INFO  [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-4) Email sent
49
2015-01-27 16:15:11,729 INFO  [net.penril.scheduler.job.SchedulerListener] (MyScheduler_Worker-4) job executed
50
2015-01-27 16:22:45,096 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry
51
2015-01-27 16:22:45,096 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry
52
2015-01-27 16:22:45,104 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues
53
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
54
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)
55
2015-01-27 16:22:45,106 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Beneficiary ID Validation
56
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
57
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
58
2015-01-27 16:23:38,440 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry
59
2015-01-27 16:23:38,440 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry
60
2015-01-27 16:23:38,446 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues
61
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
62
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)
63
2015-01-27 16:23:38,447 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Beneficiary ID Validation
64
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
65
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
66
2015-01-27 16:32:25,768 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry
67
2015-01-27 16:32:25,768 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry
68
2015-01-27 16:32:25,774 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues
69
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
70
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)
71
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
72
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
73
2015-01-27 16:34:48,365 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry
74
2015-01-27 16:34:48,365 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry
75
2015-01-27 16:34:48,371 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues
76
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
77
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)
78
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
79
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
80
2015-01-27 16:35:41,119 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry
81
2015-01-27 16:35:41,119 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry
82
2015-01-27 16:35:41,125 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues
83
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
84
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)
85
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
86
2015-01-27 16:40:09,654 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry
87
2015-01-27 16:40:09,654 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry
88
2015-01-27 16:40:09,659 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues
89
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
90
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)
91
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
92
2015-01-27 16:46:12,661 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) IBG Entry
93
2015-01-27 16:46:12,661 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) assignToIBGEntry
94
2015-01-27 16:46:12,666 INFO  [net.penril.ws.IBGWS] (http-0.0.0.0-4242-2) Method : verifyInputValues
95
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
96
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)
97
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
98
2015-01-27 16:48:19,869 INFO  [net.penril.ws.IBGGFS] (http-0.0.0.0-4242-2)