Question
Cognizant
IN
Last activity: 30 Aug 2023 23:39 EDT
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
NCS Pte. Ltd
SG
Hi @Ravi prasad: 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.
@Ravi prasad 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:
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
Adding partition to database
Troubleshooting ORA-02443, ORA-02429, ORA-06512, Oracle optimization issues
@Ravi prasad 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:
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
Adding partition to database
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.