Skip to Content
avatar image
Former Member

Error in PI :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.


Dear All,

We have a scenario where we need to get weather data from website www.webserviceX.NET and store weather data in ECC. Scenario will be syncronous proxy(ECC)->PI->soap(webserviceX). The limitation for this website is it will accept 1 city per call, hence if we want to retreive weather for 10 cities then 10 soap calls to be made. To acheive this we created a report in ECC & scheduled to run in background. This report works fine when run in foreground for all cities but when we run in background we will recive below error message in PI for some of the soap calls. Ex: If 10 calls were made in background 3 to 4 calls will fail with below mentioned error. Your inputs on this will be highly appreciated.

Error message in SXMB_moni of PI

com.sap.engine.interfaces.messaging.api.exception.MessagingException: SOAP: Response message contains an errorXIAdapter/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.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)   at System.Data.SqlClient.SqlConnection.Open()   at WebServicex.GlobalWeather.GetWeather(String CityName, String CountryName)   --- End of inner exception stack trace ---</

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 05, 2015 at 05:27 AM

    Hi,

    AFAIK,

    You have to increase pool size.

    Refer this thread

    Regards,

    Dipen.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Ask your BASIS team to increase JCO connections.

      Refer this link

      PS: Visual Admin is now not in 7.4 version so ask your basis team to perform it on cluster like;

      server 0->services->JCO RFC Connections

      Try this.

      BR,

      Dipen.

  • Feb 05, 2015 at 11:39 AM

    Hi Santhosh,

                         The issue is with background job . The same runs ok with foreground job.

    Thus need to check if  background job making the connection pool calls faster than foreground process. If this is the case then even if you increase the pool size the problem will surface again.

    Regards

    Anupam

    Add comment
    10|10000 characters needed characters exceeded