Bug ID Number |
BUG-000175372 |
Submitted | March 26, 2025 |
Last Modified | August 27, 2025 |
Applies to | ArcGIS Monitor |
Version found | 2024.1.1 |
Operating System | Windows OS |
Operating System Version | N/A |
Version Fixed | Server 2025.0 |
Status | Fixed
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
|
Workaround
- Shutdown ArcGIS Monitor.
- Take snapshot of ArcGIS Monitor Server.
- Create a database backup for good measure.
- Generate CREATE scripts of views that use metrics data (alerts_view, metrics_data_view, metrics_view).
- To generate scripts you wouldÂ
- log into pgAdmin4.
- Expand the Monitor Database.
- Expand Schemas.
- Expand views.
- Right click the desired view (alerts_view, metrics_data_view, metrics_view).
- Copy the script from the new window to Notepad or Notepad++
- Drop above views that depend on metric_id (alerts_view, metrics_data_view, metrics_view).
- ALTER TABLE metrics ALTER COLUMN id TYPE BIGINT.
- ALTER TABLE metrics_data ALTER COLUMN metric_id TYPE BIGINT.
- ALTER TABLE alerts ALTER COLUMN metric_id TYPE BIGINT.
- ALTER sequence metrics_id_seq as bigint MAXVALUE 9223372036854775807.
- Recreate views previously dropped.
- Restart ArcGIS Monitor.
Please reach out to Marlon A. or Marlon S. for any clarification.
Steps to Reproduce