My Oracle Support Banner

Config Assistant Fails During Install - failed with exit value 2 at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:106) - ORA-00942: table or view does not exist (Doc ID 2563378.1)

Last updated on AUGUST 18, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Configuration Assistant for OBIEE 12.2.1.4 fails creating RCU schemas  Error

failed with exit value 2 at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:106)

 

 RCUCreateSchemalog
==================
ERROR assistants.rcu.backend.action.AbstractAction: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-00942: table or view does not exist
NOTIFICATION assistants.common.util.SilentMessageHandler: oracle.sysman.assistants.common.util.SilentMessageHandler::writeToLog: ORA-00942: table or view does not exist


ERROR assistants.rcu.backend.task.ActualTask: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException:
ERROR - RCU-6135 Error while executing Java action.
CAUSE - RCU-6135 An error occurred while trying to execute Java action.
ACTION - RCU-6135 Check the java action for the component or contact the system administrator.
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:329)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:346)
at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.sysman.assistants.common.task.ActionFailedException:
ERROR - RCU-6135 Error while executing Java action.
CAUSE - RCU-6135 An error occurred while trying to execute Java action.
ACTION - RCU-6135 Check the java action for the component or contact the system administrator.
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:692)
at oracle.sysman.assistants.rcu.backend.action.JavaAction.perform(JavaAction.java:590)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:255)
... 2 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.sysman.assistants.rcu.backend.action.ActionThread.run(JavaAction.java:655)
... 4 more
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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3865)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3845)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
at oracle.ias.version.SchemaVersion.executeUpdateOrGenerateSql(SchemaVersion.java:2984)
at oracle.ias.version.SchemaVersion.createRegistryEntry(SchemaVersion.java:1282)
at oracle.ias.version.SchemaVersionUtil.utilCreateRegistryEntry(SchemaVersionUtil.java:361)
... 9 more
Caused by: Error : 942, Position : 19, Sql = INSERT INTO SYSTEM.SCHEMA_VERSION_REGISTRY$ (comp_id, comp_name, mrc_name, mr_name,  mr_type, owner, version, status, edition, custom1) VALUES (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ), OriginalSql = INSERT INTO SYSTEM.SCHEMA_VERSION_REGISTRY$ (comp_id, comp_name, mrc_name, mr_name,  mr_type, owner, version, status, edition, custom1) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-00942: table or view does not exist

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.