topic Re: Relational Datastore Status Recovery Failed in ArcGIS Enterprise Questions

Relational Datastore Status Recovery Failed

ClintonBallandis1 — Wed, 27 Mar 2019 00:13:49 GMT

Hi,

I can no longer validate my federated ArcGIS Servers in Portal 10.5. When I do this I get red exclamation marks. I'm trying to track down the cause of the issue and have started looking at the datastore. I can publish map services from Pro however I don't seem to be able to publish hosted services. When I run the describe datastore utility the relational data store status is RecoveryFailed, while the tile cache datastore status is Started.

I'm assuming that the relational datastore status should also be started. Any ideas on how I restart / repair the datastore ?

Thanks,

Clinton

Re: Relational Datastore Status Recovery Failed

ThomasNoble — Mon, 08 Apr 2019 19:01:11 GMT

Hi Clinton Ballandis‌,

I sent you a workflow via private message that should remedy the issue. Feel free to let me know if you have any other questions!

Best,

Thomas

Re: Relational Datastore Status Recovery Failed

ClintonBallandis1 — Tue, 09 Apr 2019 23:53:22 GMT

Hi Thomas,

Thanks for providing the solution. I can confirm that the process you provided worked. My relational datastore now has a Status of Started.

Regards,

Clinton

Re: Relational Datastore Status Recovery Failed

JamesN — Thu, 23 May 2019 03:51:59 GMT

What was the workflow? Is there a reason it wasn't posted?

We have something similar occurring although we can post a new hosted service. Validation is successful in Portal and Server manager, but not at Server Admin or in DescribeDatastore.

Re: Relational Datastore Status Recovery Failed

DennisSmith — Wed, 05 Jun 2019 16:19:17 GMT

Hello there James, the best result is that you can call into support and ask for some assistance with this as it is not something that we would normally just pass on without someone from support being involved with.

Re: Relational Datastore Status Recovery Failed

Victor_Estevez — Tue, 17 Nov 2020 10:44:33 GMT

i'm having the same issue.

Is The solution related with edit the arcgis-data-store-config.json ?

Re: Relational Datastore Status Recovery Failed

Irina_Rakhimova — Mon, 07 Dec 2020 22:48:32 GMT

@Victor_Estevez Not sure if you are still having an issue, but I believe the solution is documented here under Alternate Solution.

Re: Relational Datastore Status Recovery Failed

Anonymous User — Thu, 29 Apr 2021 01:58:10 GMT

In my client's case this was resolved by a simple restart of the DataStore service (Portal 10.8.1)

Re: Relational Datastore Status Recovery Failed

EmilioTomeBlasco — Tue, 28 Mar 2023 13:27:34 GMT

Please @ClintonBallandis1 , can you share the workflow publcly?

Thanks!

Re: Relational Datastore Status Recovery Failed

AlexQuintero1 — Wed, 19 Apr 2023 16:02:42 GMT

What's the workflow for the fix? Having the same issue.