topic Couldn't Validate Arcgis Data store managed databse in ArcGIS Enterprise Questions

Couldn't Validate Arcgis Data store managed databse

QiranLiang — Thu, 15 Mar 2018 22:12:50 GMT

I installed the Datastore for a while, it was working for a while. But the relational part (and relational part only) became invalidate recently (see attch). I already tried to update/reconfigure the data store, but still. Any idea why it happened?

Re: Couldn't Validate Arcgis Data store managed databse

JonathanQuinn — Thu, 15 Mar 2018 22:23:31 GMT

You've tried to unregister and re-register the data store? You may also need to unregister the data store item from Manager or the Admin API.

Re: Couldn't Validate Arcgis Data store managed databse

QiranLiang — Thu, 15 Mar 2018 22:38:36 GMT

I already tried that through manager and use the configure tool to re-register it, but the relational part is still invalidate.

Re: Couldn't Validate Arcgis Data store managed databse

QiranLiang — Thu, 15 Mar 2018 22:50:46 GMT

I used the Server manager to remove the data store (by clicking the X on the right side), and reconfigure it through the configuration tool.

Re: Couldn't Validate Arcgis Data store managed databse

QiranLiang — Fri, 16 Mar 2018 18:36:31 GMT

I try to look at the logs and it said no ArcGis server license was found. How can I update the license for the data store.

Re: Couldn't Validate Arcgis Data store managed databse

QiranLiang — Fri, 16 Mar 2018 20:37:34 GMT

I also tried to uninstall and re-install the data store. But the managed database is still down.

Re: Couldn't Validate Arcgis Data store managed databse

JonathanQuinn — Fri, 16 Mar 2018 22:24:07 GMT

There's a command line tool to do that:

ArcGIS Data Store command utility reference—ArcGIS Data Store (Windows) Installation Guide | ArcGIS Enterprise

Give it a shot, that may fix the problem.

Re: Couldn't Validate Arcgis Data store managed databse

QiranLiang — Fri, 16 Mar 2018 22:37:20 GMT

Got it fixed! Thanks!

Re: Couldn't Validate Arcgis Data store managed databse

ErnestoCarreras4 — Fri, 14 Sep 2018 18:11:58 GMT

Hi! I am experiencing the same issue. How did you fix it?

Re: Couldn't Validate Arcgis Data store managed databse

QiranLiang — Fri, 14 Sep 2018 18:18:43 GMT

We have encountered similar problems for couple of times. you can try to update the datastore's license with the command line.

ArcGIS Data Store command utility reference—ArcGIS Data Store (Windows) Installation Guide | ArcGIS Enterprise

Or often time it's the webadopter not configure correctly.

Re: Couldn't Validate Arcgis Data store managed databse

deleted-user-d8qgCRT3EsXu — Wed, 03 Oct 2018 02:16:28 GMT

Hi Jonathan, I experiencing the same problem and have attempted to update the licence in this manner but was met with an error, the message read "Error update license failed for managed geodatabase". Have you encountered this before?

Re: Couldn't Validate Arcgis Data store managed databse

JonathanQuinn — Wed, 03 Oct 2018 16:28:03 GMT

No, but if you set the Server logs to DEBUG, you may get more information about why it failed.

Re: Couldn't Validate Arcgis Data store managed databse

WilliamShoop — Fri, 19 Jul 2019 18:38:13 GMT

Hey!

I installed a patch to my servers and afterwards I was experiencing this issue and resolved it by running updatelicense. I was wondering to what root cause may be? I don't want this to happen every time I install a patch. Qiran Liang‌ You mentioned that it could be caused by your web adaptor not configured correctly, do you know how to determine if that is the case and how to fix it?

Thanks,

Bill

Re: Couldn't Validate Arcgis Data store managed databse

FernandoMons_Nuñez — Wed, 19 Aug 2020 11:16:51 GMT

Hi,

We encountered similar problems trying to update the license of the datastore, and the problem exactly was that the datastore has changed itself to read only mode. Changing it to Write mode, we could update the license.

We saw the cause of the problem in the logs of the datastore. The SQL executed by the system during the Updatelicense command was returning a message like this:

"Can not execute an update sentence in read only mode transaction"

Our Arcgis Server and datastore was in version 10.5.1

Re: Couldn't Validate Arcgis Data store managed databse

User35489 — Tue, 19 Dec 2023 11:37:58 GMT

In my case, It got fixed after the port 9876 was unblocked after accidentally closed by the cyber security.

9876 (TCP)—Internal communication between the hosting ArcGIS Server site and the relational data store occurs through this port, as does some communication between the primary and standby relational data store machines.

https://enterprise.arcgis.com/en/data-store/latest/install/windows/ports-used-by-arcgis-data-store.htm