topic Re: Failed to validate server managed database in ArcGIS Enterprise Questions

Failed to validate server managed database

wizgis — Fri, 27 Oct 2023 11:36:40 GMT

Hi Community,

We are on ArcGIS Enterprise 10.9.1 and have a multi-machine deployment with Server, Portal & Datastore on machine A and WebAdaptor installed and configured on machine B.

We are facing an intermittent issue all of a sudden where ArcGIS Data Store is sometimes validating with Portal & Server and sometimes not. I am not really sure what exactly is causing this behavior. Am attaching screenshots for reference purpose. Although tile cache data store does get validated.

Observations:

New hosted services are not getting published though, existing hosted services are loading in map viewer with attributes as well as geometry (not sure if its an expected behavior given data store is not getting validated).
Not sure if it's related to this however, have noticed that it is taking time for server manager, portal home to load.

Troubleshooting done so far:

Have restarted the machine that has Portal, Server and DataStore installed.
Have restarted windows services of Portal, Server and DataStore 3-4 times.

Any suggestions or further troubleshooting steps would be highly appreciated.

Re: Failed to validate server managed database

MarceloMarques — Fri, 27 Oct 2023 15:08:43 GMT

You can test the Enterprise Geodatabase rdbms database connection using the database client tool in each arcgis server machine to troubleshoot this further, if you do not know how to do this then I recommend you to ask assistance from your database administrator. You did not mention your RDBMS flavor, but for example:

Oracle Instant Client - Oracle SQL Plus

PostgreSQL - pgAdmin / psql

SQL Server - SQL Server Management Studio / sqlcmd

If the issue is intermittent then this can have many reasons, network interruptions, busy database server, etc. in any of these circumstances the database administrator shall be able to troubleshoot and diagnose what the problem might be.

I hope this helps.

Re: Failed to validate server managed database

wizgis — Mon, 30 Oct 2023 06:26:02 GMT

@MarceloMarques Thank you for sharing your inputs.

Unfortunately, we do not have a database administrator and moreover, I am curious to know if we would need a database administrator as the issue is with DataStore not getting validated.

One more thing that I noticed today is after I stop the services of Server, Portal & DataStore there are still certain java processes that are running in the task manager. Am not sure if this is an expected behavior and could this be the cause of DataStore not validating. Moreover, if this is not an expected behavior should I go ahead and end these tasks manually.

Attaching a screenshot for reference.

Re: Failed to validate server managed database

MarceloMarques — Mon, 30 Oct 2023 19:23:39 GMT

Use the command "describedatastore" to check the status for your datastore, if datastore is read-only then it will fail to validate, you can then change your datastore to read-write if necessary, if you still encounter issues then I recommend you to open a ticket with Esri Tech Support to investigate in more detail.

Re: Failed to validate server managed database

aahiapple — Tue, 05 Mar 2024 19:49:54 GMT

Hi! I am running into this same issue. Did you manage to fix this? If so, how?

Re: Failed to validate server managed database

aahiapple — Tue, 05 Mar 2024 19:51:44 GMT

Hi, I am experiencing the same issue as described in the question. However, I do not have a database administrator. Do you mind explaining more about the RDBMS and the managed database? How would that work for RDBMS of PgAdmin4?

Re: Failed to validate server managed database

KThomasson — Mon, 08 Apr 2024 01:16:48 GMT

This is something I have ran into as well I did run the describe datastore and everything looks super, but the postgresql database is not wanting to validate. My relation database, spatiotemoral, and tile cache database all validate but the one database that host all our collected field data is not validating and I cannot find any solutions.

Re: Failed to validate server managed database

AngelaVanderpas1 — Fri, 12 Apr 2024 19:11:56 GMT

I am also experiencing this. Has there been a solution?

Re: Failed to validate server managed database

KThomasson — Fri, 12 Apr 2024 19:36:01 GMT

so I figured out that my issue has something to do with my postgresql version install, because I was able to switch the database back to the old version and it validated the database no issue. I suggest if you are running postgresql server with an sde database and you get this error then you should try reverting it back to see if it will validate.

Re: Failed to validate server managed database

EsraCındır — Thu, 21 Nov 2024 05:57:27 GMT

Hi wizgis

Did you find any solution your problem?

Re: Failed to validate server managed database

adolch_mecknc — Mon, 30 Mar 2026 13:32:31 GMT

It is a very simple fix, you have to remove the datastore in ArcGIS Server and then run ArcGIS DataStore Configuration Wizard again, that will fix the problem. If it is from a hosted feature or an enterprise geodatabase, you select and delete the registered dataset and then go back into ArcGIS Pro or Map and re-register the dataset. That usually fixes it. I hope this helps.