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 2.4.0.1.0 to 2.5.0.0.0 [Release 2.4 to 2.5]
Oracle Utilities Network Management System - Version 2.4.0.1.0 to 2.5.0.0.0 [Release 2.4 to 2.5]
Information in this document applies to any platform.

Symptoms

On : 2.4.0.1.0 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

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
 Migration
References


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