Please ensure that your data service is online and running and that the connection string in your web.config file is correct and make sure the key specified by
ConnnectionStringName exists in connectionStrings section.
To configure your connection string:
1. Open [Install Location of eCommerce Framework]\PublicStore\web.config
2. Within web.config find the configuration section (highlighted) below:
|
<configuration>
<ClientConfig>
<Settings ConnectionStringName="EcfSqlConnection" SubscriptionId="{SUBSCRIPTION_GUID}"
CartKey="ShoppingCartKey" AffiliateKey="AffiliateKey" Expires="24"></Settings>
</ClientConfig>
...
<connectionStrings>
<add name="EcfSqlConnection" connectionString="{connection string to your database}"/>
</connectionStrings>
</configuration>
|
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 Mediachase.eCF.DataLayer.TransactionScope.Enlist(IDbCommand cmd, String connectionString, ConnectionDelegate connection)
at Mediachase.eCF.DataLayer.Provider.SqlDataProvider.LoadTable(DataCommand command)
at Mediachase.eCF.DataLayer._Discount.LoadAll()
at Mediachase.eCF.BusLayer.SiteStructure.Products.Sku.get_Discounts()
at Mediachase.eCF.BusLayer.SiteStructure.Products.Sku.get_Discount()
at Mediachase.eCF.BusLayer.SiteStructure.Products.Sku.get_FinalPrice()
at Mediachase.eCF.BusFacade.Filters.Products.ProductVariationsContentFilter.CreateSkuOffer(Sku skus, String currencyCode)
at Mediachase.eCF.BusFacade.Filters.Products.ProductVariationsContentFilter.CreateSkuItems(Sku skus, String currencyCode, String[] responseGroup)
at Mediachase.eCF.BusFacade.Filters.Products.ProductVariationsContentFilter.CreateProductItem(Item& item, Product prd, String currencyCode, String[] responseGroup, IList`1& errorArray)
at Mediachase.eCF.BusFacade.ContentFilters.PopulateProductItem(Item& productItem, Product product, String currencyCode, String[] responseGroup, IList`1& errorArray)
at Mediachase.eCF.BusFacade.SiteManager.ProcessSiteLookupRequest(SiteLookupRequest request, IList`1& errorArray)
at Mediachase.eCF.BusFacade.SiteManager.SiteLookup(SiteLookup lookup)
at Mediachase.eCF.ClientLib2.ClientProduct.LookupProducts(SiteLookupRequestIdType type, Int32[] objects, String[] responseGroups, ErrorsError[]& errors)
|