Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
I've been tasked with maintaining a customer's old EPiServer (5.2.375.2XX) site, which was not originally developed by me or my colleagues. My main EPiServer experience is with versions 7.5+. The site uses EPiServer's subscription subsystem, and has for, over a year, worked without any known glitches. In November last year, the subscription page (where a user can choose to subscribe/unsubscribe to/from pages) stopped working, giving the following error in the logs:
I did some testing and research and it did seem like the default 30 second timeout (SqlCommand.CommandTimeout) was reached, causing the error. I was not able to find out why since nearly all of the code of interest is EPiServer's own. Also, the error did not occur in my development environment, with an identical copy of the production database. However, the wisdom of the internet suggested that a bad query plan in SQL Server could be the culprit, and one of the suggested solutions was to clear the query plan cache.
The first time the issue occurred it was eventually "solved" by stopping IIS, taking database offline/online, and then starting IIS. However, recently the subscription page stopped working again, giving a nearly identical error (see below), and the former "solution" no longer works.
"C:\Sites\Customer\src\www\CustomerTemplates\Public\Units\Placeable\SubscriptionPage.ascx.cs:line 75" is the line after "SubscriptionList.DataBind()" is called.
When I first encountered this issue I verified the following:
The site is not massive (admin interface reporting roughly 24000 pages in database), so I don't really see how the amount of data could be an issue. Also, the scheduled job responsible for sending subscription e-mails finishes in ~15 seconds.
Does anyone have an idea of what could be the cause of the issue, and how to solve it?