Integration

Getting the below exception on JDeveloepr 10.1.3.4 embedded oc4j.

[TopLink Info]: 2011.07.20 05:16:31.085--ServerSession(30438180)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--default login successful
[TopLink Finer]: 2011.07.20 05:16:31.085--ServerSession(30438180)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--client acquired
[TopLink Finer]: 2011.07.20 05:16:31.099--ClientSession(26310585)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--acquire unit of work: 21782897
[TopLink Fine]: 2011.07.20 05:16:31.104--ServerSession(30438180)--Connection(604988)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--SELECT LAST_RUN
FROM XX_CRM_MON_LASTRUN
WHERE LAST_RUN = (SELECT MAX(LAST_RUN) FROM XX_CRM_MON_LASTRUN )
[TopLink Fine]: 2011.07.20 05:16:31.151--ServerSession(30438180)--Connection(4393714)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--SELECT REQUEST_ID, OUTBOUND_STATUS, INBOUND_STATUS, STATUS, CREATED_DT, UPDATED_DT FROM XX_CRM_RIDS_2_MONITOR
[TopLink Finer]: 2011.07.20 05:16:31.650--ServerSession(30438180)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--client acquired
[TopLink Finer]: 2011.07.20 05:16:31.650--ClientSession(5884714)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--acquire unit of work: 24768380
[TopLink Finer]: 2011.07.20 05:16:31.655--ServerSession(30438180)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--client acquired
[TopLink Finer]: 2011.07.20 05:16:31.655--ClientSession(19895774)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--acquire unit of work: 15869014
[TopLink Fine]: 2011.07.20 05:16:31.661--ServerSession(30438180)--Connection(604988)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--SELECT * FROM xrx_sp_request_rules WHERE application_name = 'COMPUCOM' and REQUEST_RULE_TYPE='ESR_REPROCESS_INTERVAL'
[TopLink Finer]: 2011.07.20 05:16:31.690--UnitOfWork(15869014)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--release unit of work
Source breakpoint occurred at line 102 of EventMonitorImpl.java.
[TopLink Fine]: 2011.07.20 05:16:38.707--ServerSession(30438180)--Connection(4393714)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--SELECT REQUEST_ID, OUTBOUND_STATUS, INBOUND_STATUS, STATUS, CREATED_DT, UPDATED_DT FROM XX_CRM_RIDS_2_MONITOR WHERE (OUTBOUND_STATUS <> 'SENT')
Source breakpoint occurred at line 222 of EventMonitorImpl.java.
[TopLink Fine]: 2011.07.20 05:16:43.211--ServerSession(30438180)--Connection(604988)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--SELECT re.*
FROM REQUEST_EVENT re,xx_crm_rids_2_monitor mon
WHERE re.request_id = mon.request_id and EVENT_DT >= TO_DATE('02-May-2011')
and TO_DATE(DECODE(TO_CHAR(event_dt), NULL, NULL, DECODE(TO_CHAR(event_dt, 'HH24MISS'), '000000',
TO_CHAR(event_dt, 'YYYYMMDD') || TO_CHAR(event_tm, 'HH24MISS'),
TO_CHAR(event_dt, 'YYYYMMDDHH24MISS'))), 'YYYYMMDDHH24MISS') >= TO_DATE('05-02-2011 01:57:00', 'MM-DD-YYYY HH24:MI:SS')
and (event_type='COMPLT' or event_type='CLOSED')
[TopLink Warning]: 2011.07.20 05:16:43.232--ServerSession(30438180)--Thread(Thread[HTTPThreadGroup-6,5,HTTPThreadGroup])--Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.4.0) (Build 080602)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00942: table or view does not exist
Error Code: 942
Call:SELECT re.*
FROM REQUEST_EVENT re,xx_crm_rids_2_monitor mon
WHERE re.request_id = mon.request_id and EVENT_DT >= TO_DATE('02-May-2011')
and TO_DATE(DECODE(TO_CHAR(event_dt), NULL, NULL, DECODE(TO_CHAR(event_dt, 'HH24MISS'), '000000',
TO_CHAR(event_dt, 'YYYYMMDD') || TO_CHAR(event_tm, 'HH24MISS'),
TO_CHAR(event_dt, 'YYYYMMDDHH24MISS'))), 'YYYYMMDDHH24MISS') >= TO_DATE('05-02-2011 01:57:00', 'MM-DD-YYYY HH24:MI:SS')
and (event_type='COMPLT' or event_type='CLOSED')
Query:ReadAllQuery(com.xxx.office.service.crm.model.RequestEvent)
at oracle.toplink.exceptions.DatabaseException.sqlException(DatabaseException.java:290)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:581)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:441)
at oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:457)
at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:117)
at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:103)
at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:174)
at oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:481)
at oracle.toplink.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:473)
at oracle.toplink.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:812)
at oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:620)
at oracle.toplink.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:780)
at oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:451)
at oracle.toplink.publicinterface.Session.internalExecuteQuery(Session.java:2089)
at oracle.toplink.publicinterface.Session.executeQuery(Session.java:993)
at oracle.toplink.publicinterface.Session.executeQuery(Session.java:965)
at oracle.toplink.publicinterface.Session.executeQuery(Session.java:878)
at oracle.toplink.publicinterface.Session.executeQuery(Session.java:838)
at com.xxx.office.service.crm.eventhandler.impl.EventMonitorImpl.getLatestClosedEvents(EventMonitorImpl.java:225)
at com.xxx.office.service.crm.eventhandler.impl.EventMonitorImpl.checkForClosedRids(EventMonitorImpl.java:136)
at com.xxx.office.service.crm.eventhandler.impl.EventMonitorImpl.execute(EventMonitorImpl.java:103)
at runEventMonitor.jspService(_runEventMonitor.java:53)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:431)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:463)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:742)
at oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:516)
... 38 more