Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sonal N (SonalN00)
Intel Technology India PVT Ltd

Intel Technology India PVT Ltd
IN
SonalN00 Member since 2017 8 posts
Intel Technology India PVT Ltd
Posted: Apr 12, 2019
Last activity: Apr 13, 2019
Posted: 12 Apr 2019 5:12 EDT
Last activity: 13 Apr 2019 17:08 EDT
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:

Show More

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***


Show Less
To see attachments, please log in.
Pega Platform
Java and Activities
Data Integration
Support Case Exists

Posted: 5 years ago
Posted: 12 Apr 2019 5:45 EDT
Sonal N (SonalN00)
Intel Technology India PVT Ltd

Intel Technology India PVT Ltd
IN

Hi,

I went through the link, did not find resolution for my issue. As the connection string for DB and credentials given in prbootstap and config.xml file are the same that we use for Pega app also to connect to backend DB.

But in BIX it is not able to connect to the database.

 

To see attachments, please log in.
Posted: 5 years ago
Posted: 13 Apr 2019 17:08 EDT
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
Pegasystems Inc.
US

 

The error log suggests your issue: SendStringParametersAsUnicode=false" (notice the extra double quote here - remove it and retry)

 

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center 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