Question

2
Replies
194
Views
Close popover
Siva Gujjula (GujjulaSiva)
Bank Of America

Bank Of America
IN
GujjulaSiva Member since 2014 5 posts
Bank Of America
Posted: November 10, 2020
Last activity: December 10, 2020

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

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)  

Pega Platform 8.4.3 System Administration Financial Services System Administrator