export data to MS SQL

Forum Home Forums Runtime Bugs export data to MS SQL

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #4998
    aluy069
    Participant

    I’m exporting data to SQL using ExportToDB following the excamples, and suddenly the Scada Server stop sending data to the SQL.

    I have no clue why, but if I stop start the Scada Server it start to send data again to the SQL

    the log shows me
    2019-02-13 15:40:24 Error export current data to DB MSSQL – RySQL: Invalid object name ‘CnlData’.
    2019-02-13 15:40:25 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2019-02-13 15:40:25 Error export current data to DB MSSQL – RySQL: Invalid object name ‘CnlData’.
    2019-02-13 15:40:25 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2019-02-13 15:40:26 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
    2019-02-13 15:40:26 Error export current data to DB MSSQL – RySQL: Invalid object name ‘CnlData’.
    2019-02-13 15:40:27 Unable to enqueue current data. The maximum size of the queue 100 is exceeded

    #5003
    Mikhail
    Moderator

    Try to find out what was changed in your system. Check SQL scripts in the module configuration.

    #12397
    alexmtzrmz
    Participant

    Hello Mikhail

    I want to implement MSSQL to export the data I am storing in a channel to a database.

    I know there is the module ModDbExport and I have set it up but the data base is not getting filled

    Could you see if my settings are correct?

    https://ibb.co/31Z364f
    https://ibb.co/WxyQ9Fg
    https://ibb.co/Sxk76w6
    https://ibb.co/M9JjFmD
    https://ibb.co/WnWW687

    #12407
    Mikhail
    Moderator

    Hello,

    You should check log files of the module.

    #12409
    alexmtzrmz
    Participant

    https://ibb.co/TTYzhDx

    The log says nothing about it, is there something else I can do?

    #12413
    Mikhail
    Moderator

    You should check the log file of the module. Select Modules in the log filter combo box.

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