2

I am getting this error when trying to upgrade ArcSDE from 10.0 to 10.1:

Cannot upgrade a user schema geodatabase when the master schema geodatabase is at a previous release.

The master schema geodatabase must be upgraded first.

ERROR: Geodatabase schema object install not completed (-522).

However, I am updating the ArcSDE master geodatabase only, so why am I getting this error?

Improve this question
3
  • 1
    Welcome to GIS SE! However, please be aware that when you use ALL CAPS, many people will interpret that as you shouting. There is an edit button beneath your question which I would recommend you use ASAP to replace your current title with something in Mixed Case.
    – PolyGeo ♦
    Commented Aug 25, 2014 at 7:43
  • Can you provide the Python command and geoprocessing request output inside the question? The answer for why ArcGIS thinks you're requesting a user-schema geodatabase upgrade is in the run-time parameters.
    – Vince
    Commented Aug 25, 2014 at 19:13
  • 1
    Are you using Oracle? support.esri.com/en/bugs/nimbus/TklNMDg0OTg3
    – ianbroad
    Commented Aug 26, 2014 at 7:54

1 Answer 1

Reset to default
5

I agree with ian. Please see below. It seems like you're upgrading an Oracle ArcSDE geodatabase but using the old connection syntax to do so.

This would be the 10.0 connection syntax used within ArcGIS Desktop 10.1, which should not be used and will cause an upgrade operation to fail:

enter image description here

Here is what it should look like (server/service):

enter image description here

You can also connect using only the service name or only the TNSNAME. Be sure to append the port the instance is listening on if you are not using the default 1521.

Here is the documentation for acceptable connection syntax in ArcGIS Desktop 10.1:

Database connections in ArcGIS for Desktop (10.1)(Oracle section) http://resources.arcgis.com/en/help/main/10.1/index.html#/Geodatabase_connections_in_ArcGIS_Desktop/002n00000030000000/

Here is the link to NIM084987, that ian shared above: http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDg0OTg3

As the link suggests, you may also verify you have EZCONNECT enabled in your sqlnet.ora file on the client machine such as NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT).

Please let me know if you have any questions.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.