Question

2
Replies
508
Views
Close popover
Deepak Dhanawade (deepak.dhanawade)
EAI Systems India Pvt. Ltd.
Sr. Software Associate
EAI Systems India Pvt. Ltd.
IN
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