cancel
Showing results for 
Search instead for 
Did you mean: 

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.

santhosh_sontha2
Explorer
0 Kudos


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

Accepted Solutions (0)

Answers (2)

Answers (2)

anupam_ghosh2
Active Contributor
0 Kudos

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

dipen_pandya
Contributor
0 Kudos

Hi,

AFAIK,

You have to increase pool size.

Refer this thread

Regards,

Dipen.

santhosh_sontha2
Explorer
0 Kudos


Hi Dipen,

Thanks for your reply.

Can you let me know where to for increasing pool size. Currently we are in  SAP PI 7.4.

Regards,

Santhosh

dipen_pandya
Contributor
0 Kudos

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.