Just to update the stack trace error is

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.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: 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.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[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.]
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +5024537
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
   System.Data.SqlClient.SqlConnection.Open() +125
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +65
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +117
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +150

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +232
   Umbraco.Forms.Data.Storage.FieldStorage.GetAllFields(FieldSet fieldset) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Data\FormStorage\FieldStorage.cs:73
   Umbraco.Forms.Data.Storage.FieldSetStorage.GetAllFieldSets(Page page) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Data\FormStorage\FieldSetStorage.cs:42
   Umbraco.Forms.Data.Storage.PageStorage.GetAllPages(Form form) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Data\FormStorage\PageStorage.cs:41
   Umbraco.Forms.Data.Storage.<>c__DisplayClass9.<GetForm>b__8() in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Data\FormStorage\FormStorage.cs:133
   umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +213
   umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +112
   umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemRemovedCallback refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +109
   Umbraco.Forms.Core.Services.CacheService.GetCacheItem(String cacheKey, Object syncLock, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Services\CacheService\CacheService.cs:62
   Umbraco.Forms.Data.Storage.FormStorage.GetForm(Guid id) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.Core\Data\FormStorage\FormStorage.cs:124
   Umbraco.Forms.UI.Pages.editForm.Page_Load(Object sender, EventArgs e) in d:\TeamCity\buildAgent\work\e4473b9ec9597356\Umbraco.Forms.UI\Pages\editForm.aspx.cs:32
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   umbraco.BasePages.BasePage.OnLoad(EventArgs e) +49
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207








Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

Regards

Ismail

Seems like someone doesn't dispose correctly, or just tries to do too many things at the same time. You can try to temporarily increase the number of connections in the pool  by appending something like Max Pool Size=75;Min Pool Size=5; to the connection string. However you will probably run into the same situation sooner or later so it's just a temporary fix before the real issue is resolved.

If you have custom prevalue types or fields using sql connections, make sure that  you call dispose after use as this might also be a source of your problems.

Harald,

I am not using any custom fields as yet. I am using quite a few prevalue fields where the source is umbraco documents.  It does all save however i have to restart app pool to get back into umbraco.  It may be after save the form refresh is causing the issue? I will try your suggestion just so i can get all the forms created.

Regards

Ismail

Harald,

That didnt work, also now i cannot create any further new steps. Well i can create the new step add fields but then clicking on save fails and nothing is saved.

Regards

Ismail

Hey Ismail,

This does look like a DB connection pooling issue. I wouldnt recommend uping the pool size without first finding the problem.

I have only seen his a few times in the past - asn as said above - its usually down to non closed connections.

Is your app's DB shared with any other environments?

Chris.

Chris,

Nope just standard umbraco 451 db with contour tables.  The error only seems to occur on that one form think it started after i got half way through second page of the form it is quite a big form however i have done similar size form with umbraco 4.0.3 and contour 1.0. Yesterday I created a new one page form and that worked fine.

Regards

Ismail

Hi Ismail,

Will try to reproduce the error and get back to you with more info.

The prevalue fields where the source is an umbraco document, how many items do these have (just so I can setup a similar form).

Cheers,
Tim

Tim,

The source nodes for umbraco document pre value fields range from 2 to 20. If you wish I can send you a dump of the database or an export of the form definition. Just jump onto skype and i can forward it on.

Regards

Ismail

Tim,

Awesome many thanks.

Regards

Ismail

Ok think I found the issue,

Could you download the update zip here: http://nightly.umbraco.org/Umbraco%20Contour/1.1.3%20WIP/

All you would need to replace is the Umbraco.Forms.Core assembly

Let me know if that resolves the issue

Regards,
Tim

Tim,

Awesome that worked a treat.

Regards

Ismail

Great, glad it's resolved!

is working on a reply...