This discussion is archived
7 Replies Latest reply: Jan 24, 2013 2:30 AM by 781306 RSS

ODI Protocol violation: [73] while creating a Scenario

781306 Newbie
Currently Being Moderated
While creating a scenario, I received a Protocol Violation error. Currently, I am using the Standalone Edition Verion (11.1.1) of ODI Studio. I have installed the recent middleware java component, which is 1.6.0_29 32bit. I am running ODI Studio on Windows 64bit. My Oracle database is 10g 64bit. I am not sure if my issue is both the ODI and Java version installed. This is the error.

com.sunopsis.dwg.SQLWorkReposException: Protocol violation: [73]
     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:502)
     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
     at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:111)
     at $Proxy3.executeQuery(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$StatementInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:173)
     at $Proxy4.executeQuery(Unknown Source)
     at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java:645)
     at com.sunopsis.dwg.dbobj.generated.GeneratedSnpLockedObject.getObjectLst(GeneratedSnpLockedObject.java:380)
     at oracle.odi.ui.OdiDisconnectController.performDisconnect(OdiDisconnectController.java:162)
     at oracle.odi.ui.OdiAddin$11.canShutdown(OdiAddin.java:627)
     at oracle.ide.cmd.ExitCommand.canShutdown(ExitCommand.java:181)
     at oracle.ide.cmd.ExitCommand.doit(ExitCommand.java:357)
     at oracle.ide.controller.CommandProcessor.invoke(CommandProcessor.java:317)
     at oracle.ide.IdeCore.quit(IdeCore.java:786)
     at oracle.ide.Ide.quit(Ide.java:604)
     at oracle.ideimpl.MainWindowImpl$5.windowClosing(MainWindowImpl.java:380)
     at java.awt.AWTEventMulticaster.windowClosing(AWTEventMulticaster.java:332)
     at java.awt.AWTEventMulticaster.windowClosing(AWTEventMulticaster.java:332)
     at java.awt.Window.processWindowEvent(Window.java:1865)
     at javax.swing.JFrame.processWindowEvent(JFrame.java:274)
     at java.awt.Window.processEvent(Window.java:1823)
     at java.awt.Component.dispatchEventImpl(Component.java:4651)
     at java.awt.Container.dispatchEventImpl(Container.java:2099)
     at java.awt.Window.dispatchEventImpl(Window.java:2478)
     at java.awt.Component.dispatchEvent(Component.java:4481)
     at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
     at java.awt.EventQueue.access$000(EventQueue.java:84)
     at java.awt.EventQueue$1.run(EventQueue.java:602)
     at java.awt.EventQueue$1.run(EventQueue.java:600)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
     at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
     at java.awt.EventQueue$2.run(EventQueue.java:616)
     at java.awt.EventQueue$2.run(EventQueue.java:614)
     at java.security.AccessController.doPrivileged(Native Method)
     at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
     at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
     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)

Legend

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