ERROR | 12-11-2018 02:21:11,963 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-4 | 195 | com.k12rs.cmd.main.CMDProcessor | process() : Error in processing Table/View : PSN_STU_ASSIGN_DETAILS_INR org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT 'studentassignment' as entitytype, STUDENT_ASSIGNMENT_OID,ASSIGNMENT_OID,STUDENT_RUMBA_UUID,CONTENT_ASSET_ID,ISBN_OID,ASSIGNMENT_TYPE,TEST_TYPE,CUSTOMER_ID,CLASS_OID,CREATE_DATE,UPDATE_DATE,ISDELETED,CMD_LastProcessTimeStamp,rownumber FROM (select STUDENT_ASSIGNMENT_OID,ASSIGNMENT_OID,STUDENT_RUMBA_UUID,CONTENT_ASSET_ID,ISBN_OID,replace(REPLACE(replace(replace(ASSIGNMENT_TYPE,CHR(13),''),CHR(10),' '),'\','\\'),',','\,') ASSIGNMENT_TYPE,replace(REPLACE(replace(replace(TEST_TYPE,CHR(13),''),CHR(10),' '),'\','\\'),',','\,') TEST_TYPE,CUSTOMER_ID,CLASS_OID,CREATE_DATE,UPDATE_DATE,ISDELETED,UPDATE_DATE as CMD_LastProcessTimeStamp, ROW_NUMBER() OVER (ORDER BY UPDATE_DATE) as rownumber FROM reports_user.PSN_STU_ASSIGN_DETAILS_INR WHERE UPDATE_DATE >= ? order by UPDATE_DATE) where rownumber > ? and rownumber <= ? order by rownumber]; 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:602) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:796) at com.k12rs.cmd.dao.SqlHelper.executeSqlStatement(SqlHelper.java:28) at com.k12rs.cmd.dataprocessor.ProcessorForDateRange.process(ProcessorForDateRange.java:56) at com.k12rs.cmd.main.CMDProcessor.process(CMDProcessor.java:182) 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) ... 18 more INFO | 12-11-2018 02:21:12,182 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-4 | 276 | com.k12rs.cmd.main.CMDProcessor | process() : Heap Memory Usage [Post-Run] = 102MB / 247MB INFO | 12-11-2018 02:21:12,182 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-4 | 279 | com.k12rs.cmd.main.CMDProcessor |