Inserted partition key does not map to any partition
Article ID: KB0084191
Updated On:
| Products | Versions |
|---|---|
| TIBCO Fulfillment Order Management | 3.0.2 |
Description
Description:
When running OMS_Partition_Migration.sql we see error ORA-14400: inserted partition key does not map to any partition
Symptoms:
BEGIN
*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-12801: error signaled in parallel query server P000
ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "SYS.DBMS_REDEFINITION", line 52
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1646
ORA-06512: at line 2
Cause:
This error is because of data integrity problems.
When running OMS_Partition_Migration.sql we see error ORA-14400: inserted partition key does not map to any partition
Symptoms:
BEGIN
*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-12801: error signaled in parallel query server P000
ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "SYS.DBMS_REDEFINITION", line 52
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1646
ORA-06512: at line 2
Cause:
This error is because of data integrity problems.
Issue/Introduction
Inserted partition key does not map to any partition
Environment
FOM 3.0.2
Resolution
We have to check data integrity between tables using partition key we are creating.
For example, if problem is with PLAN_SDF_DATA table we can check if all planids in this table are not null and present in Plan.planid table.
SELECT planid FROM plan_sdf_data WHERE planid NOT IN (SELECT planid FROM plan);
Extra records have to be deleted or fixed accordingly to problem.
For example, if problem is with PLAN_SDF_DATA table we can check if all planids in this table are not null and present in Plan.planid table.
SELECT planid FROM plan_sdf_data WHERE planid NOT IN (SELECT planid FROM plan);
Extra records have to be deleted or fixed accordingly to problem.
Additional Information
TIB_af_3.0.2_installation.pdf
Feedback
Yes
No
Powered by
