Question

4
Replies
336
Views
Bharatesh Chougala (CHOUGALB)
Incessant Technologies

Incessant Technologies
IN
CHOUGALB Member since 2007 4 posts
Incessant Technologies
Posted: December 20, 2016
Last activity: January 30, 2017
Posted: 20 Dec 2016 5:37 EST
Last activity: 30 Jan 2017 6:44 EST
Closed
Solved

BIX Extract is failing when configured from an agent

We have configured the BIX rule from agent but we are seeing exceptions when the agent runs. Below is the exception we are getting.


2016-12-20 19:47:00,354 [ PegaRULES-Batch-1] [ ] [ Complaint:01.01.02] ( internal.access.ExtractImpl) INFO - BIX Version : 7.1


2016-12-20 19:47:00,511 [ PegaRULES-Batch-1] [ ] [ Complaint:01.01.02] ( internal.access.ExtractImpl) INFO - Target database using batch inserts


2016-12-20 19:47:11,723 [ PegaRULES-Batch-1] [ ] [ Complaint:01.01.02] ( internal.access.ExtractImpl) ERROR - 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


at com.ibm.db2.jcc.am.kd.a(kd.java:475)


at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:414)


at com.ibm.db2.jcc.am.cp.a(cp.java:5238)


at com.ibm.db2.jcc.am.cp.c(cp.java:4825)


at com.ibm.db2.jcc.am.cp.executeBatch(cp.java:3036)

We have configured the BIX rule from agent but we are seeing exceptions when the agent runs. Below is the exception we are getting.

2016-12-20 19:47:00,354 [ PegaRULES-Batch-1] [ ] [ Complaint:01.01.02] ( internal.access.ExtractImpl) INFO - BIX Version : 7.1

2016-12-20 19:47:00,511 [ PegaRULES-Batch-1] [ ] [ Complaint:01.01.02] ( internal.access.ExtractImpl) INFO - Target database using batch inserts

2016-12-20 19:47:11,723 [ PegaRULES-Batch-1] [ ] [ Complaint:01.01.02] ( internal.access.ExtractImpl) ERROR - 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

at com.ibm.db2.jcc.am.kd.a(kd.java:475)

at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:414)

at com.ibm.db2.jcc.am.cp.a(cp.java:5238)

at com.ibm.db2.jcc.am.cp.c(cp.java:4825)

at com.ibm.db2.jcc.am.cp.executeBatch(cp.java:3036)

at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:534)

at com.pega.pegarules.data.internal.access.ExtractImpl.insertRowsBatchMode(ExtractImpl.java:5811)

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

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

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

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

at com.pega.pegarules.data.internal.access.ExtractImpl.executeCommandLineExtract(ExtractImpl.java:1045)

at com.pega.pegarules.data.internal.PRDataProviderImpl.executeCommandLineExtract(PRDataProviderImpl.java:1314)

at com.pega.pegarules.session.internal.mgmt.Executable.executeCommandLineExtract(Executable.java:8282)

at com.pegarules.generated.activity.ra_action_pxextractdatawithargs_af9552bf7ad754cbdac2e3d257607afb.step3_circum0(ra_action_pxextractdatawithargs_af9552bf7ad754cbdac2e3d257607afb.java:411)

at com.pegarules.generated.activity.ra_action_pxextractdatawithargs_af9552bf7ad754cbdac2e3d257607afb.perform(ra_action_pxextractdatawithargs_af9552bf7ad754cbdac2e3d257607afb.java:103)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:721)

at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:602)

at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:945)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008)

at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:901)

at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:670)

at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991)

at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532)

at java.lang.Thread.run(Thread.java:745)

Environment details: Pega 7.1.8

BIX: 7.1

DB: IBM DB2

We created below DSS but no luck.

Owning Ruleset: Pega-Engine
Setting Purpose: prconfig/database/batchUpdates/default
Value: -1

Any help would be appreciated.

Bharatesh

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

Data Integration System Administration
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.