2229434 - PI JDBC Adapter - Issue during SQL update

• Within Process Integration (PI), you are experiencing an issue with messages processed through Receiver JDBC Adapter.
• Messages seem blocked in Delivering status (DLNG) even after restarting the channel.
• A Java Thread Dump triggered at this moment revels threads in Object.wait() or Runnable state with a similar stack trace:
  
  "XI XI2JDBC[<Channel>/<Service>/<Party>]_#" tid=t@5070974976 runnable
  at java.net.SocketInputStream.socketRead0(Ljava.io.FileDescriptor;[BIII)I(Native Method)
  at java.net.SocketInputStream.read([BII)I(SocketInputStream.java:129)
  at oracle.net.ns.Packet.receive()V(Packet.java:300)
  at oracle.net.ns.DataPacket.receive()V(DataPacket.java:106)
  at oracle.net.ns.NetInputStream.getNextPacket()V(NetInputStream.java:315)
  at oracle.net.ns.NetInputStream.read([BII)I(NetInputStream.java:260)
  at oracle.net.ns.NetInputStream.read([B)I(NetInputStream.java:185)
  at oracle.net.ns.NetInputStream.read()I(NetInputStream.java:102)
  at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket()V(T4CSocketInputStreamWrapper.java:124)
  at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read()I(T4CSocketInputStreamWrapper.java:80)
  at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1()S(T4CMAREngine.java:1137)
  at oracle.jdbc.driver.T4CTTIfun.receive()V(T4CTTIfun.java:345)
  at oracle.jdbc.driver.T4CTTIfun.doRPC()V(T4CTTIfun.java:223)
  at oracle.jdbc.driver.T4C8Oall.doOALL(ZZZZZLoracle.jdbc.internal.OracleStatement$SqlKind;I[BI[Loracle.jdbc.driver.Accessor;I[Loracle.jdbc.driver.Accessor;I[B[C[SILoracle.jdbc.driver.DBConversion;[B[[Ljava.io.InputStream;[[[B[[Loracle.jdbc.oracore.OracleTypeADT;Loracle.jdbc.driver.OracleStatement;[B[C[S[Loracle.jdbc.driver.T4CTTIoac;[I[I[ILoracle.jdbc.driver.NTFDCNRegistration;)V(T4C8Oall.java:531)
  at oracle.jdbc.driver.T4CStatement.doOall8(ZZZZZ)V(T4CStatement.java:193)
  at oracle.jdbc.driver.T4CStatement.executeForRows(Z)V(T4CStatement.java:1033)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout()V(OracleStatement.java:1327)
  at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(Ljava.lang.String;)I(OracleStatement.java:1836)
  at oracle.jdbc.driver.OracleStatement.executeUpdate(Ljava.lang.String;)I(OracleStatement.java:1801)
  - locked<0x3aba28d60> (a oracle.jdbc.driver.T4CConnection)
  at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(Ljava.lang.String;)I(OracleStatementWrapper.java:294)
  at com.sap.aii.adapter.jdbc.SAXHandler.executeUpdate(Ljava.lang.String;)I(xml2sql.java:2410)
  at com.sap.aii.adapter.jdbc.SAXHandler.SQLupd(Ljava.lang.String;I)I(xml2sql.java:1764)
  at com.sap.aii.adapter.jdbc.SAXHandler.processList()V(xml2sql.java:831)
  at com.sap.aii.adapter.jdbc.SAXHandler.endElement"

• PI Release Independent
• SAP NetWeaver
• SAP Process Integration

Process Integration 7.0, PI 7.0, PI 7.01, PI 7.02, Process Integration 7.10, PI 7.10, Process Integration 7.11, PI 7.11, Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.40, PI 7.40, PO 7.40, Process Orchestration 7.50, PI 7.50, PO 7.50, NetWeaver, XI, AEX, IBM AS400, DB2 , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem