Question
Wipro
US
Last activity: 4 Oct 2018 13:54 EDT
BIX Execution errors
Hi we are using Pega 7.1.6 and BIX 7.1. We are using the command line execution process and followed all the steps mentioned in the user guide. I am getting following error. Can you please let me know the cause for it?
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
[java] May 02, 2016 9:24:15 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Error initializing PRAppLoader
[java] java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
[java] at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:365)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:587)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:386)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:438)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:88)
[java]
[java] May 02, 2016 9:24:15 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
Hi we are using Pega 7.1.6 and BIX 7.1. We are using the command line execution process and followed all the steps mentioned in the user guide. I am getting following error. Can you please let me know the cause for it?
Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
[java] May 02, 2016 9:24:15 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Error initializing PRAppLoader
[java] java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
[java] at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:365)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:587)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:386)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:438)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:88)
[java]
[java] May 02, 2016 9:24:15 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
[java] java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.data.internal.access.ExtractImpl
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:212)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstrap.java:302)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstrap.java:282)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:387)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:438)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:88)
[java]
[java] Exception in thread "main" java.lang.RuntimeException: Problem during method invocation (main)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:444)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:88)
[java] Caused by: java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.data.internal.access.ExtractImpl
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:212)
Message was edited by: Lochan to add Category
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
Pegasystems Inc.
US
Upon reviewing the corresponding SR, we see that it has been resolved. SA-23053 was created as a result of the investigation. Please reference that if you have the same question.
Pegasystems Inc.
US
This looks like a configuration issue. Please post the prbootstrap.properties and prconfig.xml file that you are using. The complete log file from the attempt would also be useful to determine what is wrong in your environment.
Wipro
US
Here is prbootstrap properties
# 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.
# As of 6.1 SP2, settings are available in the database but are not yet the default.
initialization.settingsource=file
#initialization.settingsource=merged
##########################################################################
# Active CodeSets
##########################################################################
# The Engine Code codeset and codeset version
#com.pega.pegarules.bootstrap.codeset.version.Pega-EngineCode=07-10-09
com.pega.pegarules.bootstrap.codeset.version.Pega-EngineCode=07-10-13
# The default Customer codeset and version.
# NOTE: This should always ship from Pega as 06-01-01.
#com.pega.pegarules.bootstrap.codeset.version.Customer=06-01-01
Here is prbootstrap properties
# 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.
# As of 6.1 SP2, settings are available in the database but are not yet the default.
initialization.settingsource=file
#initialization.settingsource=merged
##########################################################################
# Active CodeSets
##########################################################################
# The Engine Code codeset and codeset version
#com.pega.pegarules.bootstrap.codeset.version.Pega-EngineCode=07-10-09
com.pega.pegarules.bootstrap.codeset.version.Pega-EngineCode=07-10-13
# The default Customer codeset and version.
# NOTE: This should always ship from Pega as 06-01-01.
#com.pega.pegarules.bootstrap.codeset.version.Customer=06-01-01
##########################################################################
# Loading classes from the database
##########################################################################
# Loading of PegaRULES engine classes from the database
# the jndi name of the datasource to be used for loading engine classes
#com.pega.pegarules.bootstrap.engineclasses.datasource=java:comp/env/jdbc/PegaRULES
com.pega.pegarules.bootstrap.allclasses.datasource=java:comp/env/jdbc/PegaRULES
# Loading of ProcessCommander assembled rule classes from the database
# the jndi name of the datasource to be used for loading assembled classes
#com.pega.pegarules.bootstrap.assembledclasses.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.engineclasses.dbcpsource=example.oracle
# com.pega.pegarules.bootstrap.assembledclasses.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
##########################################################################
# 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.
##########################################################################
#com.pega.pegarules.bootstrap.ignorejndi=true
#com.pega.pegarules.bootstrap.engineclasses.dbcpsource=pas.oracle
#com.pega.pegarules.bootstrap.assembledclasses.dbcpsource=pas.oracle
com.pega.pegarules.bootstrap.allclasses.dbcpsource=pas.oracle
com.pega.pegarules.bootstrap.allclasses.schema=PegaRULES
com.pega.pegarules.bootstrap.datatables.schema=PegaDATA
#source database details
pas.oracle.url=jdbc:oracle:thin:@<server>:1521/DB
pas.oracle.username="UserID"
pas.oracle.password="PWD"
oracle.jdbc.class=oracle.jdbc.OracleDriver
maxActive=10
maxIdle=5
maxWait=-1
poolPreparedStatements=true
pas.oracle.connectionProperties=oracle.jdbc.V8Compatible=true
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
prconfig file
<?xml version="1.0" encoding="UTF-8"?>
<pegarules>
<env name="Identification/SystemName" value="pega" />
<env name="Initialization/PersistRequestor" value="OnTimeout" />
<env name="Initialization/usenativelibrary" value="true" />
<env name="Initialization/explicitTempDir" value="${pega.tmpdir}" />
<env name="initialization/displayexceptiontraceback" value="true" />
<!-- use the following entry to specify resource adapter logging level at startup, acceptable values: SEVERE,WARN,INFO,CONFIG,FINE,FINER,FINEST -->
<env name="pradapter/logginglevel" value="INFO" />
<env name="agent/enable" value="false" />
<env name="initServices/initEmail" value="false" />
<env name="initServices/initFile" value="false" />
<env name="initServices/initJMS" value="false" />
<env name="initServices/initMQ" value="false" />
<env name="license/enabletracking" value="false" />
<env name="license/snapshotsperhour" value="1" />
<env name="license/writeauditdata" value="false" />
<env name="license/writedatabasecsv" value="false" />
<env name="license/showlicense" value="true" />
<env name="database/baseTable/name" value="pr4_base" />
<!-- use the following to write in specific storage form other than default -->
<env name="database/storageVersion" value="6"/>
<env name="initialization/settingsource" value="merged" />
<env name="fua/conclusionQueryPerformance" value="false" />
<env name="initialization/minimalStartup" value="true" />
<env name="ruleresolution/useclassancestorjoin" value="false" />
<env name="ruleresolution/userulesetindexjoin" value="false" />
<env name="ruleresolution/usejoinsforallclasses" value="false" />
<env name="agent/enable" value="false" />
<env name="fua/enableAssemblyAvoidance" value="false" />
<env name="agent/masteragentenable" value="false" />
<env name="initialization/daemonenable" value="false" />
<env name="usage/usagetrackingenabled" value="false" />
<env name="asyncservices/enable" value="false" />
<env name="/compatibility/BIXUseOptimizedClipboardXML" value="true" />
<env name="/compatibility/BIXdisableForwardChaining" value="true" />
<env name="/compatibility/BIXdisableBackwardChaining" value="false" />
<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<!--
Pegasystems recommends that you use Application Server connection pooling to the database for Websphere and
Weblogic. These examples are provided if you need to use Pega Connection Pooling for Tomcat or for testing purposes.
If you are using Application server connection pooling, there is no longer a need to edit this file.
Oracle 9i (Type 2) oracle.jdbc.OracleDriver jdbc:oracle:oci:@your_tns_name
Oracle 10g (Type 4) oracle.jdbc.OracleDriver jdbc:oracle:thin:@serverName:1521:db
IBM DB/2 Type 4 com.ibm.db2.jcc.DB2Driver jdbc:db2://serverName:port/dbName
SQL Server 2005 com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://serverName:1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR ${SystemName}@${NodeName} ${DBName} #${ConnectionID}
SQL Server 2000 com.microsoft.jdbc.sqlserver.SQLServerDriver jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;SendStringParametersAsUnicode=false;ProgramName=PR ${SystemName}@${NodeName} ${DBName} #${ConnectionID}
-->
<!--Source database-->
<env name="database/drivers" value="oracle.jdbc.OracleDriver" />
<env name="database/databases/PegaRULES/url" value="jdbc:oracle:thin:@<server>:1521/DB" />
<env name="database/databases/PegaRULES/userName" value="User" />
<env name="database/databases/PegaRULES/password" value="PWD" />
<env name="database/databases/PegaDATA/userName" value="User" />
<env name="database/databases/PegaDATA/password" value="PWD" />
<env name="database/databases/PegaRULES/defaultSchema" value="PegaRULES"/>
<env name="database/databases/PegaDATA/defaultSchema" value="PegaDATA"/>
<!--Target database-->
<env name="database/drivers" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<env name="database/databases/TargetDB/url" value="jdbc:sqlserver://<serverr>:1433;databaseName=DBName;SelectMethod=cursor;SendStringParametersAsUnicode=false" />
<env name="database/databases/TargetDB/userName" value="User name" />
<env name="database/databases/TargetDB/password" value="PWD" />
<env name= “compatibility/BIXUseOptimizedClipboardXML” value= “true” />
<env name= “compatibility/BIXUseOptimizedClipboardXML” value= “true”>
<env name=”compatibility/BIXdisableForwardChaining” value = “true” />
<env name=”bix/useHistoryClasses” value=”true” />
</pegarules>
Pegasystems
IN
Please comment this line in prbootstrap.properties
com.pega.pegarules.bootstrap.allclasses.datasource=java:comp/env/jdbc/PegaRULES
Please uncomment these lines in prbootstrap.properties
#com.pega.pegarules.bootstrap.ignorejndi=true
#com.pega.pegarules.bootstrap.engineclasses.dbcpsource=pas.oracle
Wipro
US
I have tried that option and still getting the same error. Here is the full log file.
Bix:
[echo] Performing Export
[echo] using java version 7
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] 19830421: Loading bootstrap properties from ./config/prbootstrap.properties
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421:
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: *=================================================================*
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: prbootstrap.properties entry "initialization.settingsource=file"; note that
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: this excludes use of entries in Data-Admin-System-Settings as prbootstrap settings
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: *=================================================================*
[java]
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] 19830421: Will load phase 2 bootstrap from Pega-EngineCode:07-10-13
I have tried that option and still getting the same error. Here is the full log file.
Bix:
[echo] Performing Export
[echo] using java version 7
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
[java] 19830421: Loading bootstrap properties from ./config/prbootstrap.properties
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421:
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: *=================================================================*
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: prbootstrap.properties entry "initialization.settingsource=file"; note that
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: this excludes use of entries in Data-Admin-System-Settings as prbootstrap settings
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421: *=================================================================*
[java]
[java] May 03, 2016 5:44:40 AM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] 19830421: Will load phase 2 bootstrap from Pega-EngineCode:07-10-13
[java] /app_2/BIX/lib/boot/prbootphase2.jar (No such file or directory)
[java] Perhaps executing with a non-standard classpath (e.g. JUnit tests)?
[java] May 03, 2016 5:44:41 AM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] 19830421: PRMiniLoader - unable to load classes from the database: ORA-00942: table or view does not exist
[java]
[java] May 03, 2016 5:44:41 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] 19830421:
[java] ============ PegaRULES Bootstrap Configuration ============
[java] Date: Tue May 03 05:44:41 CDT 2016
[java] Java Version: Oracle Corporation 1.7.0_91
[java] Configuration: file:/app_2/BIX/config/prbootstrap.properties
[java] Pega-EngineCode: 07-10-13
[java] JDBC Driver: oracle.jdbc.OracleDriver
[java] JDBC URL: jdbc:oracle:thin:@<*******>:1521/<*******************>
[java] JDBC User: "******"
[java] Database: Oracle Oracle Database 11g Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
[java] With the Partitioning, Automatic Storage Management, OLAP, Data Mining
[java] and Real Application Testing options
[java] Driver: Oracle JDBC driver Proprietary information hidden.0
[java]
[java] Ignored JNDI Options
[java] Unable to use given database configuration
[java] Unable to locate classes on filesystem
[java] =============== End Bootstrap Configuration ===============
[java]
[java] Unable to load phase 2 bootstrap class: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
[java] May 03, 2016 5:44:41 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Error initializing PRAppLoader
[java] java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootstrap.phase2.PRBootstrapImpl
[java] at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(PRMiniLoader.java:365)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForStartup(PRBootstrap.java:587)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:386)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:438)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:88)
[java]
[java] May 03, 2016 5:44:41 AM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
[java] java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.data.internal.access.ExtractImpl
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:212)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstrap.java:302)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstrap.java:282)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:387)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:438)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:88)
[java]
[java] Exception in thread "main" java.lang.RuntimeException: Problem during method invocation (main)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:444)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:88)
[java] Caused by: java.lang.RuntimeException: PRAppLoader was not properly initialized, unable to load class com.pega.pegarules.data.internal.access.ExtractImpl
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplementationOf(PRBootstrap.java:212)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PRBootstrap.java:302)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(PRBootstrap.java:282)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:387)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:438)
[java] ... 1 more
Sri.
Pegasystems
IN
The error clearly indicates that it is unable to locate the required tables in the database and schema specified in prbootstrap.properties file. Please see the snippet pasted below from your log. You can check the same by writing a small JDBC program and see if you can access the pr_engineclasses table with the same connection details and schema name.
unable to load classes from the database: ORA-00942: table or view does not exist
Pegasystems Inc.
US
It seems like you replaced the actual database user name, schema names, etc. from the config files before you posted here so we cannot give you specific things to look for but as Rajiv points out it looks like the database user does not have the permissions to access everything that is needed. You can try to connect to sqlplus or some other 3rd party tool as the "User" that you have specified in the prbootstrap and prconfig files and then try to query the "RulesSchemaName".pr_engineclasses table. This database user needs to be able to access tables, views, etc. in both the rules and data schemas. Whatever database user you are using to run your web application will have the correct privileges needed to run BIX from the command line.
Wipro
US
I tried that option now with SQL developer tool and also with a sample java application. In both cases I queried a sample SQL and got the results. I am not sure where the issue is.
select * from PEGA.PR_ENGINECLASSES where pzclass = 'PRSecureLoader.class'
Sri.
Pegasystems Inc.
US
When you logged into SQL developer is that the same user that you specified in the prbootstrap and prconfig files? Also the PEGA schema which is your rules schema, have you specified that as well as the data schema name correctly in prbootstrap and prconfig?
com.pega.pegarules.bootstrap.allclasses.schema=PegaRULES - this should be PEGA per your query above
com.pega.pegarules.bootstrap.datatables.schema=PegaDATA - this needs to be set to actual data schema name
<env name="database/databases/PegaRULES/defaultSchema" value="PegaRULES"/> - this should be PEGA per your query above
<env name="database/databases/PegaDATA/defaultSchema" value="PegaDATA"/> this needs to be set to actual data schema name
Wipro
US
yes I specified the following
in prbootstrap properties
com.pega.pegarules.bootstrap.allclasses.schema=PEGA
com.pega.pegarules.bootstrap.datatables.schema=PEGA_DATA
In prconfig...
<env name="database/databases/PegaRULES/defaultSchema" value="PEGA"/>
<env name="database/databases/PegaDATA/defaultSchema" value="PEGA_DATA"/>
Can we have a quick call to discuss this?
Sri.
Wipro
US
Also we are using java-1.7.0-openjdk- Proprietary information hidden.x86_6 version.
$ java -version
java version "1.7.0_91"
OpenJDK Runtime Environment (rhel- Proprietary information hidden.el6_7-x86_64 u91-b00)
OpenJDK 64-Bit Server VM (build 24.91-b01, mixed mode)
savatapa@apsrd6135:/app_2/BIX
$ echo $JAVA_HOME
/usr/lib/jvm/java-1.7.0-openjdk- Proprietary information hidden.x86_64
savatapa@apsrd6135:/app_2/BIX
$ echo $PATH
/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/opt/pb/bin:/home/savatapa/bin:/usr/lib/jvm/java-1.7.0-openjdk- Proprietary information hidden.x86_64/jre/bin:/app_2/BIX/apache-ant-1.8.2/bin
Pegasystems Inc.
US
If the schema names are defined correctly then it has to be the database user name that is the issue. When you logged into SQL developer and could query the Pega.pr_engineclasses table is that the same user that you specified in the prbootstrap and prconfig files? Oracle is throwing the ora-00942 error so you are cannot be using the same user that you did when you logged into SQL developer.
pas.oracle.username="UserID"
<env name="database/databases/PegaRULES/userName" value="User" />
Wipro
US
The same user is being used for both tools & script. I used the user for SQL tool login, query the tables and log-off and then checked the same with script. But getting the error while using the script extraction process.
Sri.
Pegasystems Inc.
US
Please open an SR so we can figure out what is wrong.
Accepted Solution
Pegasystems Inc.
US
Upon reviewing the corresponding SR, we see that it has been resolved. SA-23053 was created as a result of the investigation. Please reference that if you have the same question.
Pegasystems Inc.
IN
This exception usually occurs when the incorrect path to prbootstrap.properties is provided.
One should always append the file path with file:\\\{path_to_properties}
Example:
-Dcom.pega.pegarules.bootstrap.properties.url="file:\\\C:\BIX\config\prbootstrap.properties"