Question

2
Replies
496
Views
deepak.dhanawade Member since 2017 10 posts
EAI Systems India Pvt. Ltd.
Posted: March 28, 2018
Last activity: March 30, 2018
Closed
Solved

Bix database connection error

Hi,

I am getting below error while running bix from command line

C:\BIX\Additional_Products\BIX>echo "Bix Ant Seri Start"
"Bix Ant Seri Start"

C:\BIX\Additional_Products\BIX>call C:\BIX\scripts\bin\ant.bat -f C:\ant -buildf
ile bix.xml
Buildfile: C:\BIX\Additional_Products\BIX\bix.xml

Bix:
[echo] Performing Export
[echo] using java version ${javaVersion}
[java] Mar 28, 2018 12:41:01 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrapDataSource
[java] 1050: Loading bootstrap properties from config/prbootstrap.propertie
s
[java] Mar 28, 2018 12:41:01 PM com.pega.pegarules.internal.bootstrap.Setti
ngReaderJNDI
[java] INFO: Could not find java:comp/env/prbootstrap/ in the local JNDI co
ntext, skipping prconfig setting lookup
[java] Mar 28, 2018 12:41:01 PM com.pega.pegarules.internal.bootstrap.Setti
ngReaderJNDI
[java] INFO: Could not find prbootstrap in the local JNDI context, skipping
prconfig setting lookup
[java] Mar 28, 2018 12:41:01 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrapDataSource
[java] 1050: Bootstrap datatables schema: pegarules.pegadata
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrapDataSource
[java] SEVERE: Unable to connect to database. Will only use properties fro
m file.
[java] java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properl
y ended
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedSt
atement.java:215)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedSt
atement.java:58)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4
CPreparedStatement.java:776)
[java] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Oracl
eStatement.java:897)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl
eStatement.java:1034)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Or
aclePreparedStatement.java:3820)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Oracl
ePreparedStatement.java:3867)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuer
y(OraclePreparedStatementWrapper.java:1502)
[java] at com.pega.pegarules.configdbcp.dbcp.DelegatingPreparedStatemen
t.executeQuery(DelegatingPreparedStatement.java:99)
[java] at com.pega.pegarules.configdbcp.dbcp.DelegatingPreparedStatemen
t.executeQuery(DelegatingPreparedStatement.java:99)
[java] at com.pega.pegarules.internal.bootstrap.SettingReaderDB.getAllC
lassificationSettingsDB(SettingReaderDB.java:87)
[java] at com.pega.pegarules.internal.bootstrap.SettingReaderDB.getSett
ingsDB(SettingReaderDB.java:154)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.g
etBootstrapPropertiesFromDB(PRBootstrapDataSource.java:663)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.g
etBootstrapPropertiesFromDB(PRBootstrapDataSource.java:643)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.g
etBootstrapProperties(PRBootstrapDataSource.java:620)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource.g
etBootstrapProperties(PRBootstrapDataSource.java:614)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.<clinit>(PR
Bootstrap.java:119)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
sorImpl.java:62)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
hodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:498)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.checkForStartup(AppServerBridgeToPega.java:117)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java]
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrapDataSource
[java] 1050: Unable to locate archive.properties properties, setting warVer
sion to -1
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
[java] 1050: Engine schema defined in allclasses: pegarules.pegadata
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
[java] 1050: Engine classes schema: pegarules.pegadata
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
[java] 1050: Assembled classes schema: pegarules.pegadata
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
[java] 1050: prbootstrap.properties merged with prbootstrap entries in Data
-Admin-System-Settings
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
[java] 1050: PRBootstrap.calculateEngineCodeVersionFromDB() - unable to cal
culate codeset version from database: ORA-00933: SQL command not properly ended
[java]
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRMin
iLoader
[java] 1050: Will load phase 2 bootstrap from Pega-EngineCode:
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRMin
iLoader
[java] 1050: PRMiniLoader - unable to load classes from the database: ORA-0
0933: SQL command not properly ended
[java]
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
[java] 1050:
[java] ============ PegaRULES Bootstrap Configuration ============
[java] Date: Wed Mar 28 12:41:02 IST 2018
[java] Java Version: Oracle Corporation 1.8.0_162
[java] Configuration: file:/C:/BIX/Additional_Products/BIX/config/prboots
trap.properties
[java] Pega-EngineCode:
[java] Database: Oracle Oracle Database 11g Enterprise Edition Relea
se 11.2.0.1.0 - Production
[java] With the Partitioning, OLAP, Data Mining and Real Application Testin
g options
[java] Driver: Oracle JDBC driver 12.1.0.1.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] Mar 28, 2018 12:41:02 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
[java] SEVERE: Error initializing PRAppLoader
[java] java.lang.ClassNotFoundException: com.pega.pegarules.internal.bootst
rap.phase2.PRBootstrapImpl
[java] at com.pega.pegarules.internal.bootstrap.PRMiniLoader.loadClass(
PRMiniLoader.java:388)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.loadPhase2B
ootstrapClass(PRBootstrap.java:720)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.checkForSta
rtup(PRBootstrap.java:662)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMetho
dPropagatingThrowable(PRBootstrap.java:408)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java]
[java] Mar 28, 2018 12:41:02 PM com.pega.pegarules.boot.internal.extbridge.
AppServerBridgeToPega
[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.getImplemen
tationOf(PRBootstrap.java:208)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PR
Bootstrap.java:324)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(P
RBootstrap.java:304)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMetho
dPropagatingThrowable(PRBootstrap.java:409)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java]
[java] Exception in thread "main" java.lang.RuntimeException: Problem durin
g method invocation (main)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethod(AppServerBridgeToPega.java:279)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: java.lang.RuntimeException: PRAppLoader was not properly
initialized, unable to load class com.pega.pegarules.data.internal.access.Extrac
tImpl
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getImplemen
tationOf(PRBootstrap.java:208)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getEntry(PR
Bootstrap.java:324)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.getMethod(P
RBootstrap.java:304)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMetho
dPropagatingThrowable(PRBootstrap.java:409)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToP
ega.invokeMethod(AppServerBridgeToPega.java:273)
[java] ... 1 more
[java] C:\BIX\Additional_Products\BIX\lib\boot\prbootphase2.jar (The system
cannot find the path specified)
[java] Perhaps executing with a non-standard classpath (e.g. JUnit tests)?

BUILD FAILED

Thanks,

Deepak

***Updated by moderator: Lochan to add Categories***

Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn