DBConnector Exceptions Caused by Missing PF_DIST_GEN_DATA Table (Doc ID 2104036.1)

Last updated on JUNE 21, 2017

Applies to:

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

Symptoms

Getting java exceptions because of lack of PF_DIST_GEN_DATA table

Right now product assumes this table, PF_DIST_GEN_DATA, should exist.

Error in the client console:

2016-02-05 11:16:10,977 [Thread-8] ERROR com.splwg.oms.jbot.DBConnector: DBConnector.executeQuery: query failed: "select * from PF_DIST_GEN_DATA where model_edit = 'Y' " java.sql.SQLSyntaxErrorException: ORA-00980: synonym translation is no longer valid
at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:237)
 at weblogic.rmi.internal.BasicRemoteRef.invoke(BasicRemoteRef.java:223)
 at com.splwg.oms.ejb.session.Session_pgpyv4_RemoteSessionImpl_1036_WLStub.executeSQLQuery(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

2016-02-05 11:16:10,977 [Thread-8] ERROR com.splwg.oms.jbot.JDBCDataStore: DS_REGULATOR_TYPES.populate
java.sql.SQLSyntaxErrorException: ORA-00980: synonym translation is no longer valid

  at weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:237)


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