Announcement

Collapse
No announcement yet.

Accuweather stopped working

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    #16
    I changed weather download limit count box from blank to 200 (S89 was showing 62 downloads for the day before I made the change). After a restart, it appears s89 was turned off again (it is showing blank for download counts, and evaluate internet download weather data screen also is showing blanks for accuweather). What else I should check?

    Click image for larger version

Name:	weather.png
Views:	72
Size:	210.4 KB
ID:	1412196
    Click image for larger version

Name:	s89.png
Views:	62
Size:	432.5 KB
ID:	1412197

    Comment


      #17
      Let us isolate between the save and the restore phases. Assuming you are using SQLite, open the file \Data\mcsSprinkers\mcsSprinklers.db, browse tab in DB Browser for SQLite, tblDevices, row for S89, Status column. A value of 2 is ON (expected) and 3 for OFF. Assuming it is 2, then exit mcsSprinkelrs and look again. Start mcsSprinklerse and observe a third time.

      Comment


        #18
        I am using Access, so looked at mcsSprinklers.mbd. In all three instances, S89 row all look the same and looked like it never got updated. Last update was from Aug 6th.

        -----
        tbldevice
        ID DC Location Name Status Value LastChange String
        89 S89 Sprinklers Weather Download Count 2 700 8/6/2020 0:09 ################
        ------

        The ### above is what in the file, not from formatting not able to display the data.

        Comment


          #19
          It looks to me that the Status column has a value of 2 which is ON. This implies that is being set to false after startup. I will add some debug that traces the management of this device.

          Comment


            #20
            The attached has debug every time the download device is modified. Unzip to replace the same file and assure debug is enabled.
            Attached Files

            Comment


              #21
              Thanks, I will try it. Before receiving this version, I also tried turning S89 off, then check S89 in .mdb file. It is still set to 2, last change time stamp also didn't update. Seems it's never saved to database. Is my .mdb file corrupted? (what the #### in string column is about?)

              Comment


                #22
                Don’t know about the ####. Also notice that the status column is blank. It should have an icon and download count. Anything in Messages page that would indicate an exception being encountered?

                Comment


                  #23
                  After restart, status column is blank, until I hit either on (then will show download count) or off (then it will show download is disabled).

                  Here is the message screen after restart:

                  Click image for larger version

Name:	message.png
Views:	53
Size:	19.4 KB
ID:	1412345

                  Comment


                    #24
                    Michael, I emailed you some debug files from the new version you posted.

                    Comment


                      #25
                      This is a repeating message in the debug where the operative information is "Record is deleted."

                      Code:
                      8/19/2020 8:31:05 AM | mcsSprinklers | ExecuteCommand UPDATE tbldevice SET [DC]="S89",[Location]="",[Name]="Weather Download Count",[Status]=2,[Value]=300,[LastChange]=#2020-08-19 08:31:05#,[String]="<table><td><img alt='Weather Download Count' src='/mcsSprinklers/images/weather/30.gif' height='16' width='16'><img alt=' ' src='/mcsSprinklers/images/sensors/blank3.gif'></td><td valign='middle' align='left'><font color='#000000'>3&nbsp;Downloads Today</font></td></table>" WHERE (DC="S89")Record is deleted.
                      These should appear in the Messages page just as the one in your screenshot. S88 is the LastWeatherReceived device
                      Code:
                      8/19/2020 12:00:46 AM | mcsSprinklers | hs InitDevices S88Record is deleted.
                      During initialization, and after the database has been read the status of S89 is OFF/3. I suspect this due to the S88 error and devices after S88 were not read. There was no debug data about S89 during init so that is confirmation of this postulate.

                      I did a google search for "Record is deleted". Most described multi-user environments and in general no specific solution with the first step always being doing a compact and repair. Since you are having database issue then you may want to consider using SQLServer or mySQL as these are more robust databases. A little more setup, but once done the database operation should be stable. There are tools available to migrate data from Access to SQLServer. I did it to mySQL as well, but was a multi-step process.

                      For your immediate issue first do the Compact and Repair. If that does not help then try a copy of mcsSprinklers.mdb from backup or delete tblDevices when mcsSprinklers is not running and then let mcsSprinklers recreate it.


                      Comment


                        #26
                        Michael, I did a compact and repair of mdb file. That seems to have resolved the problem. If it comes back will convert to MySQL. Thank you for all the help.

                        Comment


                          #27
                          Hello all.
                          I am having the same problem but do not have the experience you all have with databases. I have updated the software to latest version made sure s89 clicked to On. I don't know how to compact and repair th mdb file. We have received a lot of rain lately and my lawn is still being watered. THanks for any help.

                          Comment


                            #28
                            If you have been collecting debug data (Other Page at the bottom) then post a recent debug file. Also include \Config\mcsSprinklers.ini that includes the setup. Alternately email to mcsSolutions at CenturyTel dot net.

                            It is unlikely a database issue. Are there any messages in HS log (or Messages page if standalone) showing some form of error related to mcsSprinklers? What is the source for rain sensor on the Weather Setup? If it is an internet provided (e.g. Accuweather) then use the Evaluate Download button on the Weather Setup page to assess what value is being reported for rain. There are stations that do not include rain in their data.

                            Comment

                            Working...
                            X