JustNik

Quick Tip: Adding properties to Members results in a timeout

Umbracologoblue05

There you are, working away on an Umbraco site with a large member base, and you need to add a new property. So off you go and add it to the member type... you click save.......

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.

Not the message you want to see when saving a property on a member type, or performing a uSync import that does the same action!

Well, that is exactly what happened to me sigh.

So, after some googling, I was fortunate to come across this little twitter thread:

And this helpful response:

So that is exactly what I did, I extended the timeout on my connection string temporarily and boom member property added!

Note This blog entry is a quick tip, and over time may become outdated. There may also be better alternative solutions to the problem.

JustNik
Connect with me
Twitter GitHub LinkedIn
© JustNik 2024