Forum Home › Forums › Understanding the Software › The problem about ModDBExport module
Tagged: ModDBExport
- This topic has 8 replies, 3 voices, and was last updated 6 years, 5 months ago by Mikhail.
-
AuthorPosts
-
June 7, 2017 at 5:01 am #2247EltonParticipant
hello sir
I have used ModDbExport module,but i want to change cycle about export to database.
How can i do?
Thank you sirJune 7, 2017 at 5:29 am #2248MikhailModeratorHello,
Please provide the detailed description of the required changes.June 8, 2017 at 7:18 am #2255EltonParticipantI want export to postgresql database by using ModDbExport module,and it is success.
But the data is constantly exported to postgresql database .so I want to be able to control the export period,or other methods avoid continuous export. I’m not sure if I have a clear description .June 8, 2017 at 11:56 am #2256MikhailModeratorThe script to export data executes when the data are received by SCADA-Server. You can create a stored procedure (function in Pg) that filters data according to your needs and use this procedure in DB Export Module.
August 30, 2017 at 3:43 am #2529EltonParticipantHow do I set the data to be received by the Scada-Server ?
August 30, 2017 at 7:03 am #2530EltonParticipantI’ve already used ModDBExport module,but the data is not imported into the database(postgresql) . Before that, I had been configured as a document .
DROP TABLE IF EXISTS cnldata;— Create channel data table
CREATE TABLE cnldata (
datetime timestamp NOT NULL,
cnlnum integer NOT NULL,
val double precision NOT NULL,
stat integer NOT NULL,
PRIMARY KEY (datetime, cnlnum)
);CREATE INDEX ON cnldata (cnlnum);
The above runs at postgres ,and The insert statement runs in current data in the ModDBExport attribute
August 30, 2017 at 2:45 pm #2535MikhailModeratorInformation exported when passed by Communicator to Server.
Check the logs:
C:\SCADA\ScadaServer\Log\ModRapidGate.log
C:\SCADA\ScadaServer\Log\ModRapidGate.txtOctober 7, 2017 at 5:09 pm #2642zhaochengshenParticipanthi Mikhail:
I have a issue when i use ModDBExport module to export data.Only events data can be export. the current data and archive data can’t export. I have create table “cnldata” and “events”. Why does it happen? How can solve it?here is the detailed log:
ModDBExport.txt
Export Data Module
——————
State: normalData Sources
————
1. MSSQL – (local); state: normal; in queue cur/arc/ev: 100/0/0; exported cur/arc/ev: 0/0/24; skipped cur/arc/ev: 150/0/0ModDBExport.log
2017-10-08 00:55:13 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:18 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:23 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:28 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:29 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:33 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:38 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:43 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:48 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:53 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:55:58 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:03 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:08 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:13 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:18 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:23 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:28 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:29 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:33 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:38 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:43 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:48 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:53 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 00:56:56 Module ModDBExport is stopped
——————————————————————————–
——————————————————————————–
2017-10-08 00:56:56 Start ModDBExport module
2017-10-08 01:04:38 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:04:43 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:04:48 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:04:53 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:04:58 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:05:03 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:05:08 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:05:13 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:05:18 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2017-10-08 01:05:23 Unable to enqueue current data. The maximum size of the queue 100 is exceededOctober 9, 2017 at 6:19 am #2644MikhailModerator -
AuthorPosts
- You must be logged in to reply to this topic.