Support Article
BIX process through Command Line fails to Bootstrap
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.
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.