7 Replies Latest reply: Jan 24, 2013 4:30 AM by 781306 RSS

    ODI Protocol violation: [73] while creating a Scenario

    781306
      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)