3 Replies Latest reply: May 6, 2014 5:05 AM by Sat_M RSS

    ODI 12c: SQLException Protocol violation Error Code

    Sat_M

      I have four mappings if run individually work correctly.

       

      But when included in a Package (WF) and run them with the same mappings etc. Variable defined.; opens a popup with the following error:

       

      oracle.odi.core.persistence.transaction.TransactionSystemException: ODI-10207: Uncategorized exception during transaction system usage.         

      Internal Exception: java.sql.SQLException: Protocol violation

      Error Code: 17401

      at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.translateSpringTransactionException(TransactionManagerSpringAdapter.java:286)

      at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.rollback(TransactionManagerSpringAdapter.java:92)

      at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:73)

      at com.sunopsis.graphical.dialog.SnpsDialogExecution.doPackageExecuter(SnpsDialogExecution.java:830)

      at oracle.odi.ui.action.SnpsPopupActionExecuteHandler.actionPerformed(SnpsPopupActionExecuteHandler.java:154)

      at oracle.odi.ui.SnpsFcpActionAdapter.handleEvent(SnpsFcpActionAdapter.java:390)

      at oracle.ide.controller.IdeAction$ControllerDelegatingController.handleEvent(IdeAction.java:1482)

      at oracle.ide.controller.IdeAction.performAction(IdeAction.java:663)

      at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:1153)

      at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:618)

      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)

      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)

      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)

      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:290)

      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)

      at java.awt.Component.processMouseEvent(Component.java:6505)

      at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)

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

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

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

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

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

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

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

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

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

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

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

      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)

      at java.awt.EventQueue.access$200(EventQueue.java:103)

      at java.awt.EventQueue$3.run(EventQueue.java:694)

      at java.awt.EventQueue$3.run(EventQueue.java:692)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)

      at java.awt.EventQueue$4.run(EventQueue.java:708)

      at java.awt.EventQueue$4.run(EventQueue.java:706)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

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

      at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

      at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

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

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

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

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

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

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

      Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLException: Protocol violation

      Error Code: 17401

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)

      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1501)

      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicRollbackTransaction(DatabaseAccessor.java:1591)

      at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.rollbackTransaction(DatasourceAccessor.java:672)

      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.rollbackTransaction(DatabaseAccessor.java:1576)

      at org.eclipse.persistence.internal.sessions.AbstractSession.basicRollbackTransaction(AbstractSession.java:629)

      at org.eclipse.persistence.sessions.server.ClientSession.basicRollbackTransaction(ClientSession.java:186)

      at org.eclipse.persistence.internal.sessions.AbstractSession.rollbackTransaction(AbstractSession.java:3561)

      at org.eclipse.persistence.sessions.broker.SessionBroker.basicRollbackTransaction(SessionBroker.java:278)

      at org.eclipse.persistence.internal.sessions.AbstractSession.rollbackTransaction(AbstractSession.java:3561)

      at oracle.odi.core.persistence.toplink.jpasessionbroker.SessionBroker2ClientSessionAdapter.rollbackTransaction(SessionBroker2ClientSessionAdapter.java:1174)

      at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.rollbackTransaction(UnitOfWorkImpl.java:4641)

      at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.rollbackTransaction(RepeatableWriteUnitOfWork.java:522)

      at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.release(UnitOfWorkImpl.java:4448)

      at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.rollback(EntityTransactionImpl.java:127)

      at oracle.odi.core.persistence.jpa.JpaOdiTransactionManager.doRollback(JpaOdiTransactionManager.java:460)

      at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:742)

      at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:719)

      at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.rollback(TransactionManagerSpringAdapter.java:88)

      ... 48 more

      Caused by: java.sql.SQLException: Protocol violation

      at oracle.jdbc.driver.T4CTTIfun.readDCB(T4CTTIfun.java:678)

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

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

      at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:72)

      at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:751)

      at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:5150)

      at sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:606)

      at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:292)

      at com.sun.proxy.$Proxy18.rollback(Unknown Source)

      at sun.reflect.GeneratedMethodAccessor233.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:606)

      at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$ConnectionInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:132)

      at com.sun.proxy.$Proxy19.rollback(Unknown Source)

      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicRollbackTransaction(DatabaseAccessor.java:1585)

      ... 64 more

       

      Does anyone know what's happening? I do not understand. Thanks for any help is very inconvenient to have to manually execute each mapping, I need you to run the package and do not know why it gives the error.

       

      If it is a BUG and I is the second meeting (together the inability to modify users) in this version of ODI.

       

      Thank you all.