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

Last updated on AUGUST 10, 2016

Applies to:

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

Symptoms

Trouble Info not displaying Customers in Customer Table.

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

ERROR
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 cc.id order by i.input_time asc, i.numb asc rows between unbounded preceding and unbounded following) end totalCalls, row_number() over (partition by cc.id order by i.input_time asc, i.numb asc ) callSequence, cc.* FROM nms_customers cc, incidents i WHERE cc.id = i.cid (+) AND i.active (+) = 'Y' AND (cc.new_supply_idx in (195501)) ) WHERE callSequence = 1 ]]
java.sql.SQLException: Invalid column name
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:4146)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:300)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_ForwardOnlyResultSet.findColumn(Unknown Source)

Changes

 

Cause

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 hundreds of Community platforms