Data Exporting

[Mikhail]

If the module is active, check it log files.

[KeanoC]

Here are my logs after making the connection but i dont seem to be getting any data automatically exporting to my db.

2023-11-28 08:11:09 [B100][B100$][ACT] Server 6.1.1.1 started
2023-11-28 08:11:09 [B100][B100$][ACT] Storage FileStorage 6.1.0.0 loaded from file C:\Program Files\SCADA\ScadaServer\FileStorage.dll
2023-11-28 08:11:09 [B100][B100$][ACT] Start logic processing
2023-11-28 08:11:09 [B100][B100$][ACT] The configuration database has been read successfully
2023-11-28 08:11:09 [B100][B100$][INF] Number of active channels for archiving: 335
2023-11-28 08:11:09 [B100][B100$][INF] Number of active channels for sending commands: 0
2023-11-28 08:11:09 [B100][B100$][ACT] Compile the source code of scripts and formulas
2023-11-28 08:11:09 [B100][B100$][ACT] Added the following dependencies:
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\netstandard.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.ComponentModel.Primitives.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Console.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Diagnostics.Process.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Linq.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Private.CoreLib.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Runtime.dll
C:\Program Files\SCADA\ScadaServer\ScadaCommon.dll
C:\Program Files\SCADA\ScadaServer\ScadaServerEngine.dll
2023-11-28 08:11:10 [B100][B100$][ACT] The source code of scripts and formulas has been compiled successfully
2023-11-28 08:11:10 [B100][B100$][ACT] Module ModArcBasic 6.1.0.0 loaded from file C:\Program Files\SCADA\ScadaServer\Mod\ModArcBasic.Logic.dll
2023-11-28 08:11:10 [B100][B100$][ACT] Module ModArcPostgreSql 6.1.1.1 loaded from file C:\Program Files\SCADA\ScadaServer\Mod\ModArcPostgreSql.Logic.dll
2023-11-28 08:11:10 [B100][B100$][ACT] Module ModDbExport 6.0.0.1 loaded from file C:\Program Files\SCADA\ScadaServer\Mod\ModDbExport.Logic.dll
2023-11-28 08:11:10 [B100][B100$][ACT] Archive Cur initialized successfully
2023-11-28 08:11:10 [B100][B100$][ACT] Archive Min initialized successfully
2023-11-28 08:11:10 [B100][B100$][ACT] Archive Hour initialized successfully
2023-11-28 08:11:10 [B100][B100$][ACT] Archive Events initialized successfully
2023-11-28 08:11:10 [B100][B100$][ACT] Start listener on port 10000
2023-11-28 08:11:10 [B100][B100$][INF] Archive in DAT format: C:\Program Files\SCADA\Archive
2023-11-28 08:11:10 [B100][B100$][INF] Archive copy in DAT format: C:\Program Files\SCADA\ArchiveCopy
2023-11-28 08:11:10 [B100][B100$][ACT] Delete outdated data from the Min archive older than 28/11/2022
2023-11-28 08:11:10 [B100][B100$][ACT] Delete outdated data from the Hour archive older than 28/11/2022
2023-11-28 08:11:10 [B100][B100$][ACT] Delete outdated data from the Events archive older than 28/11/2022
2023-11-28 08:11:54 [B100][B100$][ACT] Stop listener
2023-11-28 08:11:54 [B100][B100$][ACT] Listener is stopped
2023-11-28 08:11:54 [B100][B100$][ACT] Logic processing is stopped
2023-11-28 08:11:54 [B100][B100$][ACT] Server is stopped
——————————————————————————–
——————————————————————————–
2023-11-28 08:11:57 [B100][B100$][ACT] Server 6.1.1.1 started
2023-11-28 08:11:57 [B100][B100$][ACT] Storage FileStorage 6.1.0.0 loaded from file C:\Program Files\SCADA\ScadaServer\FileStorage.dll
2023-11-28 08:11:57 [B100][B100$][ACT] Start logic processing
2023-11-28 08:11:57 [B100][B100$][ACT] The configuration database has been read successfully
2023-11-28 08:11:57 [B100][B100$][INF] Number of active channels for archiving: 335
2023-11-28 08:11:57 [B100][B100$][INF] Number of active channels for sending commands: 0
2023-11-28 08:11:57 [B100][B100$][ACT] Compile the source code of scripts and formulas
2023-11-28 08:11:57 [B100][B100$][ACT] Added the following dependencies:
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\netstandard.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.ComponentModel.Primitives.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Console.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Diagnostics.Process.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Linq.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Private.CoreLib.dll
C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.25\System.Runtime.dll
C:\Program Files\SCADA\ScadaServer\ScadaCommon.dll
C:\Program Files\SCADA\ScadaServer\ScadaServerEngine.dll
2023-11-28 08:11:58 [B100][B100$][ACT] The source code of scripts and formulas has been compiled successfully
2023-11-28 08:11:58 [B100][B100$][ACT] Module ModArcBasic 6.1.0.0 loaded from file C:\Program Files\SCADA\ScadaServer\Mod\ModArcBasic.Logic.dll
2023-11-28 08:11:58 [B100][B100$][ACT] Module ModArcPostgreSql 6.1.1.1 loaded from file C:\Program Files\SCADA\ScadaServer\Mod\ModArcPostgreSql.Logic.dll
2023-11-28 08:11:58 [B100][B100$][ACT] Module ModDbExport 6.0.0.1 loaded from file C:\Program Files\SCADA\ScadaServer\Mod\ModDbExport.Logic.dll
2023-11-28 08:11:58 [B100][B100$][ACT] Archive Cur initialized successfully
2023-11-28 08:11:58 [B100][B100$][ACT] Archive Min initialized successfully
2023-11-28 08:11:58 [B100][B100$][ACT] Archive Hour initialized successfully
2023-11-28 08:11:58 [B100][B100$][ACT] Archive Events initialized successfully
2023-11-28 08:11:58 [B100][B100$][ACT] Start listener on port 10000
2023-11-28 08:11:58 [B100][B100$][INF] Archive in DAT format: C:\Program Files\SCADA\Archive
2023-11-28 08:11:58 [B100][B100$][INF] Archive copy in DAT format: C:\Program Files\SCADA\ArchiveCopy
2023-11-28 08:11:58 [B100][B100$][ACT] Delete outdated data from the Min archive older than 28/11/2022
2023-11-28 08:11:58 [B100][B100$][ACT] Delete outdated data from the Hour archive older than 28/11/2022
2023-11-28 08:11:58 [B100][B100$][ACT] Delete outdated data from the Events archive older than 28/11/2022
2023-11-28 08:12:01 [B100][B100$][ACT] Session with ID -275528625156651192 created
2023-11-28 08:12:01 [B100][B100$][ACT] Client 127.0.0.1 connected
2023-11-28 08:12:01 [B100][B100$][ACT] User ScadaComm is successfully authenticated
2023-11-28 08:12:03 [B100][B100$][ACT] Client 127.0.0.1 disconnected
2023-11-28 08:12:04 [B100][B100$][ACT] Session with ID -2293832663858227796 created
2023-11-28 08:12:04 [B100][B100$][ACT] Client 127.0.0.1 connected
2023-11-28 08:12:04 [B100][B100$][ACT] User ScadaComm is successfully authenticated
2023-11-28 08:13:53 [B100][B100$][ACT] Created event with ID 7306392348303855930 and channel 304
2023-11-28 08:53:24 [B100][B100$][ACT] Created event with ID 7306402531278643967 and channel 304

[Mikhail]

The above is the content of ScadaServer.log
Log files of the module are ModDbExport*.* in the same directory.

• This reply was modified 1 year, 9 months ago by Mikhail.

[KeanoC]

Here is a screenshot I took of what I assume your talking about. My export logs dont seem to be apearing

[KeanoC]

And yes my module is active

[KeanoC]

Found the logs this is how they look.

ModDbExport_002.log

ModDbExport_002.log.bak

ModDbExport_003.log

ModDbExport_003.log.bak

ModDbExport.log

[Mikhail]

You could start with providing correct MySQL connection settings.
Also check ModDbExport*.txt files.

[KeanoC]

The 003 is from the mysql which im no longer using but the 002 has the correct string

[Mikhail]

In the module options disable Archive Replication for testing. Then check the log file.

[Tecneira_monitoring]

Hi there Mikhail,
I’m trying to export some channels values to a MySQL DB. By now I’ve already created a query in DBExport module and could export some of my project channels. The problem is that when I want to add new channels to query (channels 100000 to 100015 for example) this ones are not exported by Rapid Scada to my database.

Here is an example of the query:
Query

And here a print of what is collected in the database:
MySQL_DB

Thank you in advance

[Mikhail]

Hi,
I suggest to create a separate trigger that exports only the channels that are not exported. It would be useful to create a new table in the DB for them. It can help to realize the cause of the problem.

[Author]

Posts