Why ModDBExport Module is not publishing realtime or current data?

Forum Home Forums Understanding the Software Why ModDBExport Module is not publishing realtime or current data?

Tagged: ,

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #8431
    Avataribrahim.nezar
    Participant

    Hi,

    I have Modbus devices currently connected to RapidScada server and things seems to work fine where I can receiving data on Input channels and stored in the local db of the server.

    Now we are trying to store the database current records to external MySQL database and for that I enabled the ModDBExport.dll module and set it up. So far I can manually export the data of the Current Data using the blue Up Arrow only.

    How to let this current data auto written to the MySQL db without manual export?

    I’m using the SQL statement from the Current Data template as described in RS documentation.

    The MySQL log file .log and .txt of RS is indicating that the connection is fine to the DB and export is succeeding when performing manual insert.

    What I’m missing here?

    • This topic was modified 1 month, 1 week ago by MikhailMikhail.
    #8438
    MikhailMikhail
    Moderator

    Hi,

    SQL requests defined in the module settings are executed when new data are passed from Communicator to Server app.
    Please provide links to the screenshots of the module settings and copy logs here. I can check them.

    #8447
    Avataribrahim.nezar
    Participant

    Hi,

    I attached to you all the screenshots of the current setup in this link:

    Google Drive Folder Attachments

    Some facts about our setup:
    – I’m just reading input registers from the modbus device, so only input channels are configured, hence not output channels or commands.
    – When I do manual export to the data from the ModDBExport.dll properties, I got the current data dumped to the MySQL db on the cnldata table.
    – I’m using root user on mysql db and the db is living on the same RapidScada machine.

    Appreciate your support

    Best.

    #8454
    MikhailMikhail
    Moderator

    Hi,

    You settings look correct. If you clean up the DB and restart SCADA, what do you get in ModDBExport.log and ModDBExport.txt ?

    #8455
    MikhailMikhail
    Moderator

    If you did not create output channels, all the records you have in MySQL were created automatically, not because of manual export.

    #8457
    Avataribrahim.nezar
    Participant

    Here is the content of the ModDBExport.log

    2021-03-09 16:47:19 Module ModDBExport is stopped
    ——————————————————————————–
    ——————————————————————————–
    2021-03-09 16:47:22 Start ModDBExport module
    2021-03-09 16:49:07 Module ModDBExport is stopped
    ——————————————————————————–
    ——————————————————————————–
    2021-03-09 16:49:10 Start ModDBExport module

    And ModDBExport.txt

    Export Data Module
    ——————
    State: normal

    Data Sources
    ————
    1. MySQL – 127.0.0.1; state: normal; in queue cur/arc/ev: 0/0/0; exported cur/arc/ev: 9/0/0; skipped cur/arc/ev: 0/0/0

    And you are right, without the output channel after I restarted the service, data is dumped to the DB.

    But still not real time input to the db.

    What do you think?

    #8458
    Avataribrahim.nezar
    Participant

    I mean the data is dumped to the db and datetime is the same for all records and never get updated or new data inserted.

    #8473
    MikhailMikhail
    Moderator

    Open your project in Administrator and find the Calculator. Send some values manually. Then check ModDBExport.txt: exported cur/arc/ev: 9/0/0; and check the database. Are there new data?

    #8478
    Avataribrahim.nezar
    Participant

    Open your project in Administrator and find the Calculator.

    Sorry I’m new to RapidScada. I didn’t understand what is a Calculator? How to find it?

    Do you mean generator? If yes, I found it, but I don’t see Channel in the list. Note that I have 9 input channels and 0 output channels in the Configuration Database -> System.

    #8489
    MikhailMikhail
    Moderator

    Sorry, I mean Generator.

    I don’t see Channel in the list

    You can type any channel number.

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