ECM Case Purge Throwing Exception (Doc ID 2919841.1)

Last updated on JANUARY 12, 2023

Applies to:

Symptoms

Problem Summary
---------------------------------------------------
ECM case purge throwing exception

Problem Description
---------------------------------------------------
Inserted records into FCC_PURGE_CASE_INPUT and tried running CasePurge utility

java.sql. : error occurred during batching: ORA-00913: too many values

Changes

 Customer is on 8.1.2.2 and running case purge utility. Observed below error in CasePurge.log.

configurationPath:::/apps/oramld/FCCM/fccm
runInsertScripts method started::Tue Nov 01 10:59:45 EDT 2022
Purge Failed
java.sql.BatchUpdateException: error occurred during batching: ORA-00913: too
many values

at
oracle.jdbc.driver.OracleStatement.executeLargeBatch(OracleStatement.java:4569
)
at
oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4437)
at
oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.
java:234)
at
org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.
java:242)
at
org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.
java:242)
at com.ofss.ecm.casepurge.CaseConfig.runInsertScripts(CaseConfig.java:204)
at com.ofss.ecm.casepurge.CaseConfig.executeScript(CaseConfig.java:125)
at com.ofss.ecm.casepurge.CaseConfig.config(CaseConfig.java:99)
at com.ofss.ecm.casepurge.CasePurgeMain.main(CasePurgeMain.java:20)
configurationPath:::/apps/oramld/FCCM/fccm
Temp tables dropped successfully
Exception in thread "main" java.sql.BatchUpdateException: error occurred
during batching: ORA-00913: too many values

at
oracle.jdbc.driver.OracleStatement.executeLargeBatch(OracleStatement.java:4569
)
at
oracle.jdbc.driver.OracleStatement.executeBatch(OracleStatement.java:4437)
at
oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.
java:234)
at
org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.
java:242)
at
org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.
java:242)
at com.ofss.ecm.casepurge.CaseConfig.runInsertScripts(CaseConfig.java:204)
at com.ofss.ecm.casepurge.CaseConfig.executeScript(CaseConfig.java:125)
at com.ofss.ecm.casepurge.CaseConfig.config(CaseConfig.java:99)
at com.ofss.ecm.casepurge.CasePurgeMain.main(CasePurgeMain.java:20)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.