Error connecting to DB after 2024.0 upgrade

[WhitneyLoy]

Getting the following error after upgrading to 2024.0.  The Database is not ready. Database schema not up to date

I have tried restarting both the ArcMonitor and PostgreSQL service and reinstalling the update and the same error is occurring.

[DerekLaw]

HI @RexNeville,

FYI, ArcGIS Monitor 2024.0.1 is planned for release on Oct 3rd.

Hope this helps,

[Dan_Brumm]

we upgraded from 2023.3.1, same issue...rolled back 

[WhitneyLoy]

Support was able to assist me getting the db back online.

[NiG]

I encountered the same problem and resolved it by removing the old database schema (AGM) and then recreating it. I lost everything on that DB, but at least its working now.

CREATE USER agm WITH PASSWORD '<password>'

LOGIN

NOSUPERUSER

INHERIT

NOCREATEDB

NOCREATEROLE NOREPLICATION;

CREATE DATABASE agm WITH OWNER=agm;

GRANT ALL ON DATABASE agm TO agm;

ArcGIS Monitor system requirements—ArcGIS Monitor | Documentation 

[DavidColey]

Hello @WhitneyLoy  - can you report here what support did to help you get the db back online?  Did you have to go through the same steps as @NiG  - removing and then recreating the agm database?  

[DavidColey]

Hi @WhitneyLoy and @NiG  - clearly Josh's reply/solution(s) below render my question moot, but thanks anyway

[GeoJosh · Accepted solution]

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 the presence of empty Analysis Views or Analysis Views that only contain Header elements. The solution to this issue is to remove all empty Analysis Views and restart the ArcGIS Monitor Server process.

If you have already rolled back to a previous release, you can simply delete any empty Analysis Views through the web GUI and then re-run the upgrade. If your ArcGIS Monitor installation is stuck in the state described in this post, you can manually delete the Analysis Views from the database. To do so:

1. Stop the ArcGIS Monitor Server service.
2. Connect to the ArcGIS Monitor database in pgAdmin.
3. Open a new query window.
4. Issue this query: SELECT * FROM ANALYSES
5. Take a CSV backup of the results.

6. Delete any row where the expressions array under the configuration column is empty or is missing entirely. For example, a row with the configuration object below would be deleted, because the expressions array is [] (empty):

7. Start the ArcGIS Monitor Server service and try accessing the application again. If the problem persists, please reach out to Esri Support for further troubleshooting.

Alternatively, a patch that addresses this issue will be available in the coming weeks.

Josh

[JeffMertzXcel]

This worked for me going to 2024.0.0 from 2023.3.1 . Additionally, I found that some components, specifically disk monitoring, did not upgrade. The state in the components table was set to 'migrated' and should have been 'monitored'. After updating them, they all showed up again in the Storage folder. See this post: Solved: Re: ArcGIS Server services missing after upgrading... - Esri Community

[AnasKanaan]

Hi @GeoJosh ,
I do not have a problem with the configuration column in the analyses table. my log is saying The database is not ready. Database schema not up to date. I upgraded from 2023.1 to 2024 
Many Thanks buddy 🙂
//Anas