Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Vicky Zheng (VickyZ55)
RBC Inc.

RBC Inc.
CA
VickyZ55 Member since 2016 2 posts
RBC Inc.
Posted: Dec 1, 2016
Last activity: Jan 19, 2017
Posted: 1 Dec 2016 14:37 EST
Last activity: 19 Jan 2017 1:39 EST
Closed
Solved

Pega start with error

Hello,

   I'm the new pega learner and just installed Pega PersonalEdition on my computer. However the pega startup display a lot of error message and I'm not able to see the web page.

Here is the some error message:

Show More

Hello,

   I'm the new pega learner and just installed Pega PersonalEdition on my computer. However the pega startup display a lot of error message and I'm not able to see the web page.

Here is the some error message:

01-Dec-2016 14:16:52.983 19830421 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Bootstrap datatables schema: null
01-Dec-2016 14:16:53.093 SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database.  Will only use properties from file.
 java.sql.SQLException: Cannot create PoolableConnectionFactory (FATAL: the database system is starting up)
 at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2293)
 at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2038)
 at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1532)
 at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootstrapPropertiesFromDB(PRBootstrapDataSource.java:669)
 at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootstrapPropertiesFromDB(PRBootstrapDataSource.java:652)
 at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootstrapProperties(PRBootstrapDataSource.java:629)
 at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootstrapProperties(PRBootstrapDataSource.java:623)
 at com.pega.pegarules.internal.bootstrap.PRBootstrap.<clinit>(PRBootstrap.java:119)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.checkForStartup(AppServerBridgeToPega.java:117)
 at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
 at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
 at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextInitialized(WebAppLifeCycleListenerBoot.java:83)
 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4738)
 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5181)
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
 at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
 at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
 at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:945)
 at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1798)
 at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
 at java.util.concurrent.FutureTask.run(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
 at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: FATAL: the database system is starting up
 at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:427)
 at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:203)
 at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
 at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
 at org.postgresql.Driver.makeConnection(Driver.java:415)
 at org.postgresql.Driver.connect(Driver.java:283)
 at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:255)
 at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2303)
 at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2289)

 

Thanks for the help.

Vicky

 


Show Less
To see attachments, please log in.
System Administration
Data Integration

Posted: 7 years ago
Posted: 1 Dec 2016 22:29 EST
Sai Boyana (boyas)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Vicky,

Can you review your database configurations in context.xml file in conf folder of your tomcat server.

To see attachments, please log in.
Posted: 7 years ago
Posted: 2 Dec 2016 13:54 EST
Wai-Kei Kwok (WaikeiKwok_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US

Looks to me that the Postgres DB is still starting up.  Can you find the tool pgadmin and see if you can connect to the DB?

 

Show More

Looks to me that the Postgres DB is still starting up.  Can you find the tool pgadmin and see if you can connect to the DB?

 

Caused by: org.postgresql.util.PSQLException: FATAL: the database system is starting up
 at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:427)
 at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:203)
 at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
 at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:159)
 at org.postgresql.Driver.makeConnection(Driver.java:415)
 at org.postgresql.Driver.connect(Driver.java:283)
 at org.apache.tomcat.dbcp.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:255)
 at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2303)
 at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2289)


Show Less
To see attachments, please log in.
Posted: 7 years ago
Posted: 5 Dec 2016 10:59 EST
Vicky Zheng (VickyZ55)
RBC Inc.

RBC Inc.
CA

There are 3 context.xml file I found in the pega installation folder.

One file looks contain the database config. 

I didn't make any change after installed the pega personal edition. 

The error message show up when I run the startUp script.

Please see the content of context.xml which locate at   .\\tomcat\conf\

<?xml version="1.0" encoding="UTF-8"?>

<!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. -->

<!-- The contents of this file will be loaded for each web application -->

-<Context>

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


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

Show More

There are 3 context.xml file I found in the pega installation folder.

One file looks contain the database config. 

I didn't make any change after installed the pega personal edition. 

The error message show up when I run the startUp script.

Please see the content of context.xml which locate at   .\\tomcat\conf\

<?xml version="1.0" encoding="UTF-8"?>

<!-- Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. -->

<!-- The contents of this file will be loaded for each web application -->

-<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>

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


<Manager pathname=""/>

<!-- Uncomment this to enable Comet connection tacking (provides events on session expiration as well as webapp lifecycle) -->


<!-- <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" /> -->


<Resource password="pega" username="pega" url="jdbc:postgresql://localhost:5432/pega" driverClassName="org.postgresql.Driver" maxWait="10000" maxIdle="30" maxActive="100" type="javax.sql.DataSource" auth="Container" name="jdbc/PegaRULES"/>

<Environment type="java.lang.String" name="url/initialization/explicittempdir" value="C:\pega\PRPCPersonalEdition\temp"/>

</Context>

 

Thanks,

Vicky


Show Less
To see attachments, please log in.
Posted: 7 years ago
Posted: 7 Dec 2016 2:36 EST
Sai Boyana (boyas)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Vicky,

 

Are you able to access the postgress db through command line/PGadmin(Postgress admin) with the provided credentials in context.xml

To see attachments, please log in.
Posted: 7 years ago
Posted: 19 Jan 2017 1:39 EST
Ratan Balaji (Ratan)
Areteans Technology Solutions
Associate Director - Client Engagement
Areteans Technology Solutions
AU

Hi,

Tried reinstalling twice, yet no change. Still facing the same issue. Help is much appreciated.

Thanks,

Ratan

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice