My Oracle Support Banner

ORA-00942 when Attempting to Configure Schema Database Configuration Type in EDQP 11.1.6.3 Installation - WLS Domain Creation (Doc ID 2557023.1)

Last updated on DECEMBER 16, 2019

Applies to:

Oracle Enterprise Data Quality for Product Data - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

ORA-00942 error is encountered when attempting to configure the schema database configuration type in WebLogic Server (WLS) domain creation

Error during Fusion Middleware Configuration Wizard - Page 5 of 11
 --> Database Configuration Type
  --> RCU Data
  --> Vendor: Oracle Driver: "*Oracle's Driver (Thin) for Service Connections;..."
  --> Connection Parameters

Complete Error stack:

Error message: com.oracle.cie.rcu.external.ComponentSchemaInfoException: SQLException thrown
at com.oracle.cie.rcu.external.ComponentSchemaInfoFactory.getComponentSchemaInfos(ComponentSchemaInfoFactory.java:48)
at com.oracle.cie.domain.gui.jdbc.ShadowTableConfigurationPanel$BindThread.run(ShadowTableConfigurationPanel.java:915)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:727)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)
at com.oracle.cie.rcu.external.ComponentSchemaInfoFactory.getComponentSchemaInfos(ComponentSchemaInfoFactory.java:28)
... 1 more
Caused by: Error : 942, Position : 14, Sql = select * from COMPONENT_SCHEMA_INFO, OriginalSql = select * from COMPONENT_SCHEMA_INFO, Error Msg = ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:49



Changes

 

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
Changes
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.