com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database
I am trying to install PRPC Personal edition 7.2.2, the installtion completed successfully without any interruption but I am stuck while trying to launch PRPC (Error 404, resource not available), while checking the console key points what I found-
I am trying to install PRPC Personal edition 7.2.2, the installtion completed successfully without any interruption but I am stuck while trying to launch PRPC (Error 404, resource not available), while checking the console key points what I found-
31-Dec-2016 10:10:04.381 1050 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Loading bootstrap properties from /prbootstrap.properties
org.postgresql.util.PSQLException: ERROR: relation "pr_data_admin" does not exist31-Dec-2016 10:10:04.753 SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database. Will only use properties from file.31-Dec-2016 10:10:04.429 1050 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Bootstrap datatables schema: null31-Dec-2016 10:10:04.419 INFO [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find prconfig in the local JNDI context, skipping prconfig setting lookup31-Dec-2016 10:10:04.410 INFO [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could snot find java:comp/env/prconfig/ in the local JNDI context, skipping prconfig setting lookup31-Dec-2016 10:10:04.401 INFO [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup31-Dec-2016 10:10:04.393 INFO [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipping prconfig setting lookup
31-Dec-2016 10:10:04.419 INFO [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.SettingReaderJNDI. Could not find prconfig in the local JNDI context, skipping prconfig setting lookup
31-Dec-2016 10:10:04.429 1050 [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Bootstrap datatables schema: null
31-Dec-2016 10:10:04.753 SEVERE [localhost-startStop-1] com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource. Unable to connect to database. Will only use properties from file.
org.postgresql.util.PSQLException: ERROR: relation "pr_data_admin" does not exist
From the log it seems very pbvious that datasource can not be reached,please help how to solve this PRConfig.XML is attached
Other details-
OS - Windows 10, 64 bit,PRPC version - 7.2.2 Personal Edition
Pegasystems Inc.
IN
Using the url and the username/password specified can you successfully connect to the database using sqlplus or some other tool?
And not sure this one is relevant , seems to have quite a few hits, e.g. Problems with PostgreSQL9.4 on VM.
Pegasystems Inc.
IN
Hi,
Can you please check have you mention proper DB details in server level.
Example Tomcat with Oracle on context.xml:
<Resource name="jdbc/PegaRULES"
type="javax.sql.DataSource"
username="XXXXX"
password="XXXXXX"
driverClassName="oracle.jdbc.OracleDriver"
maxIdle="2"
maxWait="5000"
url="jdbc:oracle:thin:@localhost:1521:XXXXX"
maxActive="20"
connectionProperties="oracle.jdbc.V8Compatible=true;"/>
UBS
IN
Hello Supraja,
Exactly which file you are talking about here? Did you see the files that I attached in my original post? Are you talking about any of those files?Any help is much appreciated
Thanks
Sayak
Pegasystems Inc.
US
Hello,
Supraja is talking about the Datasource configuration at the server level, for example Datasource configuration is provided in the context.xml file in tomcat server using Resource tag.
Regards,
Mahesh