My Oracle Support Banner

"com.oracle.cie.servicetable.external.ServiceTableException: Failed to query contents of table SERVICETABLE" Signaled when Creating an ODI 12c Colocated Agent (Doc ID 1621568.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When trying to create an Oracle Data Integrator (ODI) 12c colocated Agent you get the message:

com.oracle.cie.servicetable.external.ServiceTableException: Failed to query contents of table SERVICETABLE.
ORA-00942: table or view does not exist

  and following information is found in the log file:

Failed to query contents of table SERVICETABLE.
ORA-00942: table or view does not exist

com.oracle.cie.servicetable.external.ServiceTableException: Failed to query contents of table SERVICETABLE.
ORA-00942: table or view does not exist

  at com.oracle.cie.servicetable.dao.impl.AbstractServiceTableDAOImpl.getServiceTableEntry(AbstractServiceTableDAOImpl.java:295)
  at com.oracle.cie.servicetable.dao.impl.OracleServiceTableDAOImpl

Cause

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
Symptoms
Cause
Solution


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