Support Article
PRMiniLoader: Unable to load classes from the database
SA-38609
Summary
Business Intelligence Exchange (BIX) is working from command line in one environment, but not in another.
An error is being thrown during startup. This is a split schema configuration.
Error Messages
PRMiniLoader - unable to load classes from the database: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=PZPACKAGE, DRIVER=3.57.82
May 22, 2017 10:56:38 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
Steps to Reproduce
Attempt to run BIX from command line.
Root Cause
The prconfig.xml and prbootstrap.properties files used for BIX were not properly configured, specifically they were missing schema references and data schema definitions.
Resolution
Add the following prbootstrap.properties:
com.pega.pegarules.bootstrap.allclasses.schema=YourRulesSchema
com.pega.pegarules.bootstrap.datatables.schema=YourDataSchema
And the following needed to be added into prconfig.xml:
<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<env name="database/databases/PegaRULES/defaultSchema" value="YourRulesSchema" />
<env name="database/databases/PegaDATA/defaultSchema" value="YourDataSchema" />
<env name="database/databases/PegaDATA/url" value="YourDataSchemaURL" />
<env name="database/databases/PegaDATA/userName" value="YourDataSchemaUser" />
<env name="database/databases/PegaDATA/password" value="YourDataSchemaUserPassword" />
Published July 14, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.