MS SQL Error

[Former Member]

Hi Guys,

while sending data to MSSQL via SOAP adapter, but we are getting following error;

com.sap.engine.interfaces.messaging.api.exception.MessagingException: SOAP: response message contains an error XIAdapter/PARSING/ADAPTER.SOAP_EXCEPTION - soap fault: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at PROD.find() in C:\inetpub\wwwroot\prd\App_Code\Data Class\PROD.vb:line 289 at Service.Dosyalar(SAP Table) in C:\inetpub\wwwroot\prd\App_Code\Service.vb:line 1647 --- End of inner exception stack trace

Is this exception on SOAP Adapter Receiver side to handle or by the server side?

Thank you in advance

PM

[Former Member]

Hi Peter

Looks like the problem is with your web service.

https://support.managed.com/kb/a493/error-max-pool-size-was-reached-when-trying-to-view.aspx

But it would be nice if you can try to test it from SOAP UI as mentioned by Inaki.

If you face the same problem in SOAP UI as well, then you have to check in web service side.

Thanks,

Indrajit

[iaki_vila]

Hi Peter,

Are you setting the SOAP Operation in the receiver SOAP adapter?. Check your SOAP endpoing with a third too like SOAPui (it's free). This tool can help you to determine what is the SOAP Operation and to test if your XML is correct according with the SOAPui request example, and to find a correct example. (Web Service Sample Project | Getting Started)

Regards.