My Oracle Support Banner

PFService Produces ORA-01426 Numeric Overflow Inserting into FLM_CAP_BANK_DETAILS (Doc ID 2470423.1)

Last updated on JULY 28, 2020

Applies to:

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

Symptoms

**Disclaimer:** This KM article may include the following abbreviations:

NMS - Oracle Network Management System

 

PFService produces ORA-01426 numeric overflow inserting into FLM_CAP_BANK_DETAILS.
PFService and PFDBService logs show an INSERT error due to numeric overflow.

The old_log logfiles weren't showing this error before 2.3.0.2.5.

Expect if you have bad data, it would be identified in a more straightforward manner.

ERROR
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR

while processing command 'INSERT into flm_cap_bank_details (solution_id, analysis_key, update_date, load_type, fdr_cls, fdr_idx, dev_cls, dev_idx, eda_type, reg_type, measur_attr, on_threshold, off_threshold, kvar_a, kvar_b, kvar_c, energized_capacitors, total_capacitors, auto_control, source, quality, has_scada, is_reactor) VALUES (:sol_id, :analysis_key, TO_DATE(:upd_time, 'MM/DD/YYYY HH24:MI:SS'), :load_type, :fdr_cls, :fdr_idx, :dev_cls, :dev_idx, :eda_type, :reg_type, :measur_attr, :on_threshold, :off_threshold, :kvar_a, :kvar_b, :kvar_c, :energized_capacitors, :total_capacitors, :auto_control, :source, :quality, :has_scada, :is_reactor)'

ORA-01426: numeric overflow

parse offset = 0

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 Fix Description
 Suggested Test
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.