Hi everyone. The development team has identified the issue and provided the solution to Esri Support. I also want to provide the solution here for those who are comfortable running SQL commands against PostgreSQL databases. If you do not have experience administering PostgreSQL, please reach out to Esri Support for help performing this workflow.
The cause of this issue is a small bug in the upgrade process that leaves all child components (service, storage, and connector) in the migrated state after an agent is configured on the host machine, whereas the state of these components should be changed to monitored at that point in time. The solution is to 1) identify all of the effected components and 2) update their state from migrated to monitored. Here are the steps to do so:
- Stop the ArcGIS Monitor Server service.
- Connect to the ArcGIS Monitor database in pgAdmin.
- Open a new query window.
- Issue the query below, which will list all of the child components whose state is migrated but whose parent component state is monitored
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. If there are one or more results from the query above, issue the query below, which will align the child component states with their parent component (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. Issue the query from step 4 again. If step 5 was successful, no records should be returned by this query.
7. Start the ArcGIS Monitor Server service and verify that the service components are now visible via the ArcGIS Monitor web UI.
Alternatively, a patch that addresses this issue will be available in the coming weeks.
Josh
