Salesforce

Space Automation Pro throwing a Pooled connection timed out error when processing data

« Go Back

Information

 
TitleSpace Automation Pro throwing a Pooled connection timed out error when processing data
SummarySpace Automation Pro script has been developed to load data into specific planogram performance fields for selected planograms. When more than 100 planograms are selected the database throws a Pooled connection request timed out error.
URL NameSpace-Automation-Pro-throwing-a-Pooled-connection-timed-out-error-when-processing-data
Resolution
  • Increase the Max Pool Size attribute of the ConnectionString property.
Syntax:
Data Source=urOracle;User Id=urUsername;Password=urPassword;Max Pool Size=50;Connection Timeout=60;

Sample Code of setting Max Pool Size to 1000 using IKBDbSupport to connect to Oracle database in C#:
string ldb = "ckb20171";
string lhoststring = "ckb20171";
string luserid = "ckb";
string lpwd = "ckb999";
string lPoolSize = "1000";
string lconnString = string.Format("Data Source ={0}; User Id = {1}; Password = {2}; Max Pool Size = {3}", lhoststring, luserid, lpwd, lPoolSize);
dbsupport = new IKBDbSupport("Category Knowledge Base",lconnString,ldb.ToUpper(),DbProviderType.Oracle,60);
ProductsSpace Automation Professional
Module
VersionAll
Error Message Code
Database connection unavailable or connection string is invalid
Pooled connection request timed out   at JDA.Intactix.DataAccess.DbSupport.GetActiveDbConnection()
Cause
No connections are available from the connection pool when odp.net attempts to connect to Oracle Database
Additional Information
  • Default value of Max Pool Size is 100
  • Max Pool Size attribute is an attribute of the ConnectionString property that sets the maximum number of connections for a connection pool from ODP.NET to Oracle database
  • Refer to the Oracle website under Features of Oracle Data provider for .NET for more info
Publication StatusPublished

Powered by