My MWS server was working perfectly great. But since this morning when I login, it throws following error. Restarts, clearing catch didn’t help to get rid of this weird error.

2011-12-16 15:07:36 EST (dataAccess : WARN) [RID:4] - DependentCache.put() failed
java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

    at com.wm.dd.jdbc.oraclebase.BaseExceptions.createSQLException(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseStatement.commonExecute(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BaseStatement.executeQueryInternal(Unknown Source)
at com.wm.dd.jdbc.oraclebase.BasePreparedStatement.executeQuery(Unknown Source)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQuery(BaseSqlWorker.java:458)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQuery(BaseSqlWorker.java:415)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQuery(BaseSqlWorker.java:391)
at com.webmethods.portal.service.sql.runtime.oracle.CachePutUpdate.executeQuery(CachePutUpdate.java:50)
at com.webmethods.portal.service.sql.core.BaseSqlWorker.executeQueryProcOut(BaseSqlWorker.java:706)
at com.webmethods.portal.service.cache.impl.DBCache.putProc(DBCache.java:147)
at com.webmethods.portal.service.cache.impl.DBCache.put(DBCache.java:263)
at com.webmethods.portal.mech.cache.impl.PresentationCacheMechanics.put(PresentationCacheMechanics.java:341)
at com.webmethods.portal.mech.cache.impl.PresentationCacheMechanics.putContent(PresentationCacheMechanics.java:183)
at com.webmethods.portal.taglib.cache.JSPCacheTag.afterBody(JSPCacheTag.java:98)
at com.webmethods.portal.taglib.PortalTagSupport.doAfterBody(PortalTagSupport.java:101)
at ui.system.popups._jspService(popups.java:1278)
at com.webmethods.portal.framework.presentation.handlers.Jsp.render(Jsp.java:288)
at com.webmethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:330)
at com.webmethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:276)
at com.webmethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:288)
at com.webmethods.rtl.script.nbsp.NBSPage.render(NBSPage.java:317)
at ui.system.html_head.render(html_head.java:186)
at com.webmethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:268)
at com.webmethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:288)
at com.webmethods.portal.framework.presentation.renderers.DefaultRenderer.renderHTMLHead(DefaultRenderer.java:267)
at com.webmethods.portal.framework.presentation.renderers.DefaultRenderer.renderPageStart(DefaultRenderer.java:218)
at com.webmethods.portal.framework.presentation.renderers.DefaultRenderer.render(DefaultRenderer.java:187)
at com.webmethods.portal.framework.presentation.PresentationManager.handlePres(PresentationManager.java:363)
at com.webmethods.portal.framework.dispatch.DispatchManager.pres(DispatchManager.java:618)
at com.webmethods.portal.framework.dispatch.DispatchManager.handle(DispatchManager.java:458)
at com.webmethods.portal.framework.dispatch.DispatchManager.handleDispatch(DispatchManager.java:371)
at com.webmethods.portal.framework.impl.PortalServlet.service(PortalServlet.java:242)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.webmethods.portal.framework.impl.NTLMFilter.doFilter(NTLMFilter.java:50)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at com.webmethods.caf.faces.servlet.GZIPFilter.doFilter(GZIPFilter.java:32)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at com.webmethods.portal.webApplication.WmWebAppContext.handle(WmWebAppContext.java:159)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

2011-12-16 15:07:36 EST (taglibs : WARN) [RID:4] -
java.lang.NullPointerException
at com.webMethods.portal.service.cache.impl.DependentCache.clearDependencies(DependentCache.java:82)
at com.webMethods.portal.mech.cache.impl.PresentationCacheMechanics.put(PresentationCacheMechanics.java:348)
at com.webMethods.portal.mech.cache.impl.PresentationCacheMechanics.putContent(PresentationCacheMechanics.java:183)
at com.webMethods.portal.taglib.cache.JSPCacheTag.afterBody(JSPCacheTag.java:98)
at com.webMethods.portal.taglib.PortalTagSupport.doAfterBody(PortalTagSupport.java:101)
at ui.system.popups._jspService(popups.java:1278)
at com.webMethods.portal.framework.presentation.handlers.Jsp.render(Jsp.java:288)
at com.webMethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:330)
at com.webMethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:276)
at com.webMethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:288)
at com.webMethods.rtl.script.nbsp.NBSPage.render(NBSPage.java:317)
at ui.system.html_head.render(html_head.java:186)
at com.webMethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:268)
at com.webMethods.portal.framework.presentation.handlers.Nbsp.render(Nbsp.java:288)
at com.webMethods.portal.framework.presentation.renderers.DefaultRenderer.renderHTMLHead(DefaultRenderer.java:267)
at com.webMethods.portal.framework.presentation.renderers.DefaultRenderer.renderPageStart(DefaultRenderer.java:218)
at com.webMethods.portal.framework.presentation.renderers.DefaultRenderer.render(DefaultRenderer.java:187)
at com.webMethods.portal.framework.presentation.PresentationManager.handlePres(PresentationManager.java:363)
at com.webMethods.portal.framework.dispatch.DispatchManager.pres(DispatchManager.java:618)
at com.webMethods.portal.framework.dispatch.DispatchManager.handle(DispatchManager.java:458)
at com.webMethods.portal.framework.dispatch.DispatchManager.handleDispatch(DispatchManager.java:371)
at com.webMethods.portal.framework.impl.PortalServlet.service(PortalServlet.java:242)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.webMethods.portal.framework.impl.NTLMFilter.doFilter(NTLMFilter.java:50)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at com.webMethods.caf.faces.servlet.GZIPFilter.doFilter(GZIPFilter.java:32)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at com.webMethods.portal.webApplication.WmWebAppContext.handle(WmWebAppContext.java:159)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

Hi Jaimin,

I think this issue is related to the table ‘TBLCACHEDEP’ in Oracle database, do you have the privilege to access the Oracle database? if yes, you can connect to oracle database using sqlplus and type the following sql.

select * from user_objects where object_type = 'TABLE'; 

Check whether table ‘TBLCACHEDEP’ exist? Can you copy the table list here also?

you can use Software AG Database Component Configurator to re-create the table for MWS. This will re-create the table to resolve the missing table issue.

Regards,
kokchuan