Skip to content

PZS_Manager_V126

Latest
Compare
Choose a tag to compare
@Bcubrich Bcubrich released this 18 Mar 21:40
26be59f

I have not updated the source code as it has to be redacted for sensitive information before release, but the .exe contained herein is updated for several aspects. First, we upgraded to the MS SQL server 2017. This required new drivers for querying the database, which had to be coded into python, as well as some changes to the login information, and the IP address of the serves had to be updated as well. This coincided with several other changes that I made. First, I changed the automatic email trigger to trigger in UTC time because the station computers are on MST, and do not observe DST. This causes problems when DST hits. In, UTC there is no such problem, and the emails will go out at 5:30AM MST and 6:30AM DST. I also added a second automatic email to come out 2 hours later because some of the PZSs are not finished running until 5:10AM. This means they miss the 5AM server upload, and won't be available to be queried until sometime around 6:00-6:30 AM (MST). Also, any internet connectivity issues can cause the PZSs to miss the bus to the MS SQL Server at MASOB. The later email that will go out at 7:30MST/8:30DST should catch most of these. Price and Erda sometime have longer lasting issues, but that can't really be controlled for.