1. INFO | 07-11-2018 16:29:07,549 | main | 16 | com.es.ktwelve.rs.cmd.common.Copyright | +-------------------------------------------------+
2.  INFO | 07-11-2018 16:29:07,549 | main | 17 | com.es.ktwelve.rs.cmd.common.Copyright | |                                                 |
3.  INFO | 07-11-2018 16:29:07,549 | main | 18 | com.es.ktwelve.rs.cmd.common.Copyright | |     Job 1                                       |
4.  INFO | 07-11-2018 16:29:07,549 | main | 19 | com.es.ktwelve.rs.cmd.common.Copyright | |     (c) Excelsoft                               |
5.  INFO | 07-11-2018 16:29:07,549 | main | 20 | com.es.ktwelve.rs.cmd.common.Copyright | |                                                 |
6.  INFO | 07-11-2018 16:29:07,549 | main | 21 | com.es.ktwelve.rs.cmd.common.Copyright | +-------------------------------------------------+
7. DEBUG | 07-11-2018 16:29:07,549 | main | 19 | com.es.ktwelve.rs.cmd.init.InitJob | Inside startSchedularJob
8. DEBUG | 07-11-2018 16:29:07,971 | main | 23 | com.es.ktwelve.rs.cmd.init.InitJob |
9. DEBUG | 07-11-2018 16:29:08,909 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1 | 14 | com.es.ktwelve.rs.cmd.task.CMDTask | Inside cllCmdProcess: Current Time : Wed Nov 07 16:29:08 EST 2018
10.  INFO | 07-11-2018 16:29:09,080 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1 | 85 | com.k12rs.cmd.main.CMDProcessor | process() : Maximum Heap Size Available = 1361 MB
11.  INFO | 07-11-2018 16:29:09,080 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1 | 87 | com.k12rs.cmd.main.CMDProcessor | process() : Heap Memory Usage [Pre-Run] = 27MB / 247MB
12.  INFO | 07-11-2018 16:29:09,112 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1 | 102 | com.k12rs.cmd.main.CMDProcessor | process() : Table/View Name from Source Database under Process = PSN_PRODUCT_DETAILS_INR
13. ERROR | 07-11-2018 16:29:09,565 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1 | 195 | com.k12rs.cmd.main.CMDProcessor | process() : Error in processing Table/View : PSN_PRODUCT_DETAILS_INR
14. org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT COUNT(1) FROM reports_user.PSN_PRODUCT_DETAILS_INR]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
15.  
16.         at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
17.         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
18.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
19.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455)
20.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463)
21.         at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:471)
22.         at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:476)
23.         at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:485)
24.         at com.k12rs.cmd.dao.SqlHelper.getRecordCount(SqlHelper.java:40)
25.         at com.k12rs.cmd.main.CMDProcessor.getSourceRecordsCount(CMDProcessor.java:337)
26.         at com.k12rs.cmd.main.CMDProcessor.process(CMDProcessor.java:109)
27.         at com.es.ktwelve.rs.cmd.task.CMDTask.callCmdProcess(CMDTask.java:23)
28.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
29.         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
30.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
31.         at java.lang.reflect.Method.invoke(Unknown Source)
32.         at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
33.         at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
34.         at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
35.         at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
36.         at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)
37. Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
38.  
39.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
40.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
41.         at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
42.         at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:505)
43.         at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223)
44.         at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
45.         at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
46.         at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
47.         at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
48.         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288)
49.         at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1490)
50.         at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
51.         at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440)
52.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
53.         ... 18 more
54.  INFO | 07-11-2018 16:29:09,893 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1 | 276 | com.k12rs.cmd.main.CMDProcessor | process() : Heap Memory Usage [Post-Run] = 41MB / 247MB
55.  INFO | 07-11-2018 16:29:09,893 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1 | 279 | com.k12rs.cmd.main.CMDProcessor |