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

26
Replies
4641
Views
 Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
SHUANGYAO Member since 2010 6 posts
Rbc
Posted: June 28, 2016
Last activity: June 30, 2016
Posted: 28 Jun 2016 14:13 EDT
Last activity: 30 Jun 2016 13:22 EDT
Closed

configure prbootstrap properties file for DB2

Report

I want to know how to configure prbootstrap.properties file for DB2 so that I can run BIX extract from command line.

Message was edited by: Marissa Rogers - Added category

Data Integration Reporting
Posted: 6 years ago
Posted: 28 Jun 2016 14:48 EDT
Arvind Malav (malaa) Technical Manager
Pegasystems Inc.
IN
Report

The link I gave is from Pega 7.1.9, therefore, it should help you as there wont be much difference in this topic.
Posted: 6 years ago
Posted: 28 Jun 2016 14:53 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

I have read and I need detailed settings for DB2 in prbootstrap.properties file NOT oracle.
Posted: 6 years ago
Posted: 28 Jun 2016 15:08 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US
Report

The link does have details about DB2.

Show More

The link does have details about DB2.

  1. In the database/drivers element, change the value to the appropriate driver for your database. For example:
    Database driver Value
    Oracle 9i/10g oracle.jdbc.OracleDriver
    IBM DB/2 Type 4 com.ibm.db2.jcc.DB2Driver
    SQL Server 2005 com.microsoft.sqlserver.jdbc.SQLServerDriver
    SQL Server 2000 com.microsoft.jdbc.sqlserver.SQLServerDriver
    1. In the database/databases/PegaRULES/url element, set the value to the connection URL for your database. Following are examples of the appropriate format for some supported databases:
    1. Database driver
    1. Value
    1. Oracle 10g/11g (Native OCI Client)
    1. jdbc:oracle:oci:@your_tns_name
    1. Oracle 10g/11g (Thin Client)
    1. jdbc:oracle:thin:@myServer:1521:myDatabase
    1. DB/2 (Universal Driver)
    1. jdbc:db2://serverName:port/dbName
    1. SQL Server 2005
    1. jdbc:sqlserver://<your_sql_server_host>:1433;
      SendStringParametersAsUnicode=false; SelectMethod=cursor;
      ProgramName=${NodeName}:${SystemName}.${ConnectionID}

Show Less
Posted: 6 years ago
Posted: 28 Jun 2016 15:15 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

I really appreciate your help, but the above mentioned are for the file of prconfig.xml.  I am talking about prbootstrap.properties file. To be precisely, I need convert below into DB2.  Unless I can ignore below if I have configured inside prconfig.xml.

com.pega.pegarules.bootstrap.allclasses.dbcpsource=example.oracle

example.oracle.url=jdbc:oracle:thin:@hostname:1521:rules11g

example.oracle.username=<username>

example.oracle.password=<password>

oracle.jdbc.class=oracle.jdbc.OracleDriver
Posted: 6 years ago
Posted: 28 Jun 2016 15:26 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US
Report

Replace with the correct url, rulesschema, dataschema, username and password

All you need to do is change the com.pega.pegarules.bootstrap.allclasses.dbcpsource to a name of your choosing, I chose example.db2 to replace example.oracle.  Replace with the correct url, rulesschema, dataschema, username and password.  I added some additional connection parameters to the url that are not included in the link but are needed.  You will want this same url in your prconfig.xml.

com.pega.pegarules.bootstrap.allclasses.dbcpsource=example.db2

example.db2.url=jdbc:db2://serverName:port/dbName:fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;useJDBC4ColumnNameAndLabelSemantics=2;

com.pega.pegarules.bootstrap.allclasses.schema=rulesschema

com.pega.pegarules.bootstrap.datatables.schema=dataschema

example.db2.username=username

example.db2.password=password

db2.jdbc.class=com.ibm.db2.jcc.DB2Driver
Posted: 6 years ago
Posted: 29 Jun 2016 10:55 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

when I ran BIX extract from command line, I have below error messages, could you please help?

-----------------------------------------------------------

C:\Users\530413731\Desktop\BIX>java -version
java version "1.6.0_06"
Java(TM) SE Runtime Environment (build 1.6.0_06-b02)
Java HotSpot(TM) Client VM (build 10.0-b22, mixed mode)

Show More

when I ran BIX extract from command line, I have below error messages, could you please help?

-----------------------------------------------------------

C:\Users\530413731\Desktop\BIX>java -version
java version "1.6.0_06"
Java(TM) SE Runtime Environment (build 1.6.0_06-b02)
Java HotSpot(TM) Client VM (build 10.0-b22, mixed mode)

C:\Users\530413731\Desktop\BIX>java -Xms512m -Xmx768m -classpath ".;C:\Users\530
413731\Desktop\BIX\lib\prbootstrap.jar; C:\Users\530413731\Desktop\BIX\lib\prdbc
p.jar; F:\DB2\new_drivers\db2jcc4.jar; C:\Users\530413731\Desktop\BIX\lib\jsr94-
1.0.jar;%CLASSPATH%" -Dcom.pega.pegarules.bootstrap.properties.url=config\prboot
strap.properties -Dpegarules.config=config\prconfig.xml -Dpegarules.logging.conf
iguration=config\prlogging.xml -Dcom.pega.pegarules.bootstrap.ignorejndi=true co
m.pega.pegarules.pub.PegaRULES com.pega.pegarules.data.internal.access.ExtractIm
pl -i CaseHistoryExtract
Exception in thread "main" java.lang.NoClassDefFoundError: ûXms512m
Caused by: java.lang.ClassNotFoundException: ûXms512m
        at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)

-------------------------------------------------------------------------------------------------------
 


Show Less
Posted: 6 years ago
Posted: 29 Jun 2016 11:56 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US
Report

In your command is there a space between - and Xms512m or did you cut and paste that from somewhere? Seems like there is something there that is causing issue.  You can try retrying it or there is a bix.xml and bix.bat that you could use to execute on windows.

Also the name of your extract rule is not correct.  The -i parameter should be set to the pxInsName of the extract rule.  It should look like something like this:  PEGASAMPLE!SAMPLEEXTRACTXML
Posted: 6 years ago
Posted: 29 Jun 2016 13:16 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

I will check with dev team for the extraction they required. If we want to extract rule with pxInsName of abc, does the -i  parameter should be PEGASAMPLE!abc? please advise.
Posted: 6 years ago
Posted: 29 Jun 2016 13:33 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US
Report

The pxInsName is going to be the class name the extract rule is written on ! extract rule name.  In my case PEGASAMPLE was the class and SAMPLEEXTRACTXML is the name of my rule.  If you open up the rule and then under actions -> view XML you can search for pxInsName in the rule instance.
Posted: 6 years ago
Posted: 29 Jun 2016 14:14 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

now I have below errors.

Is it because my prbootstrap.properties file not configured correctly?

-----------------------------------------

Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.ph

ase2.PRBootstrapImpl

Jun 29, 2016 2:09:53 PM 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:377)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRB

ootstrap.java:663)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga

tingThrowable(PRBootstrap.java:457)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot

strap.java:509)

        at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

Jun 29, 2016 2:09:53 PM 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

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf

(PRBootstrap.java:283)

Show More

now I have below errors.

Is it because my prbootstrap.properties file not configured correctly?

-----------------------------------------

Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.ph

ase2.PRBootstrapImpl

Jun 29, 2016 2:09:53 PM 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:377)

        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRB

ootstrap.java:663)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga

tingThrowable(PRBootstrap.java:457)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot

strap.java:509)

        at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)

Jun 29, 2016 2:09:53 PM 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

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf

(PRBootstrap.java:283)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstra

p.java:373)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstr

ap.java:353)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga

tingThrowable(PRBootstrap.java:458)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot

strap.java:509)

        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.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot

strap.java:515)

        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:283)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstra

p.java:373)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstr

ap.java:353)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga

tingThrowable(PRBootstrap.java:458)

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot

strap.java:509)

        ... 1 more

----------------------------------------------------------


Show Less
Posted: 6 years ago
Posted: 29 Jun 2016 14:20 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US
Report

Please post the complete log as well as the command that you are executing again. 

Posted: 6 years ago
Posted: 29 Jun 2016 15:27 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

C:\Users\530413731\Desktop\BIX>java -Xms512m -Xmx768m -classpath ".;C:\Users\530
413731\Desktop\BIX\lib\prbootstrap.jar; C:\Users\530413731\Desktop\BIX\lib\prdbc
p.jar; F:\DB2\new_drivers\db2jcc4.jar; C:\Users\530413731\Desktop\BIX\lib\jsr94-
1.0.jar;%CLASSPATH%" -Dcom.pega.pegarules.bootstrap.properties.url=config\prboot
strap.properties -Dpegarules.config=config\prconfig.xml -Dpegarules.logging.conf
iguration=config\prlogging.xml -Dcom.pega.pegarules.bootstrap.ignorejndi=true co
m.pega.pegarules.pub.PegaRULES com.pega.pegarules.data.internal.access.ExtractIm
pl -i RBC-USWM-VLM0-WORK!CASHHISTORYEXTRACT
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
19830421: Loading bootstrap properties from config\prbootstrap.properties
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

19830421: Could not find java:comp/env/prbootstrap/ in the local JNDI context, s
kipping prconfig setting lookup
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

Show More

C:\Users\530413731\Desktop\BIX>java -Xms512m -Xmx768m -classpath ".;C:\Users\530
413731\Desktop\BIX\lib\prbootstrap.jar; C:\Users\530413731\Desktop\BIX\lib\prdbc
p.jar; F:\DB2\new_drivers\db2jcc4.jar; C:\Users\530413731\Desktop\BIX\lib\jsr94-
1.0.jar;%CLASSPATH%" -Dcom.pega.pegarules.bootstrap.properties.url=config\prboot
strap.properties -Dpegarules.config=config\prconfig.xml -Dpegarules.logging.conf
iguration=config\prlogging.xml -Dcom.pega.pegarules.bootstrap.ignorejndi=true co
m.pega.pegarules.pub.PegaRULES com.pega.pegarules.data.internal.access.ExtractIm
pl -i RBC-USWM-VLM0-WORK!CASHHISTORYEXTRACT
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
19830421: Loading bootstrap properties from config\prbootstrap.properties
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

19830421: Could not find java:comp/env/prbootstrap/ in the local JNDI context, s
kipping prconfig setting lookup
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.SettingReaderJNDI

19830421: Could not find prbootstrap in the local JNDI context, skipping prconfi
g setting lookup
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
19830421: Bootstrap datatables schema: RXPQ
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
SEVERE: Error creating datasource for prefix "example.db2"; com.pega.pegarules.c
onfigdbcp.dbcp.BasicDataSourceFactory
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421: Engine schema defined in allclasses: RXRF
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421: Engine classes schema: RXRF
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421: Assembled classes schema: RXRF
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421: prbootstrap.properties merged with prbootstrap entries in Data-Admin-S
ystem-Settings
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSou
rce
SEVERE: Error creating datasource for prefix "example.db2"; com.pega.pegarules.c
onfigdbcp.dbcp.BasicDataSourceFactory
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
19830421: Will load phase 2 bootstrap from Pega-EngineCode:07-10-11
C:\Users\530413731\Desktop\BIX\lib\boot\prbootphase2.jar (The system cannot find
the path specified)
Perhaps executing with a non-standard classpath (e.g. JUnit tests)?
Jun 29, 2016 2:09:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
19830421:
============ PegaRULES Bootstrap Configuration ============
           Date: Wed Jun 29 14:09:53 EDT 2016
   Java Version: Sun Microsystems Inc. 1.6.0_06
  Configuration: file:/C:/Users/530413731/Desktop/BIX/config%5cprbootstrap.prope
rties
Pega-EngineCode: 07-10-11

Ignored JNDI Options
Unable to locate classes on filesystem
=============== End Bootstrap Configuration ===============

Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.ph
ase2.PRBootstrapImpl
Jun 29, 2016 2:09:53 PM 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:377)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRB
ootstrap.java:663)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga
tingThrowable(PRBootstrap.java:457)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot
strap.java:509)
        at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
Jun 29, 2016 2:09:53 PM 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
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf
(PRBootstrap.java:283)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstra
p.java:373)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstr
ap.java:353)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga
tingThrowable(PRBootstrap.java:458)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot
strap.java:509)
        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.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot
strap.java:515)
        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:283)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstra
p.java:373)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstr
ap.java:353)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropaga
tingThrowable(PRBootstrap.java:458)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBoot
strap.java:509)
        ... 1 more


Show Less
Posted: 6 years ago
Posted: 29 Jun 2016 15:40 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US
Report

SEVERE: Error creating datasource for prefix "example.db2"; com.pega.pegarules.configdbcp.dbcp.BasicDataSourceFactory

Please post your prbootstrap.properties file.
Posted: 6 years ago
Posted: 29 Jun 2016 15:51 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

# Properties to control bootstrap of PegaRULES ProcessCommander

# These values are needed by logic that must execute before prconfig.xml can be processed and therefore

# must be specified via a different mechanism.

　 

# This file is a simple example of the minimum set of values you need to supply

# in order to load classes into a database and then reference them in a deployed

# PRPC application.

　 

# Merge settings from this file with Data-Admin-System-Settings

initialization.settingsource=merged

　 

##########################################################################

# Loading classes from the database

##########################################################################

# The jndi name of the datasource to be used for loading classes

com.pega.pegarules.bootstrap.allclasses.datasource=java:comp/env/jdbc/PegaRULES

　 

# If a JNDI datasource is not available - for example, if one is running an embedded

# deployment of ProcessCommander or is running a "command-line" utility - the

# the database access information for classloading must be supplied via information

# in this file so that a datasource may be constructed using the Apache dbcp

# package. This should be combined with setting the system property

# com.pega.pegarules.bootstrap.ignorejndi to true.

#

# Properties later in this file provide a framework setting up multiple

Show More

# Properties to control bootstrap of PegaRULES ProcessCommander

# These values are needed by logic that must execute before prconfig.xml can be processed and therefore

# must be specified via a different mechanism.

　 

# This file is a simple example of the minimum set of values you need to supply

# in order to load classes into a database and then reference them in a deployed

# PRPC application.

　 

# Merge settings from this file with Data-Admin-System-Settings

initialization.settingsource=merged

　 

##########################################################################

# Loading classes from the database

##########################################################################

# The jndi name of the datasource to be used for loading classes

com.pega.pegarules.bootstrap.allclasses.datasource=java:comp/env/jdbc/PegaRULES

　 

# If a JNDI datasource is not available - for example, if one is running an embedded

# deployment of ProcessCommander or is running a "command-line" utility - the

# the database access information for classloading must be supplied via information

# in this file so that a datasource may be constructed using the Apache dbcp

# package. This should be combined with setting the system property

# com.pega.pegarules.bootstrap.ignorejndi to true.

#

# Properties later in this file provide a framework setting up multiple

# datasource definitions. Here you should identify which of these definitions

# should be used which JNDI definitions are unavailable.

# Datasource definitions use the naming convention

# <unique-identifier>.<dbtype>.<property>

# where:

# <unique-identifier> is a distinct value that, together with the <dbtype>

# field may be used to identify one specific datasource

# <dbtype> refers to a set of common properties associated with a

# given database type

# <property> is one of the key values needed to access the datasource

# url, username and password must be specified.

# com.pega.pegarules.bootstrap.allclasses.dbcpsource=example.oracle

# example.oracle.url=jdbc:oracle:thin:@hostname:1521:rules11g

# example.oracle.username=<username>

# example.oracle.password=<password>

# oracle.jdbc.class=oracle.jdbc.OracleDriver

com.pega.pegarules.bootstrap.allclasses.dbcpsource=example.db2

example.db2.url=jdbc:db2://<DBServername>:<port>/DBname:fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;useJDBC4ColumnNameAndLabelSemantics=2;

com.pega.pegarules.bootstrap.allclasses.schema=schema1

com.pega.pegarules.bootstrap.datatables.schema=schema2

example.db2.username=*******

example.db2.password=******

db2.jdbc.class=com.ibm.db2.jcc.DB2Driver

 

##########################################################################

# Active CodeSets

##########################################################################

# Code sets (other than Pega-EngineCode) are now specified via Data-Admin-System-Settings, but you can

# override database settings with settings from the file.

com.pega.pegarules.bootstrap.codeset.version.Pega-EngineCode=07-10-11

　 

##########################################################################

# Common datasource properties used to define a datasource

# for Apache dbcp.

#

# The properties driverClassName, url, username and password

# will be supplied based on settings earlier in this file.

##########################################################################

maxActive=10

maxIdle=5

maxWait=-1

poolPreparedStatements=true


Show Less
Posted: 6 years ago
Posted: 29 Jun 2016 16:09 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US
Report

You have masked all of the actual entries here so I cannot tell what is wrong but seems like something in these properties is not correct.  Try connecting to the database using a 3rd party tool using the url, username/password and see if you can connect.

example.db2.url=jdbc:db2://<DBServername>:<port>/DBname:fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;useJDBC4ColumnNameAndLabelSemantics=2;

com.pega.pegarules.bootstrap.allclasses.schema=schema1

com.pega.pegarules.bootstrap.datatables.schema=schema2

example.db2.username=*******

example.db2.password=******
Posted: 6 years ago
Posted: 29 Jun 2016 16:21 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

Ok, I think below info, should be sufficient. The username and password is what I used to connect to DB and there is no problem.

com.pega.pegarules.bootstrap.allclasses.dbcpsource=example.db2

example.db2.url=jdbc:db2://uapegdd10.devfg.ads.com:50005/DXRFFB:fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;useJDBC4ColumnNameAndLabelSemantics=2;

com.pega.pegarules.bootstrap.allclasses.schema=RXRF

com.pega.pegarules.bootstrap.datatables.schema=RXPQ

example.db2.username=pxapp0srv

example.db2.password=*******

db2.jdbc.class=com.ibm.db2.jcc.DB2Driver
Posted: 6 years ago
Updated: 6 years ago
Posted: 29 Jun 2016 19:19 EDT
Updated: 29 Jun 2016 19:21 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US
Report

I don't see anything wrong with how you have this setup.   I looked at the code and it seems like it is failing trying to find the class com.pega.pegarules.configdbcp.dbcp.BasicDataSourceFactory which is in the prdbcp.jar.  In your command please confirm that the JDBC driver and the other jars are actually in the directories specified.  Also please remove the extra spaces in between jars and the beginning .; to see if that helps.  We can see it is finding prbootstrap.jar file so it seems like something else on the classpath.

-classpath ".;C:\Users\530413731\Desktop\BIX\lib\prbootstrap.jar; C:\Users\530413731\Desktop\BIX\lib\prdbcp.jar; F:\DB2\new_drivers\db2jcc4.jar; C:\Users\530413731\Desktop\BIX\lib\jsr94-1.0.jar;%CLASSPATH%"

Also let me know the size of the jars so I can confirm that they are the correct versions of Pega/BIX 7.1.5.
Posted: 6 years ago
Posted: 30 Jun 2016 13:22 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

Thanks Celeste. It did resolve the command line issue, now I have other issues, but I believe it is not relevant to command. Will post my question if I need more help. Again many thanks for all the help from you and other people who helped me on this issue.
Posted: 6 years ago
Posted: 29 Jun 2016 12:51 EDT
Arvind Malav (malaa) Technical Manager
Pegasystems Inc.
IN
Report

Can you first copy paste whole command on notepad and then, from here, you copy the content and run on command line.

It seems, for some reason, a special character is getting appended before Xms512
Posted: 6 years ago
Posted: 28 Jun 2016 14:48 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

I have read and I need detailed settings for DB2 in prbootstrap.properties file NOT oracle.
Posted: 6 years ago
Posted: 29 Jun 2016 13:13 EDT
Shuang Yao (SHUANGYAO) Rbc
Rbc
CA
Report

thanks. I have copied from notepad. But I will retype - as it is always the trouble maker

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