ArcGIS Monitor Errors While Creating Analysis Views

Question

While trying to create analysis views, ArcGIS Monitor has become unresponsive and is stuck "loading", eventually returning "Error Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?"

I restarted the Monitor and Postgres services and was momentarily able to get into ArcGIS Monitor before the behavior returned.

Any ideas what the cause and solution might be?

MarieCline_Delgado · Answer

@AndrewSakowicz I did have the analysis set as home.  I now have the Sample Analysis set back as the home.  I also had the new analysis set as the System Default, which I have also changed back to the Sample Analysis.

I will continue working with the new analysis and see if the issues appear to have resolved.  Thank you for the support!

AndrewSakowicz · Answer

@MarieCline_Delgado , did you set this new analysis as Home?  If yes, please navigate to Analysis and change the  home back, e.g. Sample Analysis (perhaps restart PG and monitor first?) .  Next, evaluate which data expression in the new analysis is causing this condition and share it.

MarieCline_Delgado · Answer

The database is connected.  I am using PostgreSQL 15.4