Relational Data Store has a status of RecoveryFailed

[StephenKaranja]

Hello,

We can no longer validate our relational data store using ArcGIS Server Manager. The describedatastore utility shows that the status of the relational data store is RecoveryFailed. Restarting the ArcGIS Data Store service does not change the status.

We'd appreciate any help in resolving this.

[Dan_Brumm]

Ran into this issue a few times where my DS was working fine but it had a status of RecoveryFailed. Worked with ESRI to resolve:

1. Stop the  DataStore windows services. 
2. Go to C:\arcgisdatastore\etc\relational-config.json
3. Set: datastore.lastknowstatus & localstore.lastknownstatus to "Stopped"
4. Restart the datastore and see if that resets the status of each line to "Started" . 
5. Run the describedatastore command to validate

[StephenKaranja]

Thanks a lot for the instructions Daniel. I've tried them out but they haven't resolved the problem. After restarting the data store service, the lines in the relational-config.json file change to "StartFailed", and running the describedatastore utility shows that the status of the relational data store is also "StartFailed".

[Tim_Shapiro]

wow - this method just saved my data store!  somehow, my relational-config.json file was entirely empty.  I copied the history file into it, and then followed these steps and we are back up and running.  Thank you!

[Dan_Brumm]

I am trying to find my ESRI ticket so i can see exactly what we tried. In the mean time do your datastore logs point at anything? 

[Hector_Melendez]

I'm having the same issue. Did you find the steps to fix it? @Dan_Brumm @StephenKaranja 

[StephenKaranja · Accepted solution]

The problem resolved itself. We restarted the ArcGIS Data Store service a few times and eventually it started with a status of "Started".

[brumm1dj]

My ticket outline the same steps as I wrote above. For us the DS never stopped working we just had that odd status that I didn’t like seeing. 

[TylerTheobald]

Though this doesn't seem to affect the 11.3 DataStore function, this status of RecoveryFailed keeps our webgisdir backup utility from working....

"Unable to create a Web GIS backup on machine 'xxxxxxxxxxxxxxxxxxxxxxxxxxx' as relational data store service is not running"

Have an active Esri case on this and after several sessions, we still don't know the root cause.