Relational Datastore Status Recovery Failed

[ClintonBallandis1]

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

[ThomasNoble · Accepted solution]

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

[EmilioTomeBlasco]

Please @ClintonBallandis1 , can you share the workflow publcly?

Thanks!

[AlexQuintero1]

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

[ClintonBallandis1]

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

[JamesNeild1]

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.

[DennisSmith]

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.

[Victor_Estevez]

i'm having the same issue.

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

[Irina_Rakhimova]

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

[Anonymous User]

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