nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Data Store upgrade 10.7.1 to 11.3 failed to upgrade PostgreSQL relational data store

JamesBrattonVHB

I upgraded ArcGIS Enterprise from 10.7.1 to 11.3. Every upgrade (Portal, Server, web adaptors, Data Store) reported success on the upgrade. When I validate the relational data store, it fails with the error message:

When I run describedatastore, it says the data store is 11.3.0.51575.

Checking the log files, I see

If I connect to the relational data store, it says that the database is version 10.7.1. I tried to connect with ArcGIS Pro, but it fails to connect with error: Database Connection: FDO error: -2147216086. So it appears that the Data Store upgraded to 11.3, but the underlying relational data store is still at 10.7.1. How can I get that database upgraded or get it to validate properly?

Find more posts tagged with

Accepted answers

JamesBrattonVHB

Esri says that it has worked for some customers to execute C:\Program Files\ArcGIS\DataStore\bin\gdbupgrade.exe. This did not work in my situation.

All comments

CodyPatterson

Hey @JamesBrattonVHB

Due to the complexities of the Datastore, I try to refrain from putting out guesses and suggestions that may cause data loss, the most I'd recommend to try is a restart, but I'm sure that it won't fix it. My current suggestion would be to reach out to ESRI support, this is definitely something an expert should check out.

Cody

JamesBrattonVHB

Thanks. I have tried a repair, service restart, and server reboot. The data store is still not validating. I've opened a ticket with Esri too.

D_McRitchie

Hey James as Cody mentioned for certainity it is good to keep several backups, ideally a content backup and cold machine backup.

If possible I would try restoring back to 10.7.1 and then testing an upgrade to 10.9.1. There are a lot of functional changes and this is the generally recommended update pattern.

Hope that helps,

David

JamesBrattonVHB

I heard back from Esri today. This is a bug that is fixed in 11.4. I understand that I could go through 2 upgrades to get to 11.3, but I was wondering if anyone knew a way to upgrade the database directly. I suspect that users may have made changes after the 11.3 upgrade, and I want to avoid losing data. BUG-000169801 for ArcGIS Data Store (esri.com)

JustinS

@JamesBrattonVHB, generally speaking, it's atypical to upgrade ArcGIS Datastore outside of our publicly documented workflow(s). I think it's probably best to continue working with Support.

JamesBrattonVHB

Esri says that it has worked for some customers to execute C:\Program Files\ArcGIS\DataStore\bin\gdbupgrade.exe. This did not work in my situation.

JamesMarok1

So what was your actual solution in the end? I am having this same problem. Wish ESRI would upgrade their guides to warn people.

JamesBrattonVHB

I was not able to upgrade the database, so I had to restore the 10.7.1 backup and upgrade to 10.9.1. You don't have to go to 10.9.1, but you can't go directly to 11.3.

JamesMarok1

I was afraid of that ESRI told me to go back to 10.7 then do 10.9 then 10.9.1 then 11.1 and then 11.4 *cries*

nicogis

I have tried and you can upgrade from 11.3 to 11.4 (I had datastore relational):

1) upgrade portal and arcgis server from 11.3 to 11.4

2) rename folder arcgisdatastore (where you have last backup of relational data) in arcgisdatastore1071

3) uninstall Datastore

4) install datastore (do not create relational)

5) restore lastbackup with this command (the folder C:\arcgisdatastore must not exist)

restoredatastore --store relational --target most-recent --source-loc c:\arcgisdatastore1071\backup\relational --data-dir C:\arcgisdatastore --server-url https://gisserver.domain.com:6443 --server-admin mySA --server-password mySApw

KannanSundaresan

I have the very same problem except that I am going from 10.9.1 to 11.3 or 11.4 both same issue.

I tried the solution suggested in this thread which is backing up the datastore and restoring it. even after doing this workflow, when i validate the datastore from arcgis admin URL, I see this below. there is still a mismatch. opened a case with ESRI. they asked me to run gdbupgrade. but that also fails with memory error. we have plenty of memory on the system. no clue as to what the solution would be.

"datastore.release": "11.4.0.54309",

"datastore.release.sde": "10.9.1"

nicogis

It's difficult to provide help through the forum beyond general guidance, as it's necessary to thoroughly review your specific configuration.

Did you disable the antivirus during installation? Do you have enough disk space available?

I usually use restoredatastore when the data store gets stuck, as mentioned, and since it recreates the folder, it doesn’t cause any issues.

KannanSundaresan

We are running it on Linux. So no antivirus software is being used.

nicogis

The problem in this thread concerns this bug related to Windows Server. BUG-000170720 for ArcGIS Data Store

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.