Components missing after upgrading to ArcGIS Monitor 2024.0

Description

The ArcGIS Server, ArcGIS GeoEvent Server, and storage (disk storage or storage resources) components are missing in ArcGIS Monitor after upgrading to version 2024.0 and deploying ArcGIS Monitor Agent in the ArcGIS Enterprise environments.

Cause

A defect in the upgrade process caused certain components to be hidden after deploying ArcGIS Monitor Agent 2024.0 on the remote machine and re-registering with the ArcGIS Monitor Server. The missing components and configurations are still stored in the database.

Solution or Workaround

Warning:   
Do not unregister the parent component from ArcGIS Monitor as a workaround.

Warning:   
The instructions below include making changes to essential parts of the ArcGIS Enterprise deployment. Esri recommends performing a backup of the ArcGIS Enterprise machine, including the ArcGIS Monitor database, before proceeding. Esri cannot guarantee results from incorrect modifications while following these instructions. Consult a qualified computer systems professional if necessary.

1. Stop the ArcGIS Monitor service.
1. In the Windows search bar, type services and click the Services icon.
2. In the Services window, navigate to the ArcGIS Monitor <Service_Name> service and click Stop.
2. Connect to the ArcGIS Monitor database in pgAdmin. Refer to pgAdmin: Connecting To A Server for additional information.
3. Open a new query window. Refer to pgAdmin: Query Tool for additional information.
4. Specify the following query to list all the hidden components.

SELECT * FROM "components" AS "C1"
WHERE
    STATE = 'migrated'
    AND EXISTS (
        SELECT
            *
        FROM
            "components" AS "C2"
            INNER JOIN "component_connections" ON "C2"."id" = "component_connections"."parent_id"
        WHERE
            ((STATE = 'monitored'))
            AND ("C1"."id" = "component_connections"."child_id")
    )

5. Specify the following query to update the state of the components returned by the query above from migrated to monitored.

UPDATE "components" AS "C1" SET STATE = 'monitored'
WHERE
    STATE = 'migrated'
    AND EXISTS (
        SELECT
            *
        FROM
            "components" AS "C2"
            INNER JOIN "component_connections" ON "C2"."id" = "component_connections"."parent_id"
        WHERE
            ((STATE = 'monitored'))
            AND ("C1"."id" = "component_connections"."child_id")
    )

6. Start the ArcGIS Monitor service.
1. In the Windows search bar, type services and click the Services icon.
2. In the Services window, navigate to the ArcGIS Monitor <Service_Name> service and click Start.