SA-15080

Summary

runPega script with a Pega 7.1 split schema postgreSQL database fails trying to connect to the database.
 

Error Messages

19830421: Insufficient data supplied in prbootstrap.properties to create a datasource
Sep 28, 2015 3:13:05 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
19830421: Missing JDBC driver class setting "postgres.jdbc.class"

Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
Sep 28, 2015 3:13:05 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Error initializing PRAppLoader
java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl

 

Steps to Reproduce

runPega.bat --driver=<your_path to postgresql-9.1-903.jdbc4.jar> --prweb=<your_path to prweb> --propfile=<your_path to prweb\WEB-INF\classes\prbootstrap.properties <JavaClass> <arguments>

Root Cause

A defect or configuration issue in the operating environment. The database connection information supplied in the prbootstrap.properties file is not in the correct format for a postgreSQL database.

Resolution

Make the following change to the operating environment: 

Follow this format when defining your postgresql database connection information. Substitute serverName, port, dbName, dbUser, dbUserPassword, rulesSchema, and dataSchema with the actual values for your environment.

com.pega.pegarules.bootstrap.allclasses.dbcpsource=example.postgres
example.postgres.url=jdbc:postgresql://serverName:port/dbName
example.postgres.username=dbUser
example.postgres.password=dbUserPassword
postgres.jdbc.class=org.postgresql.Driver

com.pega.pegarules.bootstrap.allclasses.schema=rulesSchema
com.pega.pegarules.bootstrap.datatables.schema=dataSchema