Why ModDBExport Module is not publishing realtime or current data?

[ibrahim.nezar]

Hi,

I have Modbus devices currently connected to RapidScada server and things seems to work fine where I can receiving data on Input channels and stored in the local db of the server.

Now we are trying to store the database current records to external MySQL database and for that I enabled the ModDBExport.dll module and set it up. So far I can manually export the data of the Current Data using the blue Up Arrow only.

How to let this current data auto written to the MySQL db without manual export?

I’m using the SQL statement from the Current Data template as described in RS documentation.

The MySQL log file .log and .txt of RS is indicating that the connection is fine to the DB and export is succeeding when performing manual insert.

What I’m missing here?

• This topic was modified 3 years, 1 month ago by Mikhail.

[Mikhail]

Hi,

SQL requests defined in the module settings are executed when new data are passed from Communicator to Server app.
Please provide links to the screenshots of the module settings and copy logs here. I can check them.

[ibrahim.nezar]

Hi,

I attached to you all the screenshots of the current setup in this link:

Google Drive Folder Attachments

Some facts about our setup:
– I’m just reading input registers from the modbus device, so only input channels are configured, hence not output channels or commands.
– When I do manual export to the data from the ModDBExport.dll properties, I got the current data dumped to the MySQL db on the cnldata table.
– I’m using root user on mysql db and the db is living on the same RapidScada machine.

Appreciate your support

Best.

• This reply was modified 3 years, 1 month ago by ibrahim.nezar.
• This reply was modified 3 years, 1 month ago by ibrahim.nezar.
• This reply was modified 3 years, 1 month ago by ibrahim.nezar.

[Mikhail]

Hi,

You settings look correct. If you clean up the DB and restart SCADA, what do you get in ModDBExport.log and ModDBExport.txt ?

[Mikhail]

If you did not create output channels, all the records you have in MySQL were created automatically, not because of manual export.

[ibrahim.nezar]

Here is the content of the ModDBExport.log

2021-03-09 16:47:19 Module ModDBExport is stopped
——————————————————————————–
——————————————————————————–
2021-03-09 16:47:22 Start ModDBExport module
2021-03-09 16:49:07 Module ModDBExport is stopped
——————————————————————————–
——————————————————————————–
2021-03-09 16:49:10 Start ModDBExport module

And ModDBExport.txt

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

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

And you are right, without the output channel after I restarted the service, data is dumped to the DB.

But still not real time input to the db.

What do you think?

[ibrahim.nezar]

I mean the data is dumped to the db and datetime is the same for all records and never get updated or new data inserted.

[Mikhail]

Open your project in Administrator and find the Calculator. Send some values manually. Then check ModDBExport.txt: exported cur/arc/ev: 9/0/0; and check the database. Are there new data?

[ibrahim.nezar]

Open your project in Administrator and find the Calculator.

Sorry I’m new to RapidScada. I didn’t understand what is a Calculator? How to find it?

Do you mean generator? If yes, I found it, but I don’t see Channel in the list. Note that I have 9 input channels and 0 output channels in the Configuration Database -> System.

[Mikhail]

Sorry, I mean Generator.

I don’t see Channel in the list

You can type any channel number.

[Author]

Posts