Export data module manual exist?

Forum Home Forums Understanding the Software Export data module manual exist?

Tagged: ,

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #334
    AvatarRomiros
    Participant

    Hi, Mikhail.
    How to use Export data module?
    I connect ModDBExport.dll.
    Could you please write an example of SQL query

    #359
    AvatarRomiros
    Participant

    Thank you.

    #370
    AvatarRomiros
    Participant

    Hi, I’ve read manual
    Current data and Events work.
    Archive data dont work. There may be additional options?

    #371
    MikhailMikhail
    Moderator

    Please, write more info.

    #379
    AvatarRomiros
    Participant

    SQL query from tab “Arh Data” (Архивные данные) in the export module dont work
    in Scada minute and hour records are present.
    I use MySQL.

    #384
    MikhailMikhail
    Moderator

    Is there a error in C:\SCADA\ScadaServer\Log\ModDBExport.log ?
    If so, please post here a error message.

    #388
    AvatarRomiros
    Participant

    from log:

    2015-09-01 18:34:05 Ошибка при экспорте текущих данных в БД MySQL – localhost: Duplicate entry ‘2015-09-01 18:32:42-1’ for key ‘PRIMARY’

    from log 2:
    Модуль экспорта данных
    ———————-
    Состояние: норма

    Источники данных
    —————-
    1. MySQL – localhost; состояние: ошибка экспорта; в очереди тек/арх/соб: 5/0/0; экспортировано тек/арх/соб: 18/0/11; пропущено тек/арх/соб: 0/0/0

    Current data is written normally, although the error log. Archives no. Another question – historical data are written into the same table, or need to create another?

    Прошу прощения за мой английский
    Текущие данные пишутся нормально, хотя в логе ошибка. Архивов нет. Еще вопрос – архивные данные пишутся в ту же таблицу или надо создавать отдельную?

    #389
    MikhailMikhail
    Moderator

    I think, it works as expected.
    Export current data error occurs because you send the same data twice.
    Export archive data is executed, for example, when you select Generator in SCADA-Server and send archive data.

    Current and historical data are stored in the same data table in case of using SQL from the manual.

    #1091
    Avatarfahrur
    Participant

    hi mikhail,
    i cant find any documentations using ModDBExport modul, and database / table configuration inside mysql,

    i try to export to my sql heres the log:
    ModDBExport.log :
    ____________

    ——————————————————————————–
    2016-05-06 14:41:37 Start ModDBExport module
    2016-05-06 14:43:20 Module ModDBExport is stopped
    ——————————————————————————–
    ——————————————————————————–
    2016-05-06 14:43:22 Start ModDBExport module
    2016-05-06 14:44:30 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2016-05-06 14:44:30 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2016-05-06 14:44:31 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2016-05-06 14:44:31 Unable to enqueue current data. The maximum size of the queue 100 is exceeded

    ____________

    and

    ModDBExport.txt :
    ____________
    Export Data Module
    ——————
    State: normal

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

    ____________
    thks.

    • This reply was modified 5 years ago by Avatarfahrur.
    #1093
    MikhailMikhail
    Moderator

    Hi,
    The manual is inside the installation package. The file name is Doc\dbexport_en.pdf
    Try using database model and scripts from the manual.

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