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

 Deepak Dhanawade (DeepakD19)
Clover Infotech

Clover Infotech
IN
DeepakD19 Member since 2021 11 posts
Clover Infotech
Posted: Mar 27, 2018
Last activity: Mar 28, 2018
Posted: 27 Mar 2018 7:22 EDT
Last activity: 28 Mar 2018 2:53 EDT
Closed

Running BIX as a stand alone from command line

Hi,

I want to extract data from database using BIX, We have created extract rules and that is working fine manually by running rule from designer studio,but now our requirement is from command line i have done all configurations required,how to run as a standalone can u suggest me?

Thanks,

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

To see attachments, please log in.
Data Integration
Reporting

Posted: 6 years ago
Posted: 27 Mar 2018 9:17 EDT
Mahesh Midthuru (Mahesh Midthuru)
PEGA
Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Deepak,

You can find the BIX related user guide for your specific version of BIX over here. I can see a section "Stand-alone command-line BIX extractions" in the user guide.

Hope this is what you are looking for.

Regards

Mahesh

To see attachments, please log in.
Posted: 6 years ago
Posted: 28 Mar 2018 0:26 EDT
Deepak Dhanawade (DeepakD19)
Clover Infotech

Clover Infotech
IN

Hi Mahesh_Midthuru,

I have gone through BIX user guide and i have also done all the file configurations but i am confused in what command i have to use to

run BIX and how to use that command using command line.

 

Regards,

Deepak Dhanawade

To see attachments, please log in.
Posted: 6 years ago
Posted: 28 Mar 2018 2:53 EDT
Deepak Dhanawade (DeepakD19)
Clover Infotech

Clover Infotech
IN

Hi,

I am getting below error When am trying to run the BIX extract from windows 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

Show More

Hi,

I am getting below error When am trying to run the BIX extract from windows 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:19:49 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrapDataSource
     [java] 1050: Loading bootstrap properties from config/prbootstrap.propertie
s
     [java] Mar 28, 2018 12:19:49 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:19:49 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:19:49 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrapDataSource
     [java] 1050: Bootstrap datatables schema: dataSchema
     [java] Mar 28, 2018 12:19:49 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-00942: table or view does not
exist
     [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:19:49 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:19:49 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
     [java] 1050: Engine schema defined in allclasses: ruleSchema
     [java] Mar 28, 2018 12:19:49 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
     [java] 1050: Engine classes schema: ruleSchema
     [java] Mar 28, 2018 12:19:49 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
     [java] 1050: Assembled classes schema: ruleSchema
     [java] Mar 28, 2018 12:19:49 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:19:49 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
     [java] 1050: PRBootstrap.calculateEngineCodeVersionFromDB() - unable to cal
culate codeset version from database: ORA-00942: table or view does not exist
     [java]
     [java] Mar 28, 2018 12:19:49 PM com.pega.pegarules.internal.bootstrap.PRMin
iLoader
     [java] 1050: Will load phase 2 bootstrap from Pega-EngineCode:
     [java] Mar 28, 2018 12:19:50 PM com.pega.pegarules.internal.bootstrap.PRMin
iLoader
     [java] 1050: PRMiniLoader - unable to load classes from the database: ORA-0
0942: table or view does not exist
     [java]
     [java] Mar 28, 2018 12:19:50 PM com.pega.pegarules.internal.bootstrap.PRBoo
tstrap
     [java] 1050:
     [java] ============ PegaRULES Bootstrap Configuration ============
     [java]            Date: Wed Mar 28 12:19:50 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 Proprietary information hidden.0 - Production
     [java] With the Partitioning, OLAP, Data Mining and Real Application Testin
g 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] Mar 28, 2018 12:19:50 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:19:50 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
C:\BIX\Additional_Products\BIX\bix.xml:16: Java returned: 1

Total time: 2 seconds
"Bix Ant Seri End"

 

Versions : PRPC - 7.3 , BIX - 7.3.

Thanks,

Deepak


Show Less
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