"ERROR com.splwg.oms.ejb.troubleinfo.TroubleInfoBean: populateDERs failed for query ..." When Using the LookAhead Tool (Doc ID 2177535.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

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

Symptoms

On : 1.12.0.3 version, Web Workspace

Error in WebLogic - table pf_dist_gen missing - We don't use PowerFlow

2016-08-12 13:39:04,023 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.splwg.oms.ejb.troubleinfo.TroubleInfoBean: populateDERs failed for query [[SELECT distinct a.* FROM pf_dist_gen a, handles_temp b WHERE a.h_cls = b.h_cls AND a.h_idx = b.h_idx AND a.active IN ('Y', 'A')]]
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
  at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
  at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
  at com.splwg.oms.ejb.troubleinfo.TroubleInfoBean.populateDERs(TroubleInfoBean.java:1081)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.inv





The issue can be reproduced at will with the following steps:
1. Bring up lookahead tool.
2. Observe error


Changes

"powerflow" is not in the license.dat file.

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