ORA-14402: updating partition key column would cause a partition change
Hi Team, I'm getting error message"ORA-14402: updating partition key column would cause a partition change" while approving a request in the workbasket. As part of the code we are not updating any partition column, but in the background a merge query is auto generating and trying to update the partition column. Due to this error, unable to approve the requests. Please share your thoughts...
Error Message: [MSG][Error in commit()][STACK][com.pega.pegarules.pub.database.DatabaseException: ORA-14402: updating partition key column would cause a partition change DatabaseException caused by prior exception: java.sql.BatchUpdateException: ORA-14402: updating partition key column would cause a partition change | SQL Code: 14402 | SQL State: 72000 DatabaseException caused by prior exception: java.sql.SQLException: ORA-14402: updating partition key column would cause a partition change | SQL Code: 14402 | SQL State: 72000 : SQL: MERGE INTO DATA.pc_assign_workbasket
Pegasystems Inc.
GB
@RaviP1754 The error message "ORA-14402: updating partition key column would cause a partition change" occurs when an attempt is made to update a partition key column in a way that would cause the row to move to a different partition. In your case, it seems that a MERGE query is auto-generated in the background and trying to update the partition column.
To resolve this issue, you can try the following steps:
- Identify the specific partition key column that is causing the issue.
- Review the code and logic to ensure that the partition key column is not being updated unintentionally.
- If necessary, consult with your database administrator to discuss possible changes to the partitioning strategy or table structure.
This answer came from a Pega gen-AI assistant using the below references. As a Support Center moderator, I reviewed the answer and references for accuracy:
Update fails with ORA-01451, ORA-02429, and ORA-02443 [SDR-301] > Sympto
Troubleshooting ORA-02443, ORA-02429, ORA-06512, Oracle optimization issues
@RaviP1754 The error message "ORA-14402: updating partition key column would cause a partition change" occurs when an attempt is made to update a partition key column in a way that would cause the row to move to a different partition. In your case, it seems that a MERGE query is auto-generated in the background and trying to update the partition column.
To resolve this issue, you can try the following steps:
- Identify the specific partition key column that is causing the issue.
- Review the code and logic to ensure that the partition key column is not being updated unintentionally.
- If necessary, consult with your database administrator to discuss possible changes to the partitioning strategy or table structure.
This answer came from a Pega gen-AI assistant using the below references. As a Support Center moderator, I reviewed the answer and references for accuracy:
Update fails with ORA-01451, ORA-02429, and ORA-02443 [SDR-301] > Sympto
Troubleshooting ORA-02443, ORA-02429, ORA-06512, Oracle optimization issues
If the issue persists, you may need to contact Pega Support for further assistance.
Please provide the INC reference here if you do log a ticket.
NCS Pte. Ltd
SG
Hi @RaviP1754: TO add on to MarijeSchillern, please check the partition definition of the respective table. If the table is partitioned using any of the columns which is updated by system, you may get this issue.
You can also try enabling the row movement option in the table. Please check with DBA on this.
Thanks.