I use the reports module frequently. And I also use url querystring parameters to communicate with the report SQL the parameters it needs. I have noticed that the report modules appear to be generating error reports in the DNN Event Viewer even when the report has not been viewed. For example, right now, I'm running a DNN instance on my laptop and am not viewing a page with the report module on it in any browser tab. I can clear the event viewer, wait a minute and refresh the Event Viewer and see multiple error messages that basically say the report was expecting a variable that it was not given. I'll paste an error below. My question is, why are there report module errors being generated when the report is not even being viewed or refreshed?
AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:a29c05e0-1665-4d7e-9d48-84656439b531
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:LRQt1FEWb0D0Pb7DNOa79Q==
Message:There is an error in your SQL at line 1: Must declare the scalar variable "@url_DSParam1".
StackTrace:
at DotNetNuke.Modules.Reports.DataSources.DotNetNuke.DotNetNukeDataSource.ExecuteSQLReport()
at DotNetNuke.Modules.Reports.ReportsController.ExecuteReport(ReportInfo objReport, String cacheKey, Boolean bypassCache, PortalModuleBase hostModule, Boolean& fromCache)
at DotNetNuke.Modules.Reports.ReportsController.GetSearchItems(ModuleInfo ModInfo)
at DotNetNuke.Services.Search.ModuleIndexer.GetSearchIndexItems(Int32 portalId)
InnerMessage:
InnerStackTrace:
Source:DotNetNuke.Modules.Reports
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Name: MyComputerName