RFX Chart problem?

Post by **DJF3** » Mon Jan 05, 2009 7:47 pm

Hi, I am running Paul's RFX Chart (1.1.0.7) and since January 1st I get this error message on all pages:

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Server Error in '/' Application.
Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[IndexOutOfRangeException: Index was outside the bounds of the array.]
UtilityH.GetValues(String sql) +911
UtilityH.Page_Load(Object sender, EventArgs e) +4450
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3750<hr height="1" noshade id="quote"></blockquote id="quote">

URL: http://<hsIPaddress>:<port>/RFXCharts/UtilityH.aspx

Does this have anything to do with the year 2009 by any chance?

Thanks
DJ

Post by **TANE** » Mon Jan 05, 2009 10:07 pm

@Dj,
I can access the UtilityH.aspx no problem here.

Post by **Herbus** » Mon Jan 05, 2009 10:39 pm

No problem here. Can access all charts as usual.

Post by **Rene** » Tue Jan 06, 2009 10:16 am

I get this error at regular intervals for a couple of months now. Most of the time the errors disappears after a few minutes. This is the error message I get:

Index was outside the bounds of the array.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[IndexOutOfRangeException: Index was outside the bounds of the array.]
Enviro1H.GetValues(String sql, String strType) +959
Enviro1H.Page_Load(Object sender, EventArgs e) +5045
System.Web.UI.Control.OnLoad(EventArgs e) +80
System.Web.UI.Control.LoadRecursive() +49
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3750

Rene.

Post by **DJF3** » Wed Jan 07, 2009 12:54 pm

Rene,

Think I have found the problem.
<ul>
<li>HomeSeer I noticed that the logging had a US date format.</li>
<li>The OS (Win2k) was set to the Dutch format dd-mm-yy</li>
</ul>
Weird! On the HS board I found this article that describes a problem with the Settings_Regional.xml file.
http://board.homeseer.com/showthread.php?t=133216
Next step: shut down HomeSeer, rename this file, start HomeSeer. Now the dateformat is OK.

Then I looked into my Databases (RFXCOM + my own DB) and found that there was a problem with the dates:
<ul>
<li>System writes US format: 10-01-08 (Oct-1)</li>
<li>DB wants EMEA format: 01-10-08 </li>
<li>Result: Oct-1 is recorded in the DB as Jan-10 ('10-01-08')</li>
</ul>
After the 12th of each month the DB knows that 10-13 has to be recorded as 13-10 so that caused no problems.

Last night I went through a 100.000 records and had to replace dates for the first 12 days of each month (starting July ??)
Did find a way to do it faster than manual, but it still took about 2hrs.

Now the charts seem to work a lot better!

Post by **Rene** » Wed Jan 07, 2009 2:53 pm

Yesterday the problem occured again. After a couple of minutes, just like the other times, it worked again without me doing anything. Strange, but my problem seems to be a different problem than the one you are experiencing.

Rene.

Post by **b_weijenberg** » Wed Jan 07, 2009 4:37 pm

please hou dit forum in het Nederlands. Voor RFX Charts kan je zelfs ook beter het HS forum gebruiken als centraal meldpunt.
http://board.homeseer.com/showthread.php?t=128902

bvd Bert

Post by **DJF3** » Thu Jan 08, 2009 2:31 pm

Dank voor de link!