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.
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:
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
Hi! Actually yes I did find a solution with the help of Support. I used Command Prompt and ran admin:database:unregister, then immediately ran admin:database:register. After those commands were successfully completed, I checked admin:database:info and everything showed true.
Here is a link for the register command. You can also run any command with --help to get more info. Hope this works for you!!
I have had the same issue each time trying to upgrade from monitor 2023.3.1 to 2025.1. Have you resolved this yet?
I am attempting to upgrade to Monitor 2025.1 from 2023.3.1 and am getting a similar error but I don't think it is related to the ANALYSES table ( I don't have an empty arrays).
I used command prompt and ran arcgis-monitor-server.exe admin:database:info to see if I could get some more database info, and this is the result I got:
I know this is kind of a ridiculous question, but does anyone know how to get the database schema ready? I think this could be the root cause of the issue.
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
HI @RexNeville,FYI, ArcGIS Monitor 2024.0.1 is planned for release on Oct 3rd.Hope this helps,
No one should use Monitor 2024.0 it has other bugs with no patch released. wait for 2024.1.
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
Hi @WhitneyLoy and @Nidhin_G - clearly Josh's reply/solution(s) below render my question moot, but thanks anyway
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 @Nidhin_G - removing and then recreating the agm database?
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
Support was able to assist me getting the db back online.
I am getting the same error message. Upgrading from 2023.3.1 to 2024.0.
we upgraded from 2023.3.1, same issue...rolled back
My department is also upgrading from 2023.3.1, apologies
@GeoJosh upgrading from 2023.3.1
@GeoJosh CORRECTION I am upgrading from 2023.3.1
Hi @WhitneyLoy and @EdenPunter,
Are you also upgrading from 2023.1 --> 2024.0 or are you upgrading from another version? Dev team is investigating.
Thanks,
Our 2023.1 Environment is also experiencing these issues.
We are also seeing this error after upgrading from 2023.1 in our environment.
Same issue in my organization after upgrading. Have restarted the ArcGIS Monitor Server and PostgreSQL services also.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
