laptop and a wrench

Bug

ArcSDE geodatabase upgrade for Oracle fails if the Geoprocessing upgrade script is executed using ArcGIS Server or Engine. Please see technical article Technical Article 37974 for more details.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM058774
SubmittedJuly 2, 2010
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found10.0
Version Fixed10.1
StatusFixed

Description

When upgrading an ArcSDE Oracle geodatabase, the Upgrade Geodatabase tool fails if executed from a Linux platform. The failure also occurs if the Upgrade Geodatabase tool is run as a script or a model.

The following error message displays in the output of the tool:
 
"File "<stdin>", line 1, in <module>
File ../python26/lib/python2.6/site-packages/arcpy/arcpy/management.py", line 532, in
UpgradeGDB
raise e
arcgisscripting.ExecuteError: Could not update ArcSDE server tables and stored procedures.
Failed to execute (UpgradeGDB)."

The following error message displays in the sde_setup.log file, after the first time the upgrade is attempted:
 
"Unable to load package pinfo_util, file ../lib/pinfo_util.sps not found or badly formatted.
ERROR in creating system stored procedures.
Error: -79"

Cause

Oracle geodatabase object definition files are missing from the Linux installations of ArcGIS Server and Engine RT.

Workaround

Option 1:
Use ArcCatalog to upgrade the geodatabase to version 10, or run the Upgrade Geodatabase tool from a Windows platform that either has ArcGIS 10 Desktop, Server, or Engine RT installed.

Option 2:
On the Linux platform, apply ArcGIS 10 Service Pack 1 to ArcGIS Server or Engine RT, and then run the Upgrade Geodatabase Python script.


For more information on upgrading, see the Upgrading an ArcSDE geodatabase in Oracle topic in ArcGIS 10 Web Help.
 
 

Steps to Reproduce

Bug ID: NIM058774

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options