My Oracle Support Banner

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

Last updated on NOVEMBER 17, 2017

Applies to:

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


On : 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 IN ('Y', 'A')]]
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
  at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(
  at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(
  at com.splwg.oms.ejb.troubleinfo.TroubleInfoBean.populateDERs(
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
  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


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


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.