This discussion is archived
3 Replies Latest reply: Jul 18, 2013 8:16 AM by Mark Kelly RSS

Failed to open workflow error

31cfa3cd-0b06-4698-b955-de30e1e09c9f Newbie
Currently Being Moderated

Hello,

 

I created a simple workflow in ODM (6-8 nodes). I tested it and got an error. I didn't record this as I thought it was just a case of a bug being present in the workflow. When the error was dismissed the workflow was locked and the stop button had disappeared. I tried opening and closing the workflow however I now get the errors below when I attempt to open the workflow.

 

Any help would be greatly appreciated. Thank you!

 

Application Error

 

Failed to open workflow.

 

Details

 

oracle.ide.dialogs.ProgressException: java.sql.SQLException: ORA-30991: cannot use DOM to add special attribute to schema-based parent

ORA-06512: at "ODMRSYS.ODMR_WORKFLOW", line 123

ORA-06512: at line 1

 

 

  at oracle.ide.dialogs.ProgressRunnable.start(ProgressRunnable.java:136)

  at oracle.dmt.dataminer.workflow.WorkflowEditor.load(WorkflowEditor.java:410)

  at oracle.dmt.dataminer.workflow.WorkflowEditor.open(WorkflowEditor.java:290)

  at oracle.ideimpl.editor.EditorState.openEditor(EditorState.java:283)

  at oracle.ideimpl.editor.EditorState.createEditor(EditorState.java:184)

  at oracle.ideimpl.editor.EditorState.getOrCreateEditor(EditorState.java:95)

  at oracle.ideimpl.editor.SplitPaneState.canSetEditorStatePos(SplitPaneState.java:232)

  at oracle.ideimpl.editor.SplitPaneState.setCurrentEditorStatePos(SplitPaneState.java:195)

  at oracle.ideimpl.editor.TabGroupState.createSplitPaneState(TabGroupState.java:102)

  at oracle.ideimpl.editor.TabGroup.addTabGroupState(TabGroup.java:379)

  at oracle.ideimpl.editor.EditorManagerImpl.createEditor(EditorManagerImpl.java:1403)

  at oracle.ideimpl.editor.EditorManagerImpl.createEditor(EditorManagerImpl.java:1337)

  at oracle.ideimpl.editor.EditorManagerImpl.openEditor(EditorManagerImpl.java:1263)

  at oracle.ideimpl.navigator.OpenEditorController.whenOpenEditor(OpenEditorController.java:41)

  at oracle.ideimpl.navigator.OpenEditorContextMenuListener.handleDefaultAction(OpenEditorContextMenuListener.java:51)

  at oracle.ide.controller.ContextMenuListenersHook$LazyContextMenuListener.handleDefaultAction(ContextMenuListenersHook.java:199)

  at oracle.ide.controller.ContextMenu.fireDefaultAction(ContextMenu.java:434)

  at oracle.ideimpl.explorer.BaseTreeExplorer.fireDefaultAction(BaseTreeExplorer.java:1835)

  at oracle.ideimpl.explorer.BaseTreeExplorer.dblClicked(BaseTreeExplorer.java:2176)

  at oracle.ideimpl.explorer.BaseTreeExplorer.mouseReleased(BaseTreeExplorer.java:2205)

  at oracle.ideimpl.explorer.CustomTree.processMouseEvent(CustomTree.java:211)

  at java.awt.Component.processEvent(Component.java:5899)

  at java.awt.Container.processEvent(Container.java:2023)

  at java.awt.Component.dispatchEventImpl(Component.java:4501)

  at java.awt.Container.dispatchEventImpl(Container.java:2081)

  at java.awt.Component.dispatchEvent(Component.java:4331)

  at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4301)

  at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3965)

  at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3895)

  at java.awt.Container.dispatchEventImpl(Container.java:2067)

  at java.awt.Window.dispatchEventImpl(Window.java:2458)

  at java.awt.Component.dispatchEvent(Component.java:4331)

  at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)

  at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

  at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

  at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)

  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

  at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

  at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

Caused by: java.sql.SQLException: ORA-30991: cannot use DOM to add special attribute to schema-based parent

ORA-06512: at "ODMRSYS.ODMR_WORKFLOW", line 123

ORA-06512: at line 1

 

 

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)

  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)

  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)

  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)

  at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4739)

  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)

  at oracle.dmt.dataminer.generated.server.OdmrWorkflow.wfLoad(OdmrWorkflow.java:72)

  at oracle.dmt.dataminer.repository.Workflow.load(Workflow.java:139)

  at oracle.dmt.dataminer.workflow.WorkflowEditor$1Loader.doWork(WorkflowEditor.java:371)

  at oracle.ide.dialogs.ProgressRunnable.run(ProgressRunnable.java:161)

  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)

  at java.lang.Thread.run(Thread.java:619)

 

 

Connection Error

 

An error was encountered performing the requested operation:

 

ORA-30991: cannot use DOM to add special attribute to schema-based parent

ORA-06512 at "ODMRSYS.ODMR_WORKFLOW", line 123

ORA-06512: at line 1

  • 1. Re: Failed to open workflow error
    Mark Kelly Oracle ACE
    Currently Being Moderated

    Hi,

      Has ODMr been working for you prior to this error or was this your initial test?

      What version of SQL Dev and Oracle Db are you using?

      Can you create any workflows at all, even a single Data Source node and run it?

    Thanks, Mark

  • 2. Re: Failed to open workflow error
    31cfa3cd-0b06-4698-b955-de30e1e09c9f Newbie
    Currently Being Moderated

    Hi Mark,

     

    Thanks very much for your reply and sorry for the delay in getting back to you.

     

    I am using sql developer version 3.1.07 and the DB version is 11g.

    This was not my initial test (which worked) and a single node will run fine. I can replicate the issue when using the aggregate transform. The initial error that I get is below. Then I get the errors from my first post when I try to reopen the workflow.

     

    Many thanks again,

     

    Will

     

    Application Error

     

    Inconsistent state - finished job detected, but unable to reload the editor.

     

    Details

     

    oracle.ide.dialogs.ProgressException: java.sql.SQLException: ORA-30991: cannot use DOM to add special attribute to schema-based parent

    ORA-06512: at "ODMRSYS.ODMR_WORKFLOW", line 123

    ORA-06512: at line 1

     

     

      at oracle.ide.dialogs.ProgressRunnable.start(ProgressRunnable.java:136)

      at oracle.dmt.dataminer.workflow.WorkflowEditor.reload(WorkflowEditor.java:590)

      at oracle.dmt.dataminer.workflow.WorkflowEditor.jobFinished(WorkflowEditor.java:744)

      at oracle.dmt.dataminer.runner.RunItem.fireJobFinished(RunItem.java:345)

      at oracle.dmt.dataminer.runner.RunItem.access$400(RunItem.java:45)

      at oracle.dmt.dataminer.runner.RunItem$4.run(RunItem.java:216)

      at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

      at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

    Caused by: java.sql.SQLException: ORA-30991: cannot use DOM to add special attribute to schema-based parent

    ORA-06512: at "ODMRSYS.ODMR_WORKFLOW", line 123

    ORA-06512: at line 1

     

     

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)

      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)

      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)

      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)

      at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4739)

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)

      at oracle.dmt.dataminer.generated.server.OdmrWorkflow.wfLoad(OdmrWorkflow.java:72)

      at oracle.dmt.dataminer.repository.Workflow.load(Workflow.java:139)

      at oracle.dmt.dataminer.workflow.WorkflowEditor$2Loader.doWork(WorkflowEditor.java:533)

      at oracle.ide.dialogs.ProgressRunnable.run(ProgressRunnable.java:161)

      at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)

      at java.lang.Thread.run(Thread.java:619)

  • 3. Re: Failed to open workflow error
    Mark Kelly Oracle ACE
    Currently Being Moderated

    Hi Will,

      We have made a number of fixes in SQl Dev 4.0 EA1 that may address this issue.

      Can you try it out?

    • Download SQL Dev 4.0 EA1 (just released) from the SQL Dev site.
    • Drop the existing ODMr repository using the menu option Tools -> Data Miner -> Drop Repository
    • Install the new repository

     

    If you install it on the new 12.1 db you will also experience much better workflow performance as the underlying Data Miner repository has been reworked to use XMLDB Binary storage when installed on  11.2.0.4 (soon to come out) and above.

    Thanks, Mark

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points