Running DNN 5.6.3 and DNNSpot Rotator 2.0.5

About a month ago the website at www.FortSmithSchools.org started throwing a YSOD on the Homepage and any page that contained an instance of the DNNSpot Rotator.

In a panic, I upgraded to the latest Rotator Version (2.0.5) and it fixed the problem.

This morning it happened again and I Re-installed/Repaired the Module again.  Again it fixed the problem.

Below is the error in the DNN Event Veiwer:

AssemblyVersion: 5.6.3
PortalID: 0
PortalName: Fort Smith Schools
UserID: -1
UserName:
ActiveTabID: 40
ActiveTabName: Home
RawURL: /Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET4.0C; .NET4.0E; AskTbORJ/5.15.1.22229)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 216910bf-46a2-403b-af7c-db450245e291
InnerException: Unhandled Error:
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Configuration.Enumerator.System.Collections.IEnumerator.MoveNext
StackTrace:
Message: System.Exception: Unhandled Error: ---> DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at System.Configuration.ConfigurationElementCollection.Enumerator.System.Collections.IEnumerator.MoveNext() at EntitySpaces.Interfaces.esConfigSettings.get_DefaultConnection() at EntitySpaces.Interfaces.esConnection.get_SqlAccessType() at DNNspot.Rotator.DataModel.esTemplate.LoadByPrimaryKey(Int32 id) at DNNspot.Rotator.Default.GenerateOutputFromTemplate() at DNNspot.Rotator.Default.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) at DotNetNuke.Framework.PageBase.OnError(EventArgs e) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.default_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace -v

Sorry to hear you're having issues.

Do you have multiple database connections for this site? It looks like it might be an issue with the Rotator being unable to connect to the database.

Does the user you're running the database as have the permissions 'db.owner'?

Matt

This is a strange error. Is it happening every time you load the page? If so, is there a way you could email me a copy of the files and database so that I could debug the issue and find a solution?

Matt

When this  happens (twicw now) any page with an instance of the Rotator throws this error and the visitor gets a nasty YSOD.  Since it's on the Homepage of the Fort Smith Schools District Website it makes it appear as if the entire site is down.  Any other page loads fine and all other modules work as expected.

As I said before, the cure is to reinstall the DNNSpot Rotator which has fixed the problem both times.

Curently the site is running fine, but I need to find out what's going on to prevent it.

I could easily send you a database backup.  All of the site files are over 1Gb, so if there was something specific you wanted. like the DesktopModules/DNNSpot-Rotator folder, just let me know.

I'm unable to replicate the error...thus if you create the backup when you're getting this error, I should be able to get the same error in my development environment, which should help produce a fix.

Feel free to knock out any large files or unneeded portals in the folder structure. Essentially, I'll restore the entire site in a development environment. Since you'll make the backup when the site is throwing the error, in theory, I should see the same screen and be able to use several development tools to track down the specific issue.

Feel free to email me a link with the database and files backup. My email address is web@dnnspot.com.

***Please be sure to create the backup once you get this error, otherwise I won't be able to easily replicate the error***

Matt