[Andi]

Thank you both for your quick and helpful answers. They helped me understand the concept of custom archives much better. I really appreciate your support and the time you took to answer my questions.

[Andi]

Hello Mikhail,

Thank you for your clarification. You were absolutely right – I had mixed up the Event Mask and the Archive Mask. That explains why I was looking at the wrong value.

I then performed some tests with a single channel.

Results:

– If the Archive Mask is empty, the channel is written to the default archives, including the PostgreSQL minute copy (mincopy_historical), and Grafana receives the data.

– If I explicitly select only “Daily archive copy”, the data immediately stops appearing in Grafana because it is no longer written to the PostgreSQL minute archive.

– If I select only “Minute archive copy”, the data is written to PostgreSQL again and Grafana continues normally.

– If I select only “Minute archive” (without “Minute archive copy”), the data is still stored in the internal Rapid SCADA minute archive, but it is no longer copied to PostgreSQL, so Grafana no longer receives it.

These tests helped me understand how the archive selection works.

Thank you very much for your help!

[Andi]

Thank you very much, Manjey73, for your reply and for taking the time to provide the screenshot. It is a great help.

[Andi]

Hello Mikhail,

Thank you for your explanation.

Unfortunately, this is exactly the behaviour that I observe.

For example:

-The channel table shows Archive Mask = 17 (or 81 for a writable channel).
-When I click Select Archives, the popup always opens with:
-Decimal value = 0
-no checkboxes selected.

I have attached screenshots that demonstrate this behaviour.

So it seems that the Archive Mask value is not transferred into the selection dialog.

Is there anything else I should check?

Thank you very much!

https://ibb.co/mCt33BVs

[Andi]

Hello Mikhail,

Thank you very much for your reply.

We finally solved the PostgreSQL connection issue by using a complete connection string, including the TCP port number, instead of only specifying the server name.

At first we thought that the connection was still not working, because we were looking for data in the wrong place. After some further investigation we realized that the archive data had actually already been written successfully into the PostgreSQL database.

So the connection problem is completely solved now.

Thank you again for your support!

[Andi]

Hello Mikhail,

First of all, I would like to sincerely thank you for all the time and effort you have invested in helping me so far.

Your previous explanations regarding the PostgreSQL configuration were extremely helpful and allowed me to successfully complete my Linux installation. I especially appreciate your willingness to even look into my specific project if necessary. That is really exceptional support, and I am very grateful for it.

While continuing my project, I have now come across another question regarding channel archives.

I noticed that every channel contains an Archive Mask and a Select Archives button.

For example, many of my temperature channels show an Archive Mask value of 17 in the channel table. However, when I click the corresponding Select Archives button, the dialog always opens with:

– Decimal value = 0
– all archive bits cleared

The same happens regardless of which channel I select.

Despite this, my minute values are correctly written to PostgreSQL (ModArcPostgreSql) and Grafana displays the historical data without any problems.

Therefore I am trying to understand how these settings actually work.

My questions are:

1. What is the difference between Archive Mask and Select Archives?

2. Which setting actually determines whether a channel is archived by ModArcPostgreSql?

3.Is it normal that the Select Archives dialog always opens with all bits cleared although the channel table shows values such as 17 or 81?

4. Is there a recommended way to define default properties for newly created channels (for example Input Formula CnlVal/10, display format, archive settings and event settings), so that these settings do not have to be entered manually for every new channel?

I would like to build a larger Rapid SCADA project, therefore I am trying to understand the intended workflow before creating hundreds of channels.

Thank you very much again for your excellent support.

Best regards,

Andre

[Andi]

Hello Mikhail,

thank you again for your previous replies.

During the last days I performed some additional tests and I would like to ask one final question because I believe we have narrowed the problem down significantly.

Current situation
PostgreSQL is running correctly on my Synology NAS.
The PostgreSQL server listens on 192.168.1.4:15432.
psql connects successfully.
Rapid SCADA deployment to the Ubuntu server works correctly.
The project configuration is successfully deployed to Linux.

I also tested the two methods you suggested:

1. Setting
<Server>192.168.1.4:15432</Server>

in ScadaInstanceConfig.xml.

2. Using a complete
Server=192.168.1.4;Port=15432;Database=rapidscada;User Id=scada;Password=…

connection string.

Unfortunately, after restarting ScadaServer the PostgreSQL archive modules still try to connect to

192.168.1.4:5432

for all archives (CurCopy, MinCopy, HourCopy, DayCopy and EventsCopy).

Additional observation

I found the Manage Connections dialog in the PostgreSQL archive options.

There I created a dedicated connection using the correct host and port (15432).

However, after deployment I searched the complete Linux installation and found that the port 15432 does not appear anywhere in the deployed configuration.

For example,

grep -R “15432” /opt/scada

returns no results.

The only database-related configuration found on Linux is ScadaInstanceConfig.xml, which currently contains only

<Server>192.168.1.4</Server>

and an empty

<ConnectionString />
My question

Could you please explain where the PostgreSQL connections created by Manage Connections are actually stored?

Are they stored inside the project database?
Are they deployed to the Linux runtime?
Or are they stored only on the Windows engineering computer?

At the moment I cannot determine where the archive modules obtain the connection information that still causes them to use port 5432.

Thank you very much for your help.

[Andi]

Hello,

I found another configuration dialog that may be related.

In the archive properties of ModArcPostgreSql I opened:

Properties -> Database -> Manage Connections

This opens a PostgreSQL Connection Manager where I can create a dedicated connection with Server, Database, Username, Password and also a custom connection string including a different port.

Should I create a dedicated connection here (for example using server 192.168.1.4:15432) and disable “Use default connection”?

Or should ModArcPostgreSql always use the default connection defined in ScadaInstanceConfig.xml?

If needed, I can provide screenshots of the PostgreSQL Connection Manager dialog.

Thank you.

[Andi]

hank you for your reply.

I already tried both suggestions.

1)

ScadaInstanceConfig.xml contains

<Server>192.168.1.4:15432</Server>

I verified the file on the Ubuntu server after deployment.

2)

I also tested using a complete ConnectionString

Server=192.168.1.4;Port=15432;Database=rapidscada;User Id=scada;Password=…

The deployment database connection test succeeds.

However, after restarting ScadaServer, the log still shows

Failed to connect to 192.168.1.4:5432

for CurCopy, MinCopy, HourCopy, DayCopy and EventsCopy.

You mentioned that it is possible to add connections in the archive options.

Could you please explain where these archive options are configured in Rapid SCADA 6.2.2.1?

Thank you very much.

[Author]

Posts