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 May 26, 2017 - Updated July 13, 2017

Have a question? Get answers now.

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