Skip to Content
avatar image
Former Member

MS SQL Error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 12, 2015 at 07:07 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2015 at 09:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded