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

BIX process through Command Line fails to Bootstrap

SA-85824

Summary



Business Intelligence Exchange (BIX) extracts through the Command Line fail to Bootstrap.


Error Messages



Warn - VersionedJdbcJarReader - unable to load classes from the database: Cannot create PoolableConnectionFactory ([jcc][10165][10051][4.19.66] Invalid database URL syntax: 
jdbc:db2://DATABASE.HOSTNAME/DATABASE:fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;useJDBC4ColumnNameAndLabelSemantics=2;securityMechanism=13

============ PegaRULES Bootstrap Configuration ============

   Java Version: IBM Corporation 1.7.0

  Configuration: file:/directory/config/prbootstrap.properties

Pega-EngineCode: <none specified>

       Database: DB2/LINUXX8664 SQL1005A

         Driver: IBM Data Server Driver for JDBC and SQLJ 4.19.66

Active CodeSets: (Codeset Versions)

(!) Ignored JNDI Options

(!) Unable to use given database configuration

(!) Unable to locate classes on filesystem

=============== End Bootstrap Configuration ===============

com.pega.pegarules.internal.bootstrap.PRBootstrap

SEVERE: Problem during method invocation (main)

java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.data.internal.access.ExtractImpl


Steps to Reproduce



Execute the BIX through the Command Line.

sh runBIX_Pega7.ksh ORG-CLASS-EXTRACT-RULE 20190717T000000.000 20190722T000000.000 QC

$ODS_BIX_JAVA_HOME/java -Xms2948M -Xmx4096M -classpath ".:$BIX_DIR/${ENV}/Pega7/lib/prbootstrap.jar:$BIX_DIR/${ENV}/Pega7/lib/prdbcp.jar:$BIX_DIR/${ENV}/Pega7/lib/prbootphase2.jar:$BIX_DIR/${ENV}/Pega7/lib/jsr94-1.0.jar:$BIX_DIR/${ENV}/Pega7/lib/db2jcc4.jar:$BIX_DIR/${ENV}/Pega7/lib/db2jcc_license_cisuz.jar" -Djdbc.custom.connection.properties="enableClientAffinitiesList=1;clientRerouteAlternatePortNumber=alcmdsaw2401002,alcmdsaw2401003;clientRerouteAlternatePortNumber=50000,50000;securityMechanism=13"  -Dcom.pega.pegarules.bootstrap.properties.url=./config/prbootstrap.properties -Dpegarules.config=$BIX_DIR/${ENV}/Pega7/config/prconfig.xml -Dpegarules.keyring=$BIX_DIR/${ENV}/Pega7/config/pegarules.keyring -Dpegarules.logging.configuration=$BIX_DIR/${ENV}/Pega7/config/prlogging.xml -Dcom.pega.pegarules.bootstrap.ignorejndi=true com.pega.pegarules.pub.PegaRULES com.pega.pegarules.data.internal.access.ExtractImpl -i $param1 -u $3 -U $4 -c "$6" > ${log_dir}/$logfile  

 STATUS=$?


Root Cause



The JDBC URL was provided incorrectly in the prbootstrap.properties. In DB2, the JDBC URL should be terminated with a semicolon.


Resolution



Perform the following local-change:

Correctly terminate the JDBC URL used in prconfig.xml and prbootstrap.properties.
Suggest Edit

Published December 2, 2021

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