After upgrade to 2025.0.1, most of my Alerts/metrics have a Unit of Connections. Need to fix.

[MichaelBartlett]

After upgrading, most of the metrics ahve a unit of Connections things like Request rate whitch should be Seconds.  I put in a ticket with support.  This is what they sent. 

- I found a related case where a customer found a possible workaround.   "The issue stems froma change where "databases session metrics for postgreSQL databases have been deprecated and replaced by database connections. The upgrade script that handles this transition appears to have incorrectly mapped the vase majority of metrics to the db_connections base_r_id, regardless of their actual metric type."

- Informed that this issue may hit a BUG.

- Provided the workaround to the customer: The r_id field in that table contains an expanded version of the data that is in the base_r_id field. A series of selection statements and update statements to revise each metric type in the base_r_id field carefully.  (Note; they did not send me these actual select statements)

So I would like to fix these, but don't know what they should be set to (I could guess).  Anyone have a list that I could use that I can update, or better yet the SQL to update them?

[DerekLaw · Accepted solution]

Hi @MichaelBartlett,

You've encountered a bug that was recently identified and discussed in this thread,
After 2024.1 -> 2025.0 (+ patch), all my hosts show their metrics in terms of "connections" 

I am sorry for the inconvenience. We do have a fix that will be part of the Monitor 2025.1 release coming in November. 

Hope this helps,

[MichaelBartlett]

Derek,  Thanks.  I found that right as you were posting it.

To be honest I would rather not go through another patch just to fix this error.  If there are other reasons to patch, then I can do it.  But can't I get a list of Metric types and the the corresponding units they should be set to?  A simple summary from the table would be sufficient.

[DerekLaw]

Hi @MichaelBartlett,

I was referring to the next Monitor release, not a patch.

> But can't I get a list of Metric types and the the corresponding units they should be set to?  A simple summary from the table would be sufficient.

Here's a screenshot showing all the ArcGIS Server component metrics,



FYI, the information can also be found in the Monitor help documentation,

ArcGIS Server metrics 

Hope this helps,

[MichaelBartlett]

D'oh.  found a similar (same issue) . https://community.esri.com/t5/arcgis-monitor-questions/after-2024-1-gt-2025-0-patch-all-my-hosts-sho...