Re-register ArcGIS Relational Data Store 10.9.1

Question

Is there absolutely any way to recover/re-register the ArcGIS Data Store relational database and/or its data that was unregistered through ArcGIS Server Manager? I tried reconfiguring it through the configuration wizard but the relational database store type was already checked and greyed out. I’m currently unsure if a snapshot is available. I do see a couple of backups on our data store machine specifically but don’t want to risk causing further damage to our hosted data. This seems like it should be a really simple fix, but can find nothing on the internet to help.

TimoT · Answer

It's good practice to create a backup before making changes, particularly in a production environment. If you don't have one, I suggest making a backup of the current state before making further changes.

Typically, unregistering a datastore through Server Manager also unregisters it on the ArcGIS Data Store. Sometimes this may fail if there's a connectivity issue between the Hosting Server and Datastore (or other reasons). In such cases, you can manually run the unregisterdatastore utility on the relational datastore. Note that an unregistered relational datastore doesn't mean data gets wiped; it's simply in a state where the underlying postgres database isn't running.

The registerdatastore and configuredatastore utilities won't create a new database if one already exists. As long as the configuration files at \arcgisdatastore\etc are intact, either of these tools can be used to reconnect the existing relational database to the Hosting Server site.

For the most part, you can think of the registerdatastore and configuredatastore tools as providing your ArcGIS Server access with a database connection file containing credentials and other database details without altering the database itself.

If you encounter errors about an existing datastore during re-registration, you may need to modify the dsconnections.lst file on the Hosting Server. Various technical articles cover this workflow such as:

* Error: The Specified ArcGIS Server Already Has a Managed Data Store

Let's hope the initial issue was just a momentary blip that caused the ArcGIS relational datastore to fail to unregister itself. Otherwise, it could be a sign of deeper issues to come.

simoxu · Answer

step 1, run the registerdatastore utility tool

https://enterprise.arcgis.com/en/data-store/latest/install/windows/data-store-utility-reference.htm#ESRI_SECTION1_AD1036510727497D97CCF848B9671565

if that doesn't work, step 2, run the unregisterdatastore utility tool, then run the above registerdatastore tool.

https://enterprise.arcgis.com/en/data-store/latest/install/windows/data-store-utility-reference.htm#ESRI_SECTION1_FC8C7800AB4D42179D9A804F348EBF19

unregisterdatastore utility tool won't delete the data. I've used it several times.

Step 3, restart the datastore and run describedatastore utility tool

https://enterprise.arcgis.com/en/data-store/latest/install/windows/data-store-utility-reference.htm#ESRI_SECTION1_5ECEA8B5F835454CB7D0DBC942BB4FDB

Check the "Owning system url", make sure it's pointing to your hosting server.

BillFox · Answer

maybe try the command line tool to force un-register as a windows admin in admin window