ModDbExport Questions

Forum Home Forums Understanding the Software ModDbExport Questions

Viewing 4 posts - 16 through 19 (of 19 total)
  • Author
    Posts
  • #13291
    yangz
    Participant

    Hello:
    I am expoerting channel 101 num (DrvSimulator Sine)into mysql, have configured ModDBExport:
    Active on
    Command Code null
    server=rm-cn-
    wwo39gw0b001ji0o.rwlb.rds.aliyuncs.com;uid=microgrid;pwd=*****;database=testdb
    Current Data transfer option On timer

    set Querries :
    INSERT INTO testdb.cnldata(datetime, cnlnum, val, stat)VALUES (@dateTime,
    @cnlNum, @val, @stat)

    db testdb.cnldata also exist in my Mysql Workbench.

    saved and Ctrl+U,nothing happy in db while channel 101 data is runing.

    anywhere is wrong?

    logs as as follow:

    2023-09-05 09:12:41 Error exporting slice by the query “Query 1”: Fatal error encountered during command execution.
    2023-09-05 09:12:42 Error replicating data:
    System.NullReferenceException: Object reference not set to an instance of an object.
    at Scada.Server.Modules.ModDbExport.Logic.Replication.ArcReplicator.ReplicateData()

    #13298
    Mikhail
    Moderator

    Hello,

    Please provide links to the screenshots of the settings.
    What is the DB Export module version?

    #13304
    yangz
    Participant

    Hello :

    Database Export 6.0.0.1
    ———————–
    The module exports data to external databases. Supports Microsoft SQL Server, Oracle, PostgreSQL and MySQL.

    Webstation6.1.2.0

    file:///C:/Users/zeyang.xu/Desktop/1.jpg
    file:///C:/Users/zeyang.xu/Desktop/2.jpg
    file:///C:/Users/zeyang.xu/Desktop/3.jpg

    now I can see data of channel01 in MySQL Workbench,but timestamp is not the real time,
    set Querries :
    INSERT INTO testdb.cnldata(datetime, cnlnum, val, stat)VALUES (@dateTime,
    @cnlNum, @val101, @stat101)

    in Mysql Workbench timestamp is 2023-09-05 23:47:51
    ‘2023-09-05 23:47:51’, ‘1’, ‘-0.9564856726019837’, ‘1’
    but the time on my pc is 2023-09-06 08:07:01

    #13312
    Mikhail
    Moderator

    Hello,

    Screenshots should be available online. Use image hosting like https://imgbb.com/

Viewing 4 posts - 16 through 19 (of 19 total)
  • You must be logged in to reply to this topic.