1. 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
2. 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
3.  
4.         at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
5.         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
6.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
7.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
8.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
9.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
10.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)
11.         at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:796)
12.         at com.k12rs.cmd.dao.SqlHelper.executeSqlStatement(SqlHelper.java:28)
13.         at com.k12rs.cmd.dataprocessor.ProcessorForDateRange.process(ProcessorForDateRange.java:56)
14.         at com.k12rs.cmd.main.CMDProcessor.process(CMDProcessor.java:182)
15.         at com.es.ktwelve.rs.cmd.task.CMDTask.callCmdProcess(CMDTask.java:23)
16.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
17.         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
18.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
19.         at java.lang.reflect.Method.invoke(Unknown Source)
20.         at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
21.         at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
22.         at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
23.         at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
24.         at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)
25. Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
26.  
27.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
28.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
29.         at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
30.         at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:505)
31.         at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223)
32.         at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
33.         at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
34.         at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
35.         at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
36.         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288)
37.         at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
38.         at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
39.         at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
40.         at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
41.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
42.         ... 18 more
43.  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
44.  INFO | 12-11-2018 02:21:12,182 | org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-4 | 279 | com.k12rs.cmd.main.CMDProcessor |