topic Re: Relational Data Store has a status of RecoveryFailed in ArcGIS Enterprise Questions

Relational Data Store has a status of RecoveryFailed

StephenKaranja — Wed, 01 Nov 2023 17:49:59 GMT

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.

Re: Relational Data Store has a status of RecoveryFailed

Dan_Brumm — Wed, 01 Nov 2023 20:44:53 GMT

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:

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

Re: Relational Data Store has a status of RecoveryFailed

StephenKaranja — Wed, 01 Nov 2023 22:19:20 GMT

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".

Re: Relational Data Store has a status of RecoveryFailed

Dan_Brumm — Thu, 02 Nov 2023 19:19:20 GMT

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?

Re: Relational Data Store has a status of RecoveryFailed

Hector_Melendez — Mon, 20 Nov 2023 01:41:17 GMT

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

Re: Relational Data Store has a status of RecoveryFailed

StephenKaranja — Mon, 20 Nov 2023 17:18:31 GMT

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

Re: Relational Data Store has a status of RecoveryFailed

brumm1dj — Mon, 20 Nov 2023 17:09:37 GMT

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.

Re: Relational Data Store has a status of RecoveryFailed

Tim_Shapiro — Sat, 20 Jan 2024 00:56:58 GMT

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!

Re: Relational Data Store has a status of RecoveryFailed

TylerTheobald — Tue, 19 Aug 2025 10:13:29 GMT

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.