Question

1
Replies
313
Views
Debanjan Seth (DebanjanS)
Accenture Services Pvt Ltd

Accenture Services Pvt Ltd
IN
DebanjanS Member since 2013 3 posts
Accenture Services Pvt Ltd
Posted: December 26, 2016
Last activity: December 26, 2016
Posted: 26 Dec 2016 10:34 EST
Last activity: 26 Dec 2016 11:17 EST
Closed

BIX Extract sometimes does not run even stand alone not from Agent rule - Getting expection - ERROR - SQL error getting the next row to be extracted

Pega Version 7.1.8

BIX Version -7.1

Application Server - Tomcat

DB - DB2.

We are getting below error durng BIX run either sometimes manually or via agent.

SQL error getting the next row to be extracted

SQL error getting the next row to be extracted: errorCode = -4470 errorMessage:[jcc][t4][10120][10898][4.18.60] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null

2016-12-05 17:12:19,776 [   PegaRULES-Batch-2] [                    ] [  Application:01.01.02] (   internal.access.ExtractImpl) ERROR   - Could not return target db statements
java.sql.SQLException: Connection has already been closed.
 at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)
 at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
 at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
 at com.sun.proxy.$Proxy5.setAutoCommit(Unknown Source)

Sometimes the BIX stopped working with the below error in the log.

 

Batch Update Exception: [jcc][t4][102][10040][4.18.60] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.18.60] Batch failure.  The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null

 

 

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.