Error at Exporting Data Manually with ModDBExport

[paulinapau]

Hi! So, I’ve been using my company’s client computer, which is integrated with Rapid SCADA. I want to export current and historical data using MySQL in PHPMyAdmin. There’s already a connection before, but I want to add a new connection using a database that running on the company’s client computer. I’m following the documentation for ModDBExport (https://rapidscada.net/doc/content/latest/en/modules/mod-db-export.html) but sadly, I keep coming back to the same error. I’m trying two databases. The first database uses the same syntax as documentation, but the second one uses the latest syntax (https://github.com/RapidScada/scada-v6/blob/master/ScadaServer/OpenModules/ModDbExport.Logic/Scripts/export_mysql.sql). Both have the same output, which is unhandled exception like this one. How can I resolve it?

https://drive.google.com/file/d/1xyc9ccoNs3E8ozEIhrB2-NNyI4T4Id7X/view?usp=drive_link

[Mikhail]

Hi,

Probably, the output channel 1 does not exist. You should add it before sending a command.

Rapid SCADA of version 5 is outdated. I recommend to upgrade the software and project to version 6.

[Mikhail]

Use this article for your module version.

[Mikhail]

Note that the export of current data feature was deprecated in the future versions of the module.

[paulinapau]

I couldn’t change the rapid SCADA version I have now. So, I tried the exact channels available on rapid SCADA. But it still gives the same error as before. And yes, I already using the syntax in the article you gave me.

https://drive.google.com/drive/folders/1hpNNsM6xKIXFO2WhffcOnsR4R4ChhLLX?usp=sharing

I’m trying the input and output channels. By the way, I need to export the input one. Is it still possible?

[Mikhail]

The channels specified in Manual Export window should be created in the Output channels table. Those channels are used to send a command from the module to the Server app.

[paulinapau]

I’m sorry, I don’t get it. Do you mean the Output channels table in the Administrator?

[Mikhail]

Yes.

[paulinapau]

Before I tested it, where I only put the output channel as the channel in the manual export channel. But it’s still get the same error… Could you describe what should I do to get the export success (except changing the Rapid SCADA version)?

here’s the channel output
https://drive.google.com/file/d/1pLOGQL2zLvI1YGpdy9lH25C6gB8p6yOi/view?usp=drive_link

here’s the modules error
https://drive.google.com/file/d/1WlS4bDAUHcre0822DDx-7knYMTYwFMvN/view?usp=drive_link

[Mikhail]

In the screenshots, the number of the output channel is 201 while in the configuration form 631 is specified, which is wrong. It should be 201.

[Mikhail]

Command type of the output channel should be binary.

[Mikhail]

The proper way is upgrading Rapid SCADA to the version 6 and after that solve export questions.

[paulinapau]

Wait, sorry! I put the wrong screenshot, oh my… here’s the correct one!

201 test

[paulinapau]

I think this is the final solution, isn’t it? Okay then… But, is it possible for me to use a cloud server instead?

[Mikhail]

It’s possible to send a command via the Administrator app, but I can’t find information about the required command format, because that version of the driver is too old and outdated.

is it possible for me to use a cloud server instead?

Rapid SCADA works well on a cloud server.

Note. Recently Rapid 5 was removed from the download page. Use the 6th version which is more secure.

[Author]

Posts