My Oracle Support Banner

PFDBService Log Showing Error ORA-00904: "ANALYSIS_ID": invalid identifier (Doc ID 2746191.1)

Last updated on MARCH 12, 2021

Applies to:

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


On : version, PFDBService log error message

Seeing following error message in PFDBService log:

01/13/21 10:11:13: dbrdwr:111703
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'DELETE FROM PF_FDA_STATUS WHERE ANALYSIS_ID = 1451'
ORA-00904: "ANALYSIS_ID": invalid identifier
parse offset = 32[ANALYSIS_ID = 1451]
01/13/21 10:11:12: 0x7f3e661f5700,ctp=0x16c5ef8,"sql" sql error: (DELETE FROM PF_FDA_STATUS WHERE ANALYSIS_ID = 1451) from (1/124:111731.0), result=-1 ORA-00904: "ANALYSIS_ID": invalid identifier


Steps to recreate:

1. Launch Web workspace and login
2. Open "Conductor Impedance Mismatch Tool" from Tools->Conductor Impedance
Mismatch Tool...
3. Click on "Run the Conductor Impedance Mismatch Analysis"
4. enter "5" in "Feeder Data Analysis" dialog Analysis runtime text box and
click Run.
5. After the analysis completes view the PFDBService log and errors presented


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
 Fix Description

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