Problem with Sender JDBC adapter while processing the message

50 Views

Hi,

I am facing some problem while using the JDBC sender adapter.

Here is the trace where i have seen the Socket Closed problem. But it was for few seconds.

Later on it was working fine. This happens intermittently. So it was very difficult to collect the traces.

Please check the trace,

#1.5 #001A4B06B868008500001FF10000555D00045C190344E1D3#1227162409422#c

om.sap.aii.adapter.jdbc.JDBC2XI##com.sap.aii.adapter.jdbc.JDBC2XI.invoke()

#J2EE_GUEST#0##n/a##f30c1fd0b6ca11ddc489001a4b06b868#XI JDBC2XI[JDBC_Send/BSC/]_1235135

##0#0#Warning##Java###Catching #1#java.sql.SQLException:

[Microsoft][SQLServer 2000 Driver for JDBC]Socket closed

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.submitRequest(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)

at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:418)

at com.sap.aii.af.service.scheduler.JobBroker$Worker.run(JobBroker.java:475)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

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

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:102)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:172)

Can anyone please help me out why I am getting this error intermittently?

Any specific reason so that i can rectify.

Urs,

Soorya