My Oracle Support Banner

FLM_FDR_LOAD Insert Errors (Doc ID 2814159.1)

Last updated on OCTOBER 15, 2021

Applies to:

Oracle Utilities Network Management System - Version 2.4.0.1.0 to 2.5.0.1.0 [Release 2.4 to 2.5]
Oracle Network Management for Utilities - DMS - Version 2.4.0.1.0 to 2.4.0.1.0 [Release 2.4]
Information in this document applies to any platform.

Symptoms

On : 2.4.0.1.0 version, Feeder Load Management

FLM_FDR_LOAD insert errors

There are numerous errors recoding inserting records into the FLM_FDR_LOAD table,

On inspection of the insert statements ( see attached PFService & FLMDBService logs )
There are numerous anomalies the code is attempting to use

  1. Violate unique constrains when solution_id, analysis_key & load_type = 0 for a feeder which already have these values in the table
  2. Insert the "string" value of '-nan' or '-inf' into float fields
  3. Insert values with a power to the -42, -43 etc.. into float fields

These anomalies only happen for certain feeders ( more than likely customer data or model related ) but the code should properly handle these outliers

ERROR
-----------------------
These include
ORA-01426: numeric overflow
ORA-00001: unique constraint (NIE3.FLM_FDR_LOAD_PK) violated
ORA-00984: column not allowed here

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
References


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