Accepted Solutions
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:
- Stop the ArcGIS Monitor Server service.
- Connect to the ArcGIS Monitor database in pgAdmin.
- Open a new query window.
- Issue this query: SELECT * FROM ANALYSES
- 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
