Products

Solutions

Resources

Partners

Community

Blog

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsUnprompted Errors from Reports in Event ViewerUnprompted Errors from Reports in Event Viewer
Previous
 
Next
New Post
7/28/2015 10:33 AM
 
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 @[email protected]_EID,
@[email protected]_OID,
@[email protected]_DEN,
@[email protected]_Z,
@[email protected]_SD,
@[email protected]_ET,
@[email protected]
 
New Post
7/28/2015 10:57 AM
 
SPRoc received.

I will try to investigate it in the next couple of days (if time permitted).

XCESS expertise center b.v.
Regards,
Ernst Peter
LinkedIn Profile Ernst Peter Tamminga


XCESS: DNN/Evoq specialist, zie www.xcess.nl

Events 7.0.1 - Released
Reports 6.1.0 - Released
 
New Post
11/24/2015 11:06 AM
 
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)
 
New Post
12/7/2015 2:36 PM
 

Ben, 

Ernst Peter and I lost our momentum on this topic. But I just sent him an email because this issue has boiled to the top again for me. Did you find a resolution?

I'll post it here if we find a solution. - Mark

 
New Post
12/7/2015 3:20 PM
 

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)
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsUnprompted Errors from Reports in Event ViewerUnprompted Errors from Reports in Event Viewer


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out