Support Article
ORA-14402: updating partition key column would cause a partition
Summary
The Resume work flow fails when saving work objects to the pc_work_workbasket table. The environment creates a Range partition on the pc_assign_workbasket table using the pxCreateDateTime as a Partition key with an interval of 1 day.
Error Messages
Caused by: java.sql.BatchUpdateException: ORA-14402: updating partition key column would cause a partition change
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296) ~[ojdbc7.jar:?]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246) ~[ojdbc7.jar:?]
at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_144]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_144]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc.jar:?]
at com.sun.proxy.$Proxy31.executeBatch(Unknown Source) ~[?:?]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:489) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.store.ConnectionStatementStore.executeBatchForAllStatements(ConnectionStatementStore.java:231) ~[prprivate.jar:?]
... 89 more
Steps to Reproduce
Configure the application to obtain a REST Service Request to a case that is created in the last 7 days.
Root Cause
A defect or configuration issue in the operating environment.
The Resume flow resulted in a row which updated the pxCreateDateTime column and thus moved the row to a different partition.
Resolution
Perform the following local-change:
Use the 'Alter table pc_assign_workbasket Enable Row Movement;' option in Oracle to enable rows to move across partitions.
An enhancement request, FDBK-67182, is created for consideration by Pega Product Management.
Published April 14, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.