Server Manager Registered Database fails Validating Randomly

191
1
02-27-2024 09:02 AM
CodeSpatial
New Contributor II

We have about 200+ postgres 12.17 enterprise databases from AWS RDS registered in the multi-machine AGS site. While running the validate all from the server manager, it validates a few databases, some fails to validate, but most of the DBs at the end of the list fail to validate. If you go and check the db in smaller chunks (say 10-15) it validates fine.

I have already updated the Publishing tool instances and the javaheapmemory for this GP and still no luck. Any thoughts from the community?

0 Kudos
1 Reply
CodeSpatial
New Contributor II

Forgot to mention, that running the validate all on these 200 dbs, brings down the entire server sometimes.