export event data to postgres

[Ame5577]

I am trying to export data to postgres, every time there is a change of value in the data must save in the DB, unfortunately so far I am not being able to get it, in the link is the document detailing the steps I’m following.

https://www.filemail.com/d/bfkvbttrhtabywq

Thank you for your time.

[Mikhail]

Export DB module writes information to log files located in C:\SCADA\ScadaServer\Log
Check log files for errors.
Please publish screenshots as JPEG or PNG, not PDF.

[Ame5577]

Hi, these are the data, thank you for your time.
these are the images

https://tmpsee.com/v/2dnb7uvbc6

Regards.

[Mikhail]

Hi,
MdDbExport_xxx.log that connection to database cannot be established. Check connection settings. The full error message is not visible on the screenshot.

[Ame5577]

hello, thanks for replying, the strangest thing is that I tried the connection string data separately to connect to another program and it works fine and does not give error, attached I am sending all the log folder to see if you can help me find the cause, I forgot to mention that I am testing rapidscada in a vmware virtual machine do you think that is a problem?.

https://www.filemail.com/d/qfqklqaqlwlloqn

thanks for your time.
Regards.

• This reply was modified 3 years ago by Ame5577.
• This reply was modified 3 years ago by Ame5577.

[Mikhail]

Hello,
Please provide log file without download. Publish it on Google Drive or copy error here.

I forgot to mention that I am testing rapidscada in a vmware virtual machine do you think that is a problem?

VMware is OK.

[Ame5577]

Hello, this is the link in google Drive.

https://drive.google.com/file/d/1u8qhsVMHg5J_7_qwdb3OisOaUM8GgjTt/view?usp=sharing

Thank you.

Best regards

[Ame5577]

sorry for the error this link does not ask for a password.

https://drive.google.com/drive/folders/16L3Pk6620ue-Q2dF3AIbexSxYIxZiQCQ?usp=sharing

Best regards.

[Mikhail]

Hello,

ModDbExport_001.txt says that only events are exported, because the queues for current and archive data are not in use. You should check the module configuration.

[Ame5577]

Hi, sorry for the delay in replying, I made a video about the Modules configuration “Screen Recording (13-10-2022 16-54-01)”, it is in the same shared folder as the configuration files, as I told you I tried those connection data with dbeaver and I had no problems to connect, maybe something wrong in my modules configuration?

https://drive.google.com/drive/folders/16L3Pk6620ue-Q2dF3AIbexSxYIxZiQCQ?usp=sharing

Thank you.

[Mikhail]

Hi,
In the module configuration you should add triggers for data export.

[Author]

Posts