ERROR

Geodatabase schema object install not completed (-522)

Last Published: September 2, 2020

Error Message

Using a full Oracle client to upgrade an Oracle geodatabase with the syntax ‘sde: oracle11g:TNSNAME’ returns the following error message:

“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)."
Note:
The error is returned in the sde_setup.log file (path: C:\Users\<username>\AppData\Local\Temp).

Cause

This is a known issue.

Solution or Workaround

Change the connection syntax from ‘sde:oracle11g:TNSNAME’ to the Transparent Network Substrate (TNS) name in the Instance text box:

  • Type the TNS name in the Instance text box, as shown in the figure below.
[O-Image]

Or,

  • Modify the sqlnet.ora file on the client machine to connect to the geodatabase with the Easy Connect string, and upgrade the geodatabase.

Article ID:000012196

Software:
  • ArcMap 10 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options