Question

3
Replies
765
Views
Close popover
florent Dal Bo (florentD)
CGI

CGI
FR
View Profile
florentD Member since 2017 1 post
CGI
Posted: October 9, 2018
Last activity: October 10, 2018
Closed
Solved

Pega 7.40 Installation error : "Caused by: com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing PegaRULES"

Hello,
I'm trying to install PEGA 7.4, but I found some issue after deploying prweb.war.

Once Tomcat started, when I try to go to PEGA's URL, I got that stack trace :

Details:java.lang.RuntimeException : Problem during method invocation (doPost)
java.lang.RuntimeException: Problem during method invocation (doPost)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:279)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:129)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:100)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ExceptionInInitializerError
at com.pega.pegarules.session.internal.PRSessionProviderImpl.getSimpleURLService(PRSessionProviderImpl.java:2601)
at com.pega.pegarules.web.impl.WebStandardImpl.isHttpSimpleURL(WebStandardImpl.java:1521)
at com.pega.pegarules.web.impl.WebStandardImpl.runStaticContentRequest(WebStandardImpl.java:1502)
at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:369)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
... 26 more
Caused by: com.pega.pegarules.pub.PRRuntimeException: Error determining the mode of PRPC install from database.
at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1408)
at com.pega.pegarules.session.internal.simpleurl.SimpleURLServiceSettings.isEnabled(SimpleURLServiceSettings.java:31)
at com.pega.pegarules.session.internal.simpleurl.SimpleURLServiceFactory.(SimpleURLServiceFactory.java:30)
at com.pega.pegarules.session.internal.simpleurl.SimpleURLServiceFactory.(SimpleURLServiceFactory.java:23)
... 38 more
Caused by: com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing PegaRULES
From: (unknown)
at com.pega.pegarules.data.internal.store.DatabaseConfigurationMap.getDBConfig(DatabaseConfigurationMap.java:206)
at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getDBConfig(JdbcConnectionManagerImpl.java:3022)
at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getDataStoreConnection(JdbcConnectionManagerImpl.java:1298)
at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getDataStoreConnection(JdbcConnectionManagerImpl.java:1211)
at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getConnection(JdbcConnectionManagerImpl.java:1173)
at com.pega.pegarules.data.internal.store.rdbms.JdbcConnectionManagerImpl.getConnection(JdbcConnectionManagerImpl.java:372)
at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1398)
... 41 more

Then if I refresh, I got this one :

java.lang.RuntimeException: Problem during method invocation (doPost)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:279)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:129)
at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:100)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NoClassDefFoundError: Could not initialize class com.pega.pegarules.session.internal.simpleurl.SimpleURLServiceFactory
at com.pega.pegarules.session.internal.PRSessionProviderImpl.getSimpleURLService(PRSessionProviderImpl.java:2601)
at com.pega.pegarules.web.impl.WebStandardImpl.isHttpSimpleURL(WebStandardImpl.java:1521)
at com.pega.pegarules.web.impl.WebStandardImpl.runStaticContentRequest(WebStandardImpl.java:1502)
at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:369)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
... 26 more

Could somebody help me with that issue ?
What did I miss ?

Configuration :
PEGA VM : RedHat 7.5 - TomCat 8.5
SQL Server : Azure SQL Server (2014)
Those two VM are on the same subnet.

"prconfig.xml" stay untouched

Pega Platform System Administration Installation and Deployment
Close popover
Moderation Team has archived post
Posted: 2 years ago
Close popover
Manjunatha Anantharaju (Manju_GCS)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN
View Profile

Hi ,


 It looks like it's not able to get the PegaRULES db info from the configuration.


I believe you have completed the Rulebase set up successfully and also Connection to Database aswell?


Have you added the jdbc jar to lib directory of Server?


sample context.xml of mine which works fine with oracle database is below for your refrence:


 


<Context>


 


    <!-- Default set of monitored resources. If one of these changes, the    -->


    <!-- web application will be reloaded.                                   -->


    <WatchedResource>WEB-INF/web.xml</WatchedResource>


    <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>


 


<Resource name="jdbc/PegaRULES"


type="javax.sql.DataSource"


driverClassName="org.postgresql.Driver"


url="jdbc:postgresql://localhost:5432/PEGA730" 


username="PEGA730" 


password="PEGA730" 


maxActive="50"


maxIdle="5"


maxWait="5000"/>


 


 


 


<Environment name="url/initialization/explicittempdir" value="D:/Training/Tools/PRPC730POSTGRES/apache-tomcat-8.5.4/PEGA_TEMP" type="java.lang.String" />


<Environment name="prconfig/database/databases/PegaRULES/defaultSchema" value="pega730" type="java.lang.String" />


<Environment name="prconfig/database/databases/PegaDATA/defaultSchema" value="pega730" type="java.lang.String" />


 


    <!-- Uncomment this to disable session persistence across Tomcat restarts -->


    <!--


    <Manager pathname="" />


    -->


</Context>


 


 

Posted: 2 years ago
Close popover
florent Dal Bo (florentD)
CGI

CGI
FR
View Profile

Hi Komah,


I had already read that topic yesterday, but I saw this morning what was the issue :


In the installation PDF, it said that we need to put that line into context.xml :



<Environment name="prconfig/database/databases/PegaDATA/dataSourceAdmin"
value="java:comp/env/jdbc/AdminPegaDATA"
type="java.lang.String"/>


The correct one is :



<Environment name="prconfig/database/databases/PegaDATA/dataSourceAdmin"
value="java:comp/env/jdbc/AdminPegaRULES"
type="java.lang.String"/>


Many thanks for your help
Share this page Share via LinkedIn Copying...
Copied!