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 ForumsReportsReportsReports Using SQL Tokens Crash On Search IndexingReports Using SQL Tokens Crash On Search Indexing
Previous
 
Next
New Post
1/29/2015 10:49 PM
 

I have the following setup:

Report: v5.5.0
DNN: 6.2.9

I have several Reports modules throughout my site for customers to retrieve information. Many of them are based on using the @UserID SQL Token. The modules work great, but the problem I am finding is that every time the system kicks off it's Search Indexing routine, every single Reports module using those SQL based tokens crash, leaving a error in the LOG. How can I stop these errors from being generated? Is there a way I can exclude these modules from being indexed, they really should be excluded as the data changes based on which user is viewing it.

-Ben


Ben Santiago, MCP Certified & A+ Certified
Programmer Analyst
(SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS, Cognos ReportNet)
 
New Post
1/30/2015 4:29 AM
 
you should exclude the module from search, disable the flag in Host > Extensions

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/30/2015 8:13 AM
 

I am assuming the only way to do that is to manually update the records in the DesktopModules table using SQL?

Would the following statement be correct?

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

- Ben


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:44 PM
 
Ben, were you able to stop the error reporting on your reports modules? And if so, how? Thanks.
 
New Post
12/7/2015 3:17 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 ForumsReportsReportsReports Using SQL Tokens Crash On Search IndexingReports Using SQL Tokens Crash On Search Indexing


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.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out