Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

ORA-14402: updating partition key column would cause a partition



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( ~[ojdbc7.jar:?]
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch( ~[ojdbc7.jar:?]
    at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source) ~[?:?]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke( ~[?:1.8.0_144]
    at java.lang.reflect.Method.invoke( ~[?:1.8.0_144]
    at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke( ~[tomcat-jdbc.jar:?]
    at com.sun.proxy.$Proxy31.executeBatch(Unknown Source) ~[?:?]
    at ~[prprivate.jar:?]
    at ~[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.


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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us