Store the data in the database

Forum Home Forums Understanding the Software Store the data in the database

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #16499
    RenoPowerChen
    Participant

    My equipment suddenly lost power, and then it was discovered that the event files were damaged. Sometimes the channel data.dat files would also get corrupted and become unopenable. In severe cases, the SCADA service couldn’t even start. So I want to store all the data in the database, such as PostgreSQL. Using the ModArcPostgreSQL module, I will store all the archives (both historical and current) in the Pg database. Then I found that the storage was successful, but there were some issues with reading from the interface. I modified the values stored in the database, but the interface did not update synchronously. What’s the reason for this? Do I need to modify the source code for reading data from database?

    • This topic was modified 3 months, 1 week ago by Mikhail.
    #16501
    Mikhail
    Moderator

    Hello,
    Data are read from an archive, when the web interface requests the data. So new data will be displayed when a view page or chart page is refreshed.

    #16508
    RenoPowerChen
    Participant

    No. I have saved the current data as an archive in the database. I have modified the values of the channels in the cur_current table of the database, and refreshed the web interface and restarted all the SCADA services. However, the values still haven’t been updated.

    #16514
    Mikhail
    Moderator

    May be data is read from another current data archive. When the Server service starts it reads data from the first active archive of current data.

    #16523
    RenoPowerChen
    Participant

    Where is the other current data archive?

    #16526
    Mikhail
    Moderator

    Could you make a screenshot of the ScadaServer.txt log file?

    #16561
    RenoPowerChen
    Participant

    ScadaServer.txthere is it

    #16564
    Mikhail
    Moderator

    The 1st active current data archive is Cur. If you deactivate it, current data will be read from the archive, having the code CurCopy.

Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.