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 FEBRUARY 01, 2023
Applies to:
Oracle Enterprise Data Quality for Product Data - Version 11.1.1.6.0 and laterInformation 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 |