FLISR_RESTORE_PLANS.sw_condition - ORA-12899: Value Too Large For Column (Doc ID 2286575.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.3 to 2.3.0.0.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 1.12.0.3 to 2.3.0.0.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.

Symptoms


Getting FLISR_RESTORE_PLANS.sw_condition - ORA-12899: value too large for column

PFDBService.log shows:

ORA-12899: value too large for column "NMS"."FLISR_RESTORE_PLANS"."SW_CONDITION" (actual: 134, maximum: 127)

while processing command 'INSERT INTO flisr_restore_plans (job_idx,           isol_sw_cls,        isol_sw_idx,     isol_sw_name, sw_cls,            sw_idx,             switch_name,     area_idx, isolated_amps_a,   isolated_amps_b,    isolated_amps_c, fdr, pre_amps_a,        pre_amps_b,         pre_amps_c, post_amps_a,       post_amps_b,        post_amps_c, cogen_kw,          switch_selected,    peak_time, limit_obj_cls,     limit_obj_idx,      limit_obj_phase, expected_amps,     expected_pc_rating, margin,recloser_cls,      recloser_idx,       sw_condition, isol_fdr_cls,      isol_fdr_idx, rest_fdr_cls,      rest_fdr_idx,       has_recloser, deenerg_reclosers, pu_sw_devices,      rf_sw_devices, limit_type,        viol_start,         viol_end) VALUES (:frp_job_idx,      :frp_isol_cls,     :frp_isol_idx,     :frp_isol_name, :frp_rest_cls,     :frp_rest_idx,     :frp_rest_name,    :frp_area_idx, :frp_isol_amps_a,  :frp_isol_amps_b,  :frp_isol_amps_c,  :frp_fdrh_name, :frp_pre_amps_a,   :frp_pre_amps_b,   :frp_pre_amps_c, :frp_post_amps_a,  :frp_post_amps_b,  :frp_post_amps_c, :frp_cogen_kw,     :frp_selected,     :frp_peak_time, :frp_lim_cls,      :frp_lim_idx,      :frp_lim_phase, :frp_lim_amps,     :frp_lim_ratng,    :frp_lim_margin, :frp_rec_cls,      :frp_rec_idx,      :frp_rec_cond, :frp_isol_fdr_cls, :frp_isol_fdr_idx, :frp_rest_fdr_cls, :frp_rest_fdr_idx, :frp_rest_recloser, :frp_deenergized,  :frp_pu_switches,  :frp_rf_switches, :frp_limit_type,   :frp_viol_start,   :frp_viol_end)'
ORA-12899: value too large for column "NMS"."FLISR_RESTORE_PLANS"."SW_CONDITION" (actual: 134, maximum: 127)




Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms