My Oracle Support Banner

Trouble Info Not Displaying Customers in Customer Table (Doc ID 2170523.1)

Last updated on NOVEMBER 28, 2017

Applies to:

Oracle Utilities Network Management System - Version and later
Oracle Network Management for Utilities - DMS - Version and later
Information in this document applies to any platform.


Trouble Info not displaying Customers in Customer Table.

Recently updated from release or service pack/patch bundle prior to to patch or newer.

WebLogic Managed Server log:

2016-08-09 13:23:12,009 ERROR troubleinfo.TroubleInfoBean:171 - getTableData failed for query [[SELECT * FROM ( SELECT 1 WEIGHTED_COUNT, 1 CURRENT_WEIGHT, i.event_idx Event_Id, i.short_desc Clues, i.input_time CallTime, case when i.cid is null then 0 else count(*) over (partition by order by i.input_time asc, i.numb asc rows between unbounded preceding and unbounded following) end totalCalls, row_number() over (partition by order by i.input_time asc, i.numb asc ) callSequence, cc.* FROM nms_customers cc, incidents i WHERE = i.cid (+) AND (+) = 'Y' AND (cc.new_supply_idx in (195501)) ) WHERE callSequence = 1 ]]
java.sql.SQLException: Invalid column name
at oracle.jdbc.driver.OracleStatement.getColumnIndex(
at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_ForwardOnlyResultSet.findColumn(Unknown Source)


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

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