Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Split-schema installation "No datasource available"

SA-5525

Summary



Database issue installing Pega 7.1.7 with split schema using the command: PRPCInstall setup.sh
with the below parameters:

pega.jdbc.username=PRPCAdmin
pega.jdbc.password=pega
rules.schema.name=PRPCRules
data.schema.name=PRPCData

The installation does not work. The Pega log displays errors.


Error Messages



[java] Database not configured or usable for storing classes.

Processing Configuration Files:

[propertyfile] Creating new property file: /usr/IBM/distrib/PRPC/scripts/PegaInstallTemp-08-December-2014-12.57.43/prbootstrap.properties
Error while creating properties file
[java] Generating benchmark file and skipping comparisons...

Configuration:

[echo] Database Type: oracledate
[echo] JDBC Driver JAR: /usr/IBM/WebSphere/AppServer/lib/ext/ojdbc6.jar
[echo] Bootstrap Config: ./PegaInstallTemp-08-December-2014-12.57.43/prbootstrap.properties
[echo] PegaRULES Config: ./PegaInstallTemp-08-December-2014-12.57.43/prconfig.xml
[echo] PegaRULES Logging Config: ./PegaInstallTemp-08-December-2014-12.57.43/prlogging.xml
[java] Generating benchmark file and skipping comparisons...

Generate DDL:

[echo] rules.schema=PRPC
[echo] data.schema=PRPC


Engine Load Inner:

[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] SEVERE: Problem accessing bootstrap properties via URL "file:/./PegaInstallTemp-08-December-2014-12.57.43/prbootstrap.properties"
[java] Throwable occurred: java.io.FileNotFoundException: /./PegaInstallTemp-08-December-2014-12.57.43/prbootstrap.properties (No such file or directory)
[java] at java.io.FileInputStream.<init>(FileInputStream.java:137)
[java] at java.io.FileInputStream.<init>(FileInputStream.java:96)
[java] at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:82)
[java] at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:173)
[java] at java.net.URL.openStream(URL.java:1022)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootstrapPropertiesFromFile(PRBootstrapDataSource.java:746)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootstrapProperties(PRBootstrapDataSource.java:566)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.<clinit>(PRBootstrap.java:112)
[java] at java.lang.J9VMInternals.initializeImpl(Native Method)
[java] at java.lang.J9VMInternals.initialize(J9VMInternals.java:237)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootstrapProperties(PRBootstrapDataSource.java:560)
[java] at com.pega.pegarules.internal.bootstrap.phase2.util.JarLoaderTool.initDBConnection(JarLoaderTool.java:1767)
[java] at com.pega.pegarules.internal.bootstrap.phase2.util.JarLoaderTool.mainImpl(JarLoaderTool.java:1338)
[java] at com.pega.pegarules.internal.bootstrap.phase2.util.JarLoaderTool.main(JarLoaderTool.java:1096)
[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] 19830421: Unable to locate bootstrap properties, continuing with no property file
[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] 19830421: Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipping prconfig setting lookup
[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] 19830421: Could not find prbootstrap in the local JNDI context, skipping prconfig setting lookup
[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: Engine schema defined in allclasses: null
[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] 19830421: Could not find java:comp/env/prconfig/ in the local JNDI context, skipping prconfig setting lookup
[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI
[java] 19830421: Could not find prconfig in the local JNDI context, skipping prconfig setting lookup
[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: Engine classes schema: null
[java] Dec 8, 2014 12:58:59 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: Assembled classes schema: null
[java] java.sql.SQLException: No datasource available
[java] at com.pega.pegarules.internal.bootstrap.phase2.jdbc.JdbcJarWriter$WriteConnection.getConnection(JdbcJarWriter.java:889)
[java] at com.pega.pegarules.internal.bootstrap.phase2.jdbc.JdbcJarWriter.<init>(JdbcJarWriter.java:800)
[java] at com.pega.pegarules.internal.bootstrap.phase2.util.JarLoaderTool.initDBConnection(JarLoaderTool.java:1803)
[java] at com.pega.pegarules.internal.bootstrap.phase2.util.JarLoaderTool.mainImpl(JarLoaderTool.java:1338)
[java] at com.pega.pegarules.internal.bootstrap.phase2.util.JarLoaderTool.main(JarLoaderTool.java:1096)
[java] Database not configured or usable for storing classes.


Steps to Reproduce



Run java -jar PRPC_Setup.jar.



Root Cause



The root cause of this problem is defect or misconfiguration in the PRPC operating environment. The issue was due to insufficient privileges granted to the user during installation.



Resolution



Use the system user.

Refer to Pega 7.1.7 Installation Guide for the database application you are using, the section Database Configuration > Create Users > the Privilege step.

For example: https://pdn.pega.com/documents/pega-717-installation-guide-for-websphere-on-oracle, pages 19 - 20

The table in the installation guide indicates the permissions are required for the database users for both single and split-schema installations.
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us