My Oracle Support Banner

Configuration Assistant Startup Error on Query to the Feeders Table (Doc ID 2106213.1)

Last updated on NOVEMBER 15, 2017

Applies to:

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


After updating to Configuration Assistant is throwing a DataStore error due to database table FEEDERS.engine column not existing.


2016-02-01 08:08:02,098 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN com.splwg.oms.ejb.session.Session: nms-security or SQL problem: user:nms1 sql: select h_cls, h_idx, birth_patch, active, feeder_name, substation_name, color, flm_enabled, cvr_enabled, flisr_enabled, fla_enabled, engine from feeders where active='Y' order by substation_name,feeder_name
java.sql.SQLSyntaxErrorException: ORA-00904: "ENGINE": invalid identifier

The issue can be reproduced at will with the following steps:
1. Attempt to login to Configuration Assistant, note error in WebLogic log.




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

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

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