Question

3
Replies
151
Views
SreedharKUHG Member since 2014 2 posts
UnitedHealth Group
Posted: 5 years ago
Last activity: 5 years ago
Closed
Solved

Gettign error while running through command line in BIX 7x

Hi,

I am getting the below exception while running the BIX on Pega 7.1.7 version and BIX also 7 version. BIX is working fine if we import BIX ruleset. Here my scenario is I have taken the Extract rule XML and running the BIX through command line in higher environments where BIX ruleset is not available. Seems like it is checking the DB table for Log-Extract class and throwing error. But the same is working in lower version without checking this class. When I create Log-Extract class rule and running, then it is generating BIX reports fine. In BIX 7x version, is it mandatory to import BIX rules to run the extract through command line? Is there any other option to execute without importing BIX rules. Below is the error message.

2015-09-28 09:08:30,279 [           xxxx] [                    ] [                    ] (   internal.access.ExtractImpl) ERROR   - Error while generating the handle for logging

2015-09-28 09:08:30,279 [           xxxx] [                    ] [                    ] (   internal.access.ExtractImpl) ERROR   - Error while getting the sequenceNumberDatabase-BadClassDef Log-Extract

2015-09-28 09:08:30,283 [           xxxx] [                    ] [                    ] (   internal.access.ExtractImpl) ERROR   - Error while getting the count from manifest table

2015-09-28 09:08:30,290 [           xxxx] [  STANDARD] [                    ] [                    ] (l.access.ConnectionManagerImpl) ERROR   - Not returning connection 1 for database "pegadata" to the pool as it previously encountered the following error

User ID: (unknown)

Last SQL: select pyItemId from null where pzInsKey = ?

java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)

  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)

  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)

  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

  at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)

  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

  at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.executeQuery(DatabasePreparedStatementImpl.java:405)

  at com.pega.pegarules.data.internal.access.ExtractImpl.processSequenceNumber(ExtractImpl.java:6768)

  at com.pega.pegarules.data.internal.access.ExtractImpl.doExtract(ExtractImpl.java:2752)

  at com.pega.pegarules.data.internal.access.ExtractImpl.runExtract(ExtractImpl.java:1621)

  at com.pega.pegarules.data.internal.access.ExtractImpl.run(ExtractImpl.java:1304)

  at com.pega.pegarules.data.internal.access.ExtractImpl.init(ExtractImpl.java:1278)

  at com.pega.pegarules.data.internal.access.ExtractImpl.parseAndRunExtractCommand(ExtractImpl.java:1235)

  at com.pega.pegarules.data.internal.access.ExtractImpl.main(ExtractImpl.java:953)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:606)

  at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)

  at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)

  at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)

  at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)

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

2015-09-28 09:08:30,294 [           xxxx] [                    ] [                    ] (   internal.access.ExtractImpl) WARN    - returning the connection

Reporting
Moderation Team has archived post
Share this page LinkedIn