Support Article
Error in Column Popularity Utility
SA-11636
Summary
Column Popularity Utility failed with Database Errors
Error Messages
2015-06-06 10:07:58,678 [ main] [ ] [ ] ( internal.util.ExposeCols) ERROR - Encountered batch element exception:
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][4.14.137] 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.ed.a(ed.java:405)
at com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:400)
at com.ibm.db2.jcc.am.po.a(po.java:5159)
at com.ibm.db2.jcc.am.po.c(po.java:4745)
at com.ibm.db2.jcc.am.po.executeBatch(po.java:2995)
at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:529)
at com.pega.pegarules.deploy.internal.util.ExposeCols.processBatch(ExposeCols.java:1432)
at com.pega.pegarules.deploy.internal.util.ExposeCols.saveInstances(ExposeCols.java:1214)
at com.pega.pegarules.deploy.internal.util.ExposeCols.saveInstances(ExposeCols.java:989)
at com.pega.pegarules.deploy.internal.util.ExposeCols.runUtility(ExposeCols.java:812)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
Steps to Reproduce
na
Root Cause
The root cause of this problem is defect/misconfiguration in the operating environment. Issue is due to minimal LogFilSiz, LogPrimary, and LogSecond for the Data Warehouse.
Resolution
The explanation for this behavior is as follows:
Increase the LogFilSiz, LogPrimary, and LogSecond for the Data Warehouse on DB2.
Published July 3, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.