Hi Ernst Peter!
Reports version: 5.7.1
DNN version: 07.04.00 (353)

I used your contact us form on EXCESS.nl website to give you the stored procedure.

Here is the error logged in the event viewer,

AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:f503dbe0-500b-4a30-93f3-174089da5d98
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:ll4ftcTvk77Z/t3b8yMmyA==
Message:There is an error in your SQL at line 1: Must declare the scalar variable "@url_EID".
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:


And in the report settings,

Allowed URL Parameters:
EID,OID,DEN,Z,SD,ET


Query:
_LIS_GetEventsListings @EID=@url_EID,
@OID=@url_OID,
@DEN=@url_DEN,
@Z=@url_Z,
@SD=@url_SD,
@ET=@url_ET,
@UserID=@UserID

Was any resolution found on this? I am having the same exact problem. I have several Report Modules, I have disable Indexing on BOTH the Modules themselves and the PAGES they are on. But every few minutes I get several errors:

11/24/2015 9:58:12 AMGeneral Exception AbsoluteURL DefaultDataProvider DotNetNuke.Data.SqlDataProvider DotNetNuke
AbsoluteURL:
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:a0b97a1f-c2f6-4b48-b0d9-d12f4dee872a
AssemblyVersion:
PortalId:-1
UserId:-1
TabId:-1
RawUrl:
Referrer:
UserAgent:
ExceptionHash:ll+f0MAEeGT8u7TjnjXsoQ==
Message:There is an error in your SQL at line 24: Must declare the scalar variable "@UserID".
StackTrace:
at DotNetNuke.Modules.Reports.DataSources.DotNetNuke.DotNetNukeDataSource.ExecuteSQLReport()
at DotNetNuke.Modules.Reports.DataSources.SqlDataSourceBase.ExecuteReport(ReportInfo report, PortalModuleBase hostModule, IDictionary`2 inputParameters)
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: MAIN

The errors don't even tell you which module/page caused it, which is frustrating. As I said, I turned off all the indexing options for each module and page, but it still appears several times every few minutes.

DNN: 07.04.02
Reports: 05.07.01

---

Ben Santiago, MCP Certified & A+ Certified
Programmer Analyst
(SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS, Cognos ReportNet)

Mark,

The SQL code listed below is the only way.

UPDATE DesktopModules
    SET SupportedFeatures = 1
    WHERE FriendlyName = 'Reports'

I have found that the Reports Modules completely IGNORES any of the exposed settings available that is support to disable indexing. So if you disable indexing on the module level or the page level, doesn't matter, the Reports Module still indexes. The only option is to turn off the supported feature of indexing for the entire Reports Module installation by using the SQL above. This in essence tells DNN that the Reports module does not support indexing, and so it is ignored.

I figured that since data displayed in the Reports Module is something that is dynamically generated...it really should never be indexed. So I thought it was logical to just shut indexing down for all Report Modules.

---

Ben Santiago, MCP Certified & A+ Certified
Programmer Analyst
(SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS, Cognos ReportNet)