INFO | 07-11-2018 16:29:07,549 | main | 16 | com.es.ktwelve.rs.cmd.common.Copyright | +-------------------------------------------------+ INFO | 07-11-2018 16:29:07,549 | main | 17 | com.es.ktwelve.rs.cmd.common.Copyright | | | INFO | 07-11-2018 16:29:07,549 | main | 18 | com.es.ktwelve.rs.cmd.common.Copyright | | Job 1 | INFO | 07-11-2018 16:29:07,549 | main | 19 | com.es.ktwelve.rs.cmd.common.Copyright | | (c) Excelsoft | INFO | 07-11-2018 16:29:07,549 | main | 20 | com.es.ktwelve.rs.cmd.common.Copyright | | | INFO | 07-11-2018 16:29:07,549 | main | 21 | com.es.ktwelve.rs.cmd.common.Copyright | +-------------------------------------------------+ DEBUG | 07-11-2018 16:29:07,549 | main | 19 | com.es.ktwelve.rs.cmd.init.InitJob | Inside startSchedularJob DEBUG | 07-11-2018 16:29:07,971 | main | 23 | com.es.ktwelve.rs.cmd.init.InitJob | 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 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 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 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 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 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 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:455) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:463) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:471) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:476) at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:485) at com.k12rs.cmd.dao.SqlHelper.getRecordCount(SqlHelper.java:40) at com.k12rs.cmd.main.CMDProcessor.getSourceRecordsCount(CMDProcessor.java:337) at com.k12rs.cmd.main.CMDProcessor.process(CMDProcessor.java:109) at com.es.ktwelve.rs.cmd.task.CMDTask.callCmdProcess(CMDTask.java:23) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273) at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113) at org.quartz.core.JobRunShell.run(JobRunShell.java:207) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560) Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:505) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1490) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:440) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) ... 18 more 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 INFO | 07-11-2018 16:29:09,893 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1 | 279 | com.k12rs.cmd.main.CMDProcessor |