Realtime DB access and indication

Forum Home Forums Development and Integration Realtime DB access and indication

Tagged: 

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #6675
    AvatarRoland
    Participant

    Hello,

    We are encountered some issues regarding to realtime data acquisition and display using KpMqtt. Our plan is to receive data through an MQTT broker from many sensors at the same time, using postgresql database. Once a new data is received, the ModDBExport.log file receives a new entry:

    Unable to enqueue current data. The maximum size of the queue 100 is exceeded

    Can you help me how to proceed with this?

    My next question is that is it possible somehow to show realtime data on a chart contionously, without refreshing the webpage? Like shifting a window on the actual data from the previous 1 minute? Or it is possible to have such only in 1 minute intervals?

    In general, is there a simply solution how to handle realtime data?

    We are trying to build up a system based on Rapid SCADA to design a mass ventilator system for treatment of group illnesses, specifically to COVID19.

    #6677
    MikhailMikhail
    Moderator

    Hello Roland,

    Unable to enqueue current data. The maximum size of the queue 100 is exceeded

    2 main possible reasons:
    1. Query is too slow comparing with the amount of incoming data
    2. There is a database error.

    You should analyze the log ModDBExport.log written by the DB export module. You could provide the log here.

    #6678
    MikhailMikhail
    Moderator

    show realtime data on a chart contionously, without refreshing the webpage?

    We work on it now. Coming soon ))
    You can contact us by email to get early version for testing.

    We are trying to build up a system based on Rapid SCADA to design a mass ventilator system for treatment of group illnesses, specifically to COVID19.

    Wow

    #6679
    MikhailMikhail
    Moderator

    To get quick results with export data to PostgreSQL, it would be useful to involve our team in the project. We can help to fix the export process, and upgrade the export module if necessary depending on the requirements.

    #6680
    AvatarRoland
    Participant

    Thank for the answers. Please find here the corresponding lines from the ModDBExport.log :

    ——————————————————————————–
    2020-04-02 17:45:13 Start ModDBExport module
    2020-04-02 17:45:13 Error initializing data source PostgreSQL – localhost: Could not load type of field ‘Npgsql.NpgsqlConnection:CertificateSelectionCallback’ (9) due to: Could not resolve type with token 01000058 from typeref (expected class ‘Mono.Security.Protocol.Tls.CertificateSelectionCallback’ in assembly ‘Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756’) assembly:Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756 type:Mono.Security.Protocol.Tls.CertificateSelectionCallback member:(null)

    #6681
    greenfoxxgreenfoxx
    Participant

    Could you provide versions ScadaServer, ModDBExport and PostgresSQL?

    #6682
    AvatarRoland
    Participant

    I am using the scada_5.8.0_mono_en package, that I downloaded from here: https://rapidscada.org/download-all-files/download-rapid-scada/

    I am using Ubuntu 19.10

    #6684
    MikhailMikhail
    Moderator

    Try the following:
    1. Download Mono.Security.dll.zip.
    2. Put the DLL into /opt/scada/ScadaServer/Mod
    3. Restart the Server daemon

    #6685
    AvatarRoland
    Participant

    I downloaded and copied there, then restarted my PC.

    Now I got the following in ModDBExport.log:

    Error connecting to DB PostgreSQL – localhost: Could not load type of field ‘System.Net.Security.SslStream:provider’ (0) due to: Could not resolve type with token 01000030 from typeref (expected class ‘Mono.Security.Interface.MonoTlsProvider’ in assembly ‘Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756’) assembly:Mono.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756 type:Mono.Security.Interface.MonoTlsProvider member:(null)

    #6686
    MikhailMikhail
    Moderator

    Then vice versa, delete /opt/scada/ScadaServer/Mod/Mono.Security.dll and restart the Server daemon.

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