[yangz]

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

[yangz]

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()

[Author]

Posts