Problem with Sender JDBC adapter while processing the message

[Former Member]

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.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

[dharamveer_gaur2]

Hi

First check Database Driver is Installed.

Now try to access the IPADDRESS and PORT on which the DB is running from your XI server.

Check if connectivity to the same is available. Socket Closed Exception looks like a connectivity and authorization issue.

[Former Member]

Hi,

We have checked all those but still we could not find any problem. And we are not getting this error for

continously . Only intermittently. So what could be the reason behind this. It is not remaining for long time.

so please tell me the exact reason behind this problem to overcome this problem for ever.

Thanks

Soorya