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?

[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]

this did not work in my case. I am curious as to why we have to follow this step because ESRI upgrade documents do not even talk about this. as per ESRI upgrade doc, we just need to run setup script and then configuredatastore command. that should take care of the upgrade of datastore relational. also  the document  says you can directly upgrade from 10.8.x or 10.9.1 to 11.4 . this statement seems wrong in my opinion if we follow additional procedures like gdbupgrade or backup and restore,

[nicogis]

Given that I only conducted a test, this is not an official Esri document. What I suggested applies solely to the case of an upgrade from 10.7.1 to 11.3, where a documented bug existed in 11.3. This issue was resolved in 11.4, which allows for a proper upgrade to version 11.4. That’s all—so if you're not dealing with these specific conditions, this does not apply to your case.

[KannanSundaresan]

I get that. What I am trying to imply is that, even with 10.9.1 to 11.4 also has same issue. The relational datastore upgrade does not upgrade the SDE part of it
But only upgrades the datastore as I mentioned in the screenshot. The backup and restore the datastore did not fix it. I am curious if you have seen this issue with 10.9.1 as well.

[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