'ORA-01426: Numeric Overflow Inserting Into JOBS Table' Error in JMService Log (Doc ID 2148668.1)

Last updated on JUNE 13, 2016

Applies to:

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

Symptoms

JMService gives error='ORA-01426: numeric overflow inserting into JOBS table

05/28/16 18:25:58: JMService 0x7f6a15890700,ctp=0x1ae69b8,"JMBroadcast::flush(writeToDB) - writing" *ERROR* - sql failed:
result=-1 error='ORA-01426: numeric overflow
'
sql=[UPDATE jobs SET active=:active,complete=:complete,h_cls=:h_cls,h_idx=:h_idx,begin_time=to_date(:begin_time,'MM/DD/YYYY HH24:MI:SS'),status=:status,partition=:partition,ncg=:ncg,event_cls=:event_cls,event_idx=:event_idx,msg_cls=:msg_cls,msg_idx=:msg_idx,display_name=:display_name,addr_building=:addr_building,addr_street=:addr_street,addr_city=:addr_city,description=:description,operator_comment=:operator_comment,external_id=:external_id,num_cust_out=:num_cust_out,user_cust_out=:user_cust_out,cust_crit=:cust_crit,alarm_state=:alarm_state,pri_e=:pri_e,num_priority=:num_priority,call_type=:call_type,devcls_name=:devcls_name,trouble_code=:trouble_code,trouble_queue=:trouble_queue,valid_state_key=:valid_state_key,state_value=:state_value,sort_col_1=:sort_col_1,sort_col_2=:sort_col_2,sort_col_3=:sort_col_3,sort_col_4=:sort_col_4,sort_col_5=:sort_col_5,sort_col_6=:sort_col_6,sort_col_7=:sort_col_7,sort_col_8=:sort_col_8,sort_col_9=:sort_col_9,stormman_type=:stormman_type,group_type=:group_type,cause=:cause,phases=:phases,alias=:alias,feeder_name=:feeder_name,crit_1=:crit_1,crit_2=:crit_2,pri_w=:pri_w,pri_sw=:pri_sw,first_call_time=to_date(:first_call_time,'MM/DD/YYYY HH24:MI:SS'),est_rest_time=to_date(:est_rest_time,'MM/DD/YYYY HH24:MI:SS'),restore_time=to_date(:restore_time,'MM/DD/YYYY HH24:MI:SS'),rule_set=:rule_set,crit_k=:crit_k,crit_c=:crit_c,crit_d=:crit_d,est_source=:est_source,bitmask=:bitmask,num_momentaries=:num_momentaries,alarm_cls=:alarm_cls,alarm_idx=:alarm_idx,x_coord=:x_coord,y_coord=:y_coord,fla_accuracy=:fla_accuracy,alarm_bitmask=:alarm_bitmask,who_completed=:who_completed,lead_call_numb=:lead_call_numb,est_assess_time=to_date(:est_assess_time,'MM/DD/YYYY HH24:MI:SS'),referral_group=:referral_group,disp_group_cat=:disp_group_cat,customer_name=:customer_name,customer_phone=:customer_phone,frozen_tcode=:frozen_tcode,ncg_cls_1=:ncg_cls_1,ncg_idx_1=:ncg_idx_1,ncg_name_1=:ncg_name_1,ncg_cls_2=:ncg_cls_2,ncg_idx_2=:ncg_idx_2,ncg_name_2=:ncg_name_2,ncg_cls_3=:ncg_cls_3,ncg_idx_3=:ncg_idx_3,ncg_name_3=:ncg_name_3,ncg_cls_4=:ncg_cls_4,ncg_idx_4=:ncg_idx_4,ncg_name_4=:ncg_name_4,ncg_cls_5=:ncg_cls_5,ncg_idx_5=:ncg_idx_5,ncg_name_5=:ncg_name_5,ncg_cls_6=:ncg_cls_6,ncg_idx_6=:ncg_idx_6,ncg_name_6=:ncg_name_6,when_provided_est_rest_time=to_date(:when_provided_ert,'MM/DD/YYYY HH24:MI:SS'),who=:who,first_crew_time=to_date(:first_crew_time,'MM/DD/YYYY HH24:MI:SS'),job_complete_time=to_date(:job_complete_time,'MM/DD/YYYY HH24:MI:SS'),who_responsible=:who_responsible,resp_modify_time=to_date(:resp_modify_time,'MM/DD/YYYY HH24:MI:SS'),est_repair_minutes=:est_repair_minutes,dms_status=:dms_status,act_assess_time=to_date(:act_assess_time,'MM/DD/YYYY HH24:MI:SS'),assess_src=:assess_src,feeder_cls=:feeder_cls,feeder_idx=:feeder_idx,reviewed=:reviewed,swsheet_cls=:swsheet_cls,swsheet_idx=:swsheet_idx,response_time=to_date(:response_time, 'MM/DD/YYYY HH24:MI:SS'),ert_username=:ert_user,w_cust_out=:w_cust_out,grouping_flag=:grouping_flag,assessed=:assessed,repredict_time=to_date(:repr_time,'MM/DD/YYYY HH24:MI:SS'),power_up_count=:g_0,assign_method=:g_1,scs_ops_center=:g_2 WHERE numb=:numb]




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