Need some help on this error.
SQLException while getting MessageId entries! Caused by: com.sap.sql.log.OpenSQLException: The SQL statement "SELECT "CID","CSECONDARYID","CSTATE","CINCOMING","CCREATIONDATE","CLASTMODIFIEDDATE","CTIMEOUTDATE","CCUSTOMDATA","CINSTANCEID","CENV" FROM "SEE_MSGIDSTOREP7" WHERE "CENV" = ? AND "CCREATIONDATE" >= ? AND "CCREATIONDATE" <= ? ORDER BY "CCREATIONDATE" DESC" contains the semantics error[s]: - 1:121 - the table or view >>SEE_MSGIDSTOREP7<< does not exist
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:37)
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:115)
at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:91)
at com.sap.sql.jdbc.common.AbstractCommonStatement.parseStatement(AbstractCommonStatement.java:476)
at com.sap.sql.jdbc.common.CommonPooledStatement.<init>(CommonPooledStatement.java:236)
at com.sap.sql.jdbc.common.CommonConnectionImpl.prepare(CommonConnectionImpl.java:1522)
at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:258)
at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:79)
at com.seeburger.dt.messageidstore.spi.db.SimpleAccessHandler.buildQueryStatement(SimpleAccessHandler.java:1104)
at com.seeburger.dt.messageidstore.spi.db.SimpleAccessHandler.getByQueryCriteria(SimpleAccessHandler.java:580)
at com.seeburger.xi.workbench.systemstatus.db.MessageIDQueryManager.getResult(MessageIDQueryManager.java:80)
at com.seeburger.xi.workbench.systemstatus.db.MessageIDQueryManager.getSpecificCount(MessageIDQueryManager.java:49)
at com.seeburger.xi.workbench.systemstatus.infoprovider.MessageIDStoreInfoProvider.getMessageIDStoreInfo(MessageIDStoreInfoProvider.java:26)
at com.seeburger.xi.workbench.systemstatus.infoprovider.MessageIDStoreInfoProvider.getInfo(MessageIDStoreInfoProvider.java:41)
at com.seeburger.xi.workbench.systemstatus.infoprovider.OverviewInfoProvider.fillAllInfo(OverviewInfoProvider.java:36)
at com.seeburger.xi.workbench.systemstatus.infoprovider.OverviewInfoProvider.getInfo(OverviewInfoProvider.java:18)
at com.seeburger.xi.workbench.systemstatus.actions.OverviewInfoAction.getSpecificInfo(OverviewInfoAction.java:35)
at com.seeburger.xi.workbench.systemstatus.actions.OverviewInfoAction.run(OverviewInfoAction.java:22)
at com.seeburger.xi.workbench.systemstatus.Controller.service(Controller.java:122)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at com.sap.engine.services.servlets_jsp.server.Invokable.invoke(Invokable.java:66)
at com.sap.engine.services.servlets_jsp.server.security.PrivilegedActionImpl.run(PrivilegedActionImpl.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.runServlet(FilterChainImpl.java:173)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:82)
at com.sap.engine.services.servlets_jsp.server.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:124)
at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:74)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:425)
at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:289)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)
at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:376)
at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:85)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:71)
at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:160)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:71)
at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:67)
at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:71)
at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)
at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:71)
at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:71)
at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)
at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)
at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:71)
at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:295)
at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.run(Processor.java:222)
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
at java.security.AccessController.doPrivileged(Native Method)
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:152)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:247)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.