Support #6539
[SCP ID :##3343##] : No Email Notification on SI Scheduler for Consumer dated 26.08.2016
| Status: | Closed - End of life cycle | Start date: | August 26, 2016 | |
|---|---|---|---|---|
| Priority: | High | Due date: | ||
| Assignee: |  Zahir Abd Latif | % Done: | 100% | |
| Category: | MY CORUS | Spent time: | - | |
| Target version: | - |
Description
Hi,
Kindly attend below request:
Seek your assistance to check and confirm whether SI for Consumer today executed or not.
This is because we didn't receive email notification on SI Scheduler for Consumer at 11.05am today.
However, we did receive SI Scheduler notification for Business at 11.10am.
History
#1
Updated by Zahir Abd Latif almost 8 years ago
- Status changed from New - Begin Life Cycle to Pending Customer Feedback
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Update from Hafiz,
Salam Ashikin/Shahrul
Please execute below sql to get information for today SI. We found 12
SI transaction should be executed today(refer attachment)
schema bvuserprd
SELECT SI.OID, HIST.TRNX_ID, USR.NAME, HIST.TRNX_TYPE,
HIST.FROM_ACCOUNT_NO, HIST.TO_ACCOUNT_NO, HIST.AMOUNT, HIST.STATUS,
USR.BUS_PHONE, USR.HOME_PHONE FROM IB_SI SI FULL JOIN
IB_TRANSACTION_HISTORY HIST ON SI.TRNX_ID = HIST.TRNX_ID FULL JOIN
BV_USER_PROFILE USR ON USR.USER_ID = HIST.USER_ID WHERE SI.OID IN
('80', '78', '79', '2500', '2529' , '2325' , '2635' , '2920' , '2706'
, '3043' , '3071' , '2788');
We found error out of memory at scheduler log. please refer below log
2016-08-26 11:04:51,159 ERROR [STDERR] Exception in thread
"consumerScheduler_QuartzSchedulerThread"
2016-08-26 11:04:51,159 ERROR [STDERR] java.lang.OutOfMemoryError
2016-08-26 11:04:51,160 ERROR [STDERR] at
java.util.zip.ZipFile.open(Native Method)
2016-08-26 11:04:51,160 ERROR [STDERR] at
java.util.zip.ZipFile.<init>(ZipFile.java:203)
2016-08-26 11:04:51,160 ERROR [STDERR] at
java.util.jar.JarFile.<init>(JarFile.java:132)
2016-08-26 11:04:51,161 ERROR [STDERR] at
java.util.jar.JarFile.<init>(JarFile.java:97)
2016-08-26 11:04:51,161 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.openJARs(WebappClassLoader.java:1722)
2016-08-26 11:04:51,161 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.findResourceInternal(WebappClassLoader.java:1958)
2016-08-26 11:04:51,162 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1752)
2016-08-26 11:04:51,162 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:869)
2016-08-26 11:04:51,162 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1322)
2016-08-26 11:04:51,162 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)
2016-08-26 11:04:51,163 ERROR [STDERR] at
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
2016-08-26 11:04:51,163 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2924)
2016-08-26 11:04:51,163 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2744)
2016-08-26 11:04:51,163 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2730)
2016-08-26 11:04:51,164 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3744)
2016-08-26 11:04:51,164 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2726)
2016-08-26 11:04:51,164 ERROR [STDERR] at
org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263)
2016-08-26 11:06:53,536 ERROR [STDERR] Exception in thread
"QuartzScheduler_consumerScheduler-kfhib041472158129001_MisfireHandler"
2016-08-26 11:06:53,536 ERROR [STDERR] java.lang.OutOfMemoryError
2016-08-26 11:06:53,537 ERROR [STDERR] at
java.util.zip.ZipFile.open(Native Method)
2016-08-26 11:06:53,537 ERROR [STDERR] at
java.util.zip.ZipFile.<init>(ZipFile.java:203)
2016-08-26 11:06:53,537 ERROR [STDERR] at
java.util.jar.JarFile.<init>(JarFile.java:132)
2016-08-26 11:06:53,538 ERROR [STDERR] at
java.util.jar.JarFile.<init>(JarFile.java:97)
2016-08-26 11:06:53,538 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.openJARs(WebappClassLoader.java:1722)
2016-08-26 11:06:53,538 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.findResourceInternal(WebappClassLoader.java:1958)
2016-08-26 11:06:53,538 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1752)
2016-08-26 11:06:53,539 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:869)
2016-08-26 11:06:53,539 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1322)
2016-08-26 11:06:53,539 ERROR [STDERR] at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)
2016-08-26 11:06:53,539 ERROR [STDERR] at
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
2016-08-26 11:06:53,540 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectMisfiredTriggersInStates(StdJDBCDelegate.java:308)
2016-08-26 11:06:53,540 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobStoreSupport.java:923)
2016-08-26 11:06:53,540 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3123)
2016-08-26 11:06:53,541 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3871)
2016-08-26 11:06:53,541 ERROR [STDERR] at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3891)
2016-08-26 11:27:42,854 INFO
[org.apache.struts.tiles.TilesRequestProcessor] Tiles definition
factory found for request processor ''.
#2
Updated by Zahir Abd Latif almost 8 years ago
- Status changed from Pending Customer Feedback to Closed - End of life cycle
Issue closed in SCP.