Question

3
Replies
88
Views
SonalN00 Member since 2017 8 posts
Intel Technology India PVT Ltd
Posted: 1 year ago
Last activity: 1 year 5 months ago
Closed

BIX installation issue on Windows

We are trying to install BIX 7.2.2 on our Windows system with MSSQL server as the backend.

we have made the following changes in the prconfig.xml and prbootstrap.properties file, we are still seeing issues:

prconfig.xml:

<env name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
<env name="database/databases/PegaRULES/url" value="jdbc:sqlserver://sql1234.xyz.com:1433;databaseName=Pega_database;SelectMethod=cursor;SendStringParametersAsUnicode=false"" />
<env name="database/databases/PegaRULES/userName" value="DBUsername" />
<env name="database/databases/PegaRULES/password" value="DBUserPassword" />
<env name="database/databases/PegaRULES/defaultSchema" value="rules" />
<env name="database/databases/PegaDATA/url" value="jdbc:sqlserver://sql1234.xyz.com:1433;databaseName=Pega_database;SelectMethod=cursor;SendStringParametersAsUnicode=false"" />
<env name="database/databases/PegaDATA/userName" value="DBUsername" />
<env name="database/databases/PegaDATA/password" value="DBUserPassword" />
<env name="database/databases/PegaDATA/defaultSchema" value="data" />

prbootstrap.properties:

com.pega.pegarules.bootstrap.allclasses.dbcpsource=example.sql
example.sql.url=jdbc:sqlserver://sql1234.xyz.com:1433;databaseName=Pega_database;SelectMethod=cursor;SendStringParametersAsUnicode=false"
example.sql.username=DBUsername
example.sql.password=DBUserPassword
sql.jdbc.class=com.microsoft.sqlserver.jdbc.SQLServerDriver

com.pega.pegarules.bootstrap.allclasses.schema=rules
com.pega.pegarules.bootstrap.datatables.schema=data

We have set the Classpath in env variables to below:

CLASSPATH : D:\BIX_7.2.2\Additional_Products\BIX\lib\prbootstrap.jar;D:\BIX_7.2.2\Additional_Products\BIX\lib\prbootstrap-api.jar;D:\BIX_7.2.2\Additional_Products\BIX\lib\prdbcp.jar;D:\BIX_7.2.2\Additional_Products\BIX\lib\sqljdbc42.jar;D:\BIX_7.2.2\Additional_Products\BIX\lib\jsr94-1.0.jar

On running below command to start the standalone BIX - we are seeing issues:

java -Dcom.pega.pegarules.bootstrap.properties.url="file:///D:/BIX_7.2.2/Additional_Products/BIX/config/prbootstrap.properties" -Dpegarules.config="./config/prconfig.xml" -Dpegarules.logging.configuration="./config/prlog4j2.xml" -Dcom.pega.pegarules.bootstrap.ignorejndi=true com.pega.pegarules.pub.PegaRULES com.pega.pegarules.data.internal.access.ExtractImpl -i Pega_Sample_Class!Test_Extractrule

Error Seen below:

Apr 12, 2019 1:52:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
1050: Loading bootstrap properties from file:///D:/BIX_7.2.2/Additional_Products
/BIX/config/prbootstrap.properties
Apr 12, 2019 1:52:40 AM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

INFO: Could not find java:comp/env/prbootstrap/ in the local JNDI context, skipp
ing prconfig setting lookup
Apr 12, 2019 1:52:40 AM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

INFO: Could not find prbootstrap in the local JNDI context, skipping prconfig se
tting lookup
Apr 12, 2019 1:52:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
1050: Bootstrap datatables schema: data
Apr 12, 2019 1:52:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
SEVERE: Unable to connect to database. Will only use properties from file.
com.pega.pegarules.configdbcp.dbcp.SQLNestedException: Cannot create PoolableCon
nectionFactory (The property sendStringParametersAsUnicode does not contain a va
lid boolean value. Only true or false can be used.)
at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.createDataSource(B
asicDataSource.java:829)
at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.getConnection(Basi
cDataSource.java:520)
at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootst
rapPropertiesFromDB(PRBootstrapDataSource.java:660)
at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootst
rapPropertiesFromDB(PRBootstrapDataSource.java:643)
at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootst
rapProperties(PRBootstrapDataSource.java:620)
at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.getBootst
rapProperties(PRBootstrapDataSource.java:614)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.<clinit>(PRBootstra
p.java:119)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.chec
kForStartup(AppServerBridgeToPega.java:117)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethod(AppServerBridgeToPega.java:273)
at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The property sendStr
ingParametersAsUnicode does not contain a valid boolean value. Only true or fals
e can be used.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(S
QLServerException.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.booleanPropertyOn(SQ
LServerConnection.java:737)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLS
erverConnection.java:1366)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerCon
nection.java:772)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.
java:1168)
at com.pega.pegarules.configdbcp.dbcp.DriverConnectionFactory.createConn
ection(DriverConnectionFactory.java:39)
at com.pega.pegarules.configdbcp.dbcp.PoolableConnectionFactory.makeObje
ct(PoolableConnectionFactory.java:293)
at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.validateConnection
Factory(BasicDataSource.java:851)
at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.createDataSource(B
asicDataSource.java:825)
... 14 more

Apr 12, 2019 1:52:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
1050: Unable to locate archive.properties properties, setting warVersion to -1
Apr 12, 2019 1:52:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
1050: Engine schema defined in allclasses: rules
Apr 12, 2019 1:52:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
1050: Engine classes schema: rules
Apr 12, 2019 1:52:41 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
1050: Assembled classes schema: rules
Apr 12, 2019 1:52:41 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
1050: prbootstrap.properties merged with prbootstrap entries in Data-Admin-Syste
m-Settings
Apr 12, 2019 1:52:41 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
1050: PRBootstrap.calculateEngineCodeVersionFromDB() - unable to calculate codes
et version from database: Cannot create PoolableConnectionFactory (The property
sendStringParametersAsUnicode does not contain a valid boolean value. Only true
or false can be used.)
Apr 12, 2019 1:52:41 AM com.pega.pegarules.internal.bootstrap.PRMiniLoader
1050: Will load phase 2 bootstrap from Pega-EngineCode:
Apr 12, 2019 1:52:41 AM com.pega.pegarules.internal.bootstrap.PRMiniLoader
1050: PRMiniLoader - unable to load classes from the database: Cannot create Poo
lableConnectionFactory (The property sendStringParametersAsUnicode does not cont
ain a valid boolean value. Only true or false can be used.)
D:\BIX_7.2.2\Additional_Products\BIX\lib\boot\prbootphase2.jar (The system canno
t find the path specified)
Perhaps executing with a non-standard classpath (e.g. JUnit tests)?
com.pega.pegarules.configdbcp.dbcp.SQLNestedException: Cannot create PoolableCon
nectionFactory (The property sendStringParametersAsUnicode does not contain a va
lid boolean value. Only true or false can be used.)
at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.createDataSource(B
asicDataSource.java:829)
at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.getConnection(Basi
cDataSource.java:520)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.printConfiguration(
PRBootstrap.java:772)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRB
ootstrap.java:665)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga
tingThrowable(PRBootstrap.java:408)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethod(AppServerBridgeToPega.java:273)
at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The property sendStr
ingParametersAsUnicode does not contain a valid boolean value. Only true or fals
e can be used.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(S
QLServerException.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.booleanPropertyOn(SQ
LServerConnection.java:737)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLS
erverConnection.java:1366)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerCon
nection.java:772)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.
java:1168)
at com.pega.pegarules.configdbcp.dbcp.DriverConnectionFactory.createConn
ection(DriverConnectionFactory.java:39)
at com.pega.pegarules.configdbcp.dbcp.PoolableConnectionFactory.makeObje
ct(PoolableConnectionFactory.java:293)
at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.validateConnection
Factory(BasicDataSource.java:851)
at com.pega.pegarules.configdbcp.dbcp.BasicDataSource.createDataSource(B
asicDataSource.java:825)
... 7 more
Apr 12, 2019 1:52:41 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
1050:
============ PegaRULES Bootstrap Configuration ============
Date: Fri Apr 12 01:52:41 PDT 2019
Java Version: Oracle Corporation 1.8.0_131
Configuration: file:/D:/BIX_7.2.2/Additional_Products/BIX/config/prbootstrap.p
roperties
Pega-EngineCode:

(!) Ignored JNDI Options
(!) Unable to use given database configuration
(!) Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============

Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.ph
ase2.PRBootstrapImpl
Apr 12, 2019 1:52:41 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
SEVERE: Error initializing PRAppLoader
java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.P
RBootstrapImpl
at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLo
ader.java:388)
at java.lang.ClassLoader.loadClass(Unknown Source)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.loadPhase2Bootstrap
Class(PRBootstrap.java:720)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRB
ootstrap.java:662)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga
tingThrowable(PRBootstrap.java:408)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethod(AppServerBridgeToPega.java:273)
at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

Apr 12, 2019 1:52:41 AM com.pega.pegarules.boot.internal.extbridge.AppServerBrid
geToPega
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
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf
(PRBootstrap.java:208)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstra
p.java:324)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstr
ap.java:304)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga
tingThrowable(PRBootstrap.java:409)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethod(AppServerBridgeToPega.java:273)
at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

Exception in thread "main" java.lang.RuntimeException: Problem during method inv
ocation (main)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethod(AppServerBridgeToPega.java:279)
at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
Caused by: java.lang.RuntimeException: PRAppLoader was not properly initialized,
unable to load class com.pega.pegarules.data.internal.access.ExtractImpl
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf
(PRBootstrap.java:208)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstra
p.java:324)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstr
ap.java:304)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga
tingThrowable(PRBootstrap.java:409)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invo
keMethod(AppServerBridgeToPega.java:273)
... 1 more

Please help to resolve the errors

***Moderator Edit-Vidyaranjan: Updated SR details***

***Edited by Moderator: Pallavi to update platform capability tags***

Pega Platform Data Integration Java and Activities Data Integration SR Exists
Moderation Team has archived post
Share this page LinkedIn