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 |