Article - CS255366
dbpatch failing with "ORA-00439: feature not enabled: Partitioning" in Servigistics Click Parts Planning (C-Parts)
Modified: 01-Feb-2017
Applies To
- Servigistics Click Parts Planning 7.7.2 N/A
Description
- dbpatch errored on patch parts_patch7501.sql with ORA-00439: feature not enabled: Partitioning
- Applying patch from 7.4.33 to 7.5.01 Thu Dec 8 18:25:03 America 2016
Running SQL script...
@(#) %filespec: parts_patch7501.sql,7.6-1 %
**********************************************************
* CASE_SUMMARY:
* CalcT1-CalcT4 and CalcT1Cost_calcT4Cost
*
* create CALC_T1 column on case_summary table.
* create CALC_T1_COST column on case_summary table.
* create CALC_T1_COST column on case_summary table.
* create CALC_T2 column on case_summary table.
* create CALC_T2_COST column on case_summary table.
* create CALC_T3 column on case_summary table.
* create CALC_T3_COST column on case_summary table.
* create CALC_T4 column on case_summary table.
* create CALC_T4_COST column on case_summary table.
* create CALC_T1 column on CALC_RESULTS_SUMMARY table.
* create CALC_T1_COST column on CALC_RESULTS_SUMMARY table.
* create CALC_T2 column on CALC_RESULTS_SUMMARY table.
* create CALC_T2_COST column on CALC_RESULTS_SUMMARY table.
* create CALC_T3 column on CALC_RESULTS_SUMMARY table.
* create CALC_T3_COST column on CALC_RESULTS_SUMMARY table.
* create CALC_T4 column on CALC_RESULTS_SUMMARY table.
* create CALC_T4_COST column on CALC_RESULTS_SUMMARY table.
* Add S242, SKU Overrides on alternate parts Indicator.
**********************************************************
* TYPECODE:
* Add 'NOT IN' to drptype 71
**********************************************************
**********************************************************
* PART_MAP_ELEMENT:
*
* add CHURN_CONTROL_IND column
* add uses_EFR column to part_map_element
* add uses_Demand_History column to part_map_element
* add uses_EFR column to demands_per_day
* add uses_Demand_History column to demands_per_day
* add store_demand_sources column
create table: Demand_Rate_Source_Details
CREATE TABLE DEMAND_RATE_SOURCE_DETAILS
*
ERROR at line 1:
ORA-00439: feature not enabled: Partitioning
* create CALC_T2_COST column on case_summary table.
* create CALC_T3 column on case_summary table.
* create CALC_T3_COST column on case_summary table.
* create CALC_T4 column on case_summary table.
* create CALC_T4_COST column on case_summary table.
* create CALC_T1 column on CALC_RESULTS_SUMMARY table.
* create CALC_T1_COST column on CALC_RESULTS_SUMMARY table.
* create CALC_T2 column on CALC_RESULTS_SUMMARY table.
* create CALC_T2_COST column on CALC_RESULTS_SUMMARY table.
* create CALC_T3 column on CALC_RESULTS_SUMMARY table.
* create CALC_T3_COST column on CALC_RESULTS_SUMMARY table.
* create CALC_T4 column on CALC_RESULTS_SUMMARY table.
* create CALC_T4_COST column on CALC_RESULTS_SUMMARY table.
* Add S242, SKU Overrides on alternate parts Indicator.
**********************************************************
* TYPECODE:
* Add 'NOT IN' to drptype 71
**********************************************************
**********************************************************
* PART_MAP_ELEMENT:
*
* add CHURN_CONTROL_IND column
* add uses_EFR column to part_map_element
* add uses_Demand_History column to part_map_element
* add uses_EFR column to demands_per_day
* add uses_Demand_History column to demands_per_day
* add store_demand_sources column
create table: Demand_Rate_Source_Details
CREATE TABLE DEMAND_RATE_SOURCE_DETAILS
*
ERROR at line 1:
ORA-00439: feature not enabled: Partitioning
ERROR: SQL script returned error code.
Please press ENTER . . .
Aborted.
This is a printer-friendly version of Article 255366 and may be out of date. For the latest version click CS255366