My event viewer is showing the error pasted below referring to "Object reference not set to an instance of an object". This error seems to occur in sets of 4. Meaning there are usually 4 of these reported at the same time, each time.
My report is using a SQL Server Stored Procedure with two parameters. It is using the html visualizer. The report runs well, the parameters are used successfully and the output matches the design of the html template. So all appears well except that these errors keep being reported and the app (DNN) has been restarting frequently causing very poor website performance.
How do I resolve these errors? Thank you for your response.
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: Object reference not set to an instance of an object.
Message: System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Modules.Reports.ReportsController.BuildParameters(PortalModuleBase SrcModule, ReportInfo Report) at DotNetNuke.Modules.Reports.ReportsController.ExecuteReport(ReportInfo objReport, String cacheKey, Boolean bypassCache, PortalModuleBase hostModule, Boolean& fromCache) at DotNetNuke.Modules.Reports.ReportsController.ExecuteReport(ReportInfo objReport, String cacheKey, Boolean bypassCache, PortalModuleBase hostModule) at DotNetNuke.Modules.Reports.ReportsController.GetSearchItems(ModuleInfo ModInfo) at DotNetNuke.Services.Search.ModuleIndexer.GetSearchIndexItems(Int32 PortalID)