SAP Knowledge Base Article - Preview

2229434 - PI JDBC Adapter - Issue during SQL update

Symptom

  • 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"


Read more...

Environment

  • PI Release Independent
  • SAP NetWeaver
  • SAP Process Integration

Product

SAP NetWeaver all versions ; SAP Process Integration all versions

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.