Question
Coforge
IN
Last activity: 10 Dec 2020 14:55 EST
Throwing error - Database-General ORA-00942: table or view does not exist
Hi,
We have freshly installed Pega8.4.3 in new servers, we have provided sufficient privileges to all tables and schemas, we have deployed the ear and started JVM successfully. When we try to login not able to open the login page getting the attached SS saying the below error.
Caused by: com.pega.pegarules.pub.database.DatabaseException: Database-General ORA-00942: table or view does not exist
Hi,
We have freshly installed Pega8.4.3 in new servers, we have provided sufficient privileges to all tables and schemas, we have deployed the ear and started JVM successfully. When we try to login not able to open the login page getting the attached SS saying the below error.
Caused by: com.pega.pegarules.pub.database.DatabaseException: Database-General ORA-00942: table or view does not exist
From: (unknown) at com.pega.pegarules.data.internal.access.PerformaneHelper.initialize(PerformaneHelper.java:81) at com.pega.pegarules.data.internal.access.PerformaneHelper.initiazeAndGet(PerformaneHelper.java:55) ... 101 more ] [11/10/20 13:28:24:946 UTC] 000000c6 LocalTranCoor E WLTC0017E: Resources rolled back due to setRollbackOnly() being called. [11/10/20 13:28:24:947 UTC] 000000c6 webapp E com.ibm.ws.webcontainer.webapp.WebApp logServletError SRVE0293E: [Servlet Error]-[WebStandard]: java.lang.RuntimeException: Problem during method invocation (doPost) at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:280) at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:146) at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at com.pega.pegarules.internal.web.servlet.WebStandardBoot.service(WebStandardBoot.java:172) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1235) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1134) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4219) at com.ibm.ws.webcontainer.webapp.WebAppImpl.handleRequest(WebAppImpl.java:2210) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1030) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:382) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:532) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:318) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:289) at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1187) at com.ibm.ws.ssl.channel.impl.SSLConnectionLink$MyReadCompletedCallback.complete(SSLConnectionLink.java:694) at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1833) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909) Caused by: java.lang.NoClassDefFoundError: com.pega.pegarules.session.internal.authorization.AuthServiceAliasHelper (initialization failure) at java.lang.J9VMInternals.initializationAlreadyFailed(J9VMInternals.java:97) at com.pega.pegarules.session.internal.PRSessionProviderImpl.isAuthServiceAliasPresentInResourcePath(PRSessionProviderImpl.java:2652) at com.pega.pegarules.web.impl.WebStandardImpl.isAuthServiceAliasPresentInResourcePath(WebStandardImpl.java:1652) at com.pega.pegarules.web.impl.WebStandardImpl.runStaticContentRequest(WebStandardImpl.java:1635) at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:395) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)