求助！Oracle安装进程流的时候报错

显示全部楼层 · 2021-1-27 06:36:45

用的安装目录下的wfinstall.bat安装进程流，出现了如下的错误：
java.sql.SQLException:ORA-00942:tableorviewdoesnotexist
WorkflowConfigurationAssistant2.6.4.0.0-WindowsServer2008R2
WFCAVersion::WorkflowCA.java26.1062005/06/2904:33
WorkflowCA:
WorkflowCA:正在进行工作流配置...
WorkflowCA:SatJun0315:28:19CST2017
WorkflowCA:
WorkflowCA:Screenwidth-1600-,screenheight-900-
WorkflowCA:
WorkflowCA:图形用户界面模式
WorkflowCA:
WorkflowCA:
WorkflowCA:开始测试连接,这需要不到3分钟的时间。
WorkflowCA:
WorkflowCA:为以下操作进行帐户连接测试:SYS
WorkflowCA:SYS帐户连接成功。
WorkflowCA:内嵌的Workflow检查已成功完成
WorkflowCA:工作流方案已存在,WorkflowConfigurationAssistant将升级现有的方案。
WorkflowCA:
WorkflowCA:为以下操作进行帐户连接测试:工作流
WorkflowCA:工作流帐户连接成功。
WorkflowCA:
WorkflowCA:正在检查现有的工作流版本
java.sql.SQLException:ORA-00942:tableorviewdoesnotexist
atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
atoracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
atoracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
atoracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
atoracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
atoracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
atoracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
atoracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
atoracle.apps.fnd.wf.install.db.WorkflowCA.schemaCreation(WorkflowCA.java:1159)
atoracle.apps.fnd.wf.install.db.WfFrame.actionPerformed(WfFrame.java:2051)
atoracle.ewt.button.PushButton.processActionEvent(UnknownSource)
atoracle.ewt.lwAWT.LWButton.processActionEvent(UnknownSource)
atoracle.ewt.button.PushButton.processEventImpl(UnknownSource)
atoracle.ewt.lwAWT.LWComponent.redispatchEvent(UnknownSource)
atoracle.ewt.lwAWT.LWComponent.processEvent(UnknownSource)
atoracle.ewt.button.PushButton.activate(UnknownSource)
atoracle.ewt.lwAWT.AbstractButton.processMouseReleased(UnknownSource)
atoracle.ewt.lwAWT.AbstractButton.processMouseEvent(UnknownSource)
atjava.awt.Component.processEvent(Component.java:5297)
atjava.awt.Container.processEvent(Container.java:1966)
atoracle.ewt.lwAWT.LWComponent.processEventImpl(UnknownSource)
atoracle.ewt.button.PushButton.processEventImpl(UnknownSource)
atoracle.ewt.lwAWT.LWComponent.redispatchEvent(UnknownSource)
atoracle.ewt.lwAWT.LWComponent.processEvent(UnknownSource)
atjava.awt.Component.dispatchEventImpl(Component.java:3999)
atjava.awt.Container.dispatchEventImpl(Container.java:2024)
atjava.awt.Component.dispatchEvent(Component.java:3834)
atjava.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
atjava.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
atjava.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
atjava.awt.Container.dispatchEventImpl(Container.java:2010)
atjava.awt.Window.dispatchEventImpl(Window.java:1791)
atjava.awt.Component.dispatchEvent(Component.java:3834)
atjava.awt.EventQueue.dispatchEventImpl(EventQueue.java:501)
atjava.awt.EventQueue.access$000(EventQueue.java:80)
atjava.awt.EventQueue$1.run(EventQueue.java:462)
atjava.awt.EventQueue$1.run(EventQueue.java:461)
atjava.security.AccessController.doPrivileged(NativeMethod)
atjava.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:84)
atjava.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:95)
atjava.awt.EventQueue$2.run(EventQueue.java:476)
atjava.awt.EventQueue$2.run(EventQueue.java:475)
atjava.security.AccessController.doPrivileged(NativeMethod)
atjava.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:84)
atjava.awt.EventQueue.dispatchEvent(EventQueue.java:473)
atjava.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
atjava.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
atjava.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
atjava.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
atjava.awt.EventDispatchThread.run(EventDispatchThread.java:110)
WorkflowCA:SatJun0315:28:55CST2017
WorkflowCA:(4)
WorkflowCA:Terminating...

分 -->

千问 · 2021-1-27 06:36:45

java.sql.SQLException:ORA-00942:tableorviewdoesnotexist

都提示你了，说表不存在，应该是没有执行初始化脚本。

千问 · 2021-1-27 06:36:45

是提示表或试图不存在。但是完全不知道少了什么表啊。数据库已经安装好了。之前也是这样安装的进程流，以前没有遇到这个问题。完全按之前的步骤做的（有文档参考）。这个表应该是系统的表，不是用户建立的表，也没有提示是什么表，只是说表不存在，不知道表名，无从下手啊