Wednesday, September 08, 2010
Dnaxp.net Forums
Minimize

Dnaxp.net Forums

The Dnaxp.net Community is proud to present our support forums. The forums enabled us to provide more benefits and better service to our valuable community.

  
Forum
Minimize
 
ForumForumGeneralGeneralBugs & ProblemsBugs & ProblemsSudden General ExceptionsSudden General Exceptions
Previous Previous
 
Next Next
New Post
 2/26/2008 12:47 PM
 
 Modified By dcorallo  on 2/27/2008 4:43:11 AM

Hello,

We are using ReportGrid 01.09.09. on DNN 4.7 .

We think it has something to do with ReportGrid because there is no other 3rd party installed on the DNN installation, and we haven't seen these kinds of errors in any of our other 4.7+ DNN installations. There is nothing more on the website than pages, reportgrid instances and one or two text modules.

We tried reinstalling DNN and tried DNN 4.8 , to no avail.

We cannot anticipate when excactly the errors occur, but when it fails, it's the whole website that has the problem, including visitors to the site on another computer.


This is an example of how we have the instances of ReportGrid set:
(we have about 15 ReportGrid instances on various pages on this website all executing various queries)


Database connectionstring: <add name="stringforreportgrid" connectionString="Server=.\MYSERVER;Database=mydatabase;uid=mylogin;pwd=mypassword;" providerName="System.Data.SqlClient" />
Query: EXECUTE dtx_InsertObject @name
Parameter: @name name FreeText True True

The stored procedure inserts something and returns "it worked" or "it didn't" to the reportgrid.

We have made several pages including edit/delete/insert and select pages, which are one for one just reportgrids who execute stored procedures with a number of parameters.

Everything works fine until suddenly we get these errors, then after a few refreshes or a couple of minutes everything works fine again.


The following errors are generated (not ordered) and all pages we try to go to, regardless of the logged in user.

 

DotNetNuke.Services.Exceptions.ModuleLoadException: hashControls must contain the control to add Parameter name: hashControls[lblFilterkitchenid30_376] ---> System.ArgumentNullException: hashControls must contain the control to add Parameter name: hashControls[lblFilterkitchenid30_376] at Dna2.Modules.ReportGrid.ControlInjector.InjectControls(Panel& pnlContent, String html, Hashtable hashControls) at Dna2.Modules.ReportGrid.ParametersController.InjectHTML(ReportGridInfo objReport, Page page, PlaceHolder ph, QueryVariables vars, String strRefreshText, Boolean bCompact) at Dna2.Modules.ReportGrid.ViewReportGrid.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace

 

New Post
 2/26/2008 2:19 PM
 
 Modified By Nosdrovni  on 2/26/2008 8:20:02 AM

We had the error again just now and this is the first error we saw:

 

Report Grid not available

DotNetNuke.Services.Exceptions.ModuleLoadException: hashControls must contain the control to add Parameter name: hashControls[lblFilterkitchenid30_376] ---> System.ArgumentNullException: hashControls must contain the control to add Parameter name: hashControls[lblFilterkitchenid30_376] at Dna2.Modules.ReportGrid.ControlInjector.InjectControls(Panel& pnlContent, String html, Hashtable hashControls) at Dna2.Modules.ReportGrid.ParametersController.InjectHTML(ReportGridInfo objReport, Page page, PlaceHolder ph, QueryVariables vars, String strRefreshText, Boolean bCompact) at Dna2.Modules.ReportGrid.ViewReportGrid.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

New Post
 2/26/2008 2:48 PM
 

Hi! It's impossible that ReportGrid could kill your portal. It's on other hand possible to have exceptions and/or timeout on pages whenever you use "heavy" stored procedure. About errors 1,2,3,4,5, only error 1 and 5 refers to ReportGrid and they appear to be timeout errors.

It's possible your stored procedures last a very long time???? Do you have network errors and/or downtime on your server?!?

Thanks for all the additional information you could provide,
Kind Regards,
D.

New Post
 2/26/2008 3:04 PM
 

The stored procedures all take less than a tenth of a second to run, they aren't heavy at all. (the results are only 10-20 rows max)

We have noticed other things happening as well;

- reportgrid results from one reportgrid instance ending up in the result of another reportgrid instance

- results from a dropdownlist query ending up in another dropdownlist of the same reportgrid

It seems Reportgrid is having trouble distincting one instance from another, maybe the results get cached and get mixed up.

If it would be useful, I could set up an account so you see it for yourself.

New Post
 2/26/2008 5:35 PM
 

Hi! I will appreciate to see the problem myself. It's not that we don't trust you, it's only that this module is installed in hundreds websites and we never observed this issue. Please send the necessary info's to "support at dnaxp.net" and we'll investigate the problem (please include an admin account, we want to check also the event viewer).
Kind Regards,
D.

New Post
 2/27/2008 9:22 AM
 

Thank you for your response.

I have sent an e-mail to the support address with details.

Please respond here if you haven't received the e-mail.

New Post
 2/27/2008 9:47 AM
 

I've got your email! I'll be checking your website today!
Kind Regards,
D.

New Post
 3/1/2008 8:20 AM
 

So any luck in finding the culprit?

Maybe you can suggest a workaround so we know what we should or shouldn't do while using ReportGrid.

Although it really didn't seem like we were doing anything wrong, especially since it was working "sometimes" :S

New Post
 3/3/2008 11:10 AM
 

Hi! Sorry for being late but I'm still doing tests. We really never used our module as a forms builder and we want to be sure before release a patch.
It should take probably a few more days.
Kind Regards,
D.

New Post
 3/6/2008 2:14 PM
 

Dear dcorallo,

Sorry for bothering you again but we would like to know when you think you'd might have solution ready for this problem since one of our customers is waiting for us. If you think this will take a more then a week we should use this time to rebuild the website with another component or something, since we have a strict deadline. Also, if you would have a temporary fix or a workaround, please let us know :)

thank you very much

Dennis

Previous Previous
 
Next Next
ForumForumGeneralGeneralBugs & ProblemsBugs & ProblemsSudden General ExceptionsSudden General Exceptions

  
Forum Policy
Minimize


These Discussion Forums are dedicated to the discussion of the Dnaxp.Net Web Application Framework.

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

1. No Advertising. This includes promotion of commercial products and non-commercial products which are noectly related to the DotNetNuke Web Application Framework
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.

  
Adsense
Minimize
  
 
Minimize

Full compatibility of ReportGrid & ReportChart with all releases of DNN from 4.0.2 to 5.4.4

 

The help desk support is always available to help you! Contact us!

Only $64.95 Offer expires on 12/31/2010

 


  

Snowcovered modules
Minimize
  
Privacy Statement  |  Terms Of Use
Copyright 2006-2008 by Dnaxp.Net