The problem about ModDBExport module

Forum Home Forums Understanding the Software The problem about ModDBExport module

Tagged: 

This topic contains 8 replies, has 3 voices, and was last updated by Mikhail Mikhail 2 years ago.

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #2247
    Avatar
    Elton
    Participant

    hello sir
    I have used ModDbExport module,but i want to change cycle about export to database.
    How can i do?
    Thank you sir

    #2248
    Mikhail
    Mikhail
    Moderator

    Hello,
    Please provide the detailed description of the required changes.

    #2255
    Avatar
    Elton
    Participant

    I want export to postgresql database by using ModDbExport module,and it is success.
    But the data is constantly exported to postgresql database .so I want to be able to control the export period,or other methods avoid continuous export. I’m not sure if I have a clear description .

    #2256
    Mikhail
    Mikhail
    Moderator

    The script to export data executes when the data are received by SCADA-Server. You can create a stored procedure (function in Pg) that filters data according to your needs and use this procedure in DB Export Module.

    #2529
    Avatar
    Elton
    Participant

    How do I set the data to be received by the Scada-Server ?

    #2530
    Avatar
    Elton
    Participant

    I’ve already used ModDBExport module,but the data is not imported into the database(postgresql) . Before that, I had been configured as a document .
    DROP TABLE IF EXISTS cnldata;

    — Create channel data table
    CREATE TABLE cnldata (
    datetime timestamp NOT NULL,
    cnlnum integer NOT NULL,
    val double precision NOT NULL,
    stat integer NOT NULL,
    PRIMARY KEY (datetime, cnlnum)
    );

    CREATE INDEX ON cnldata (cnlnum);

    The above runs at postgres ,and The insert statement runs in current data in the ModDBExport attribute

    #2535
    Mikhail
    Mikhail
    Moderator

    Information exported when passed by Communicator to Server.

    Check the logs:
    C:\SCADA\ScadaServer\Log\ModRapidGate.log
    C:\SCADA\ScadaServer\Log\ModRapidGate.txt

    #2642
    Avatar
    zhaochengshen
    Participant

    hi Mikhail:
    I have a issue when i use ModDBExport module to export data.Only events data can be export. the current data and archive data can’t export. I have create table “cnldata” and “events”. Why does it happen? How can solve it?

    here is the detailed log:

    ModDBExport.txt

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

    Data Sources
    ————
    1. MSSQL – (local); state: normal; in queue cur/arc/ev: 100/0/0; exported cur/arc/ev: 0/0/24; skipped cur/arc/ev: 150/0/0

    ModDBExport.log

    2017-10-08 00:55:13 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:18 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:23 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:28 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:29 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:33 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:38 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:43 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:48 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:53 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:55:58 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:03 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:08 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:13 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:18 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:23 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:28 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:29 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:33 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:38 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:43 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:48 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:53 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 00:56:56 Module ModDBExport is stopped
    ——————————————————————————–
    ——————————————————————————–
    2017-10-08 00:56:56 Start ModDBExport module
    2017-10-08 01:04:38 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:04:43 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:04:48 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:04:53 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:04:58 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:05:03 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:05:08 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:05:13 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:05:18 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2017-10-08 01:05:23 Unable to enqueue current data. The maximum size of the queue 100 is exceeded

    #2644
    Mikhail
    Mikhail
    Moderator
Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.