Upgrade ArcSDE geodatabase of sde-schema failed

J_Chen

I could not be able to upgrade ArcSDE 10 sp2 geodatabase. This geodatabase is of sde-schema and single-database model. 

I have ArcGIS Desktop 10, ArcGIS Server 10-GIS Services, and ArcSDE 10 in my laptop running Windows 7 Professional 64-bit. An ArcSDE 10 geodatabase of sde-schema and single-database model was created in an instance of SQL Server 2008 R2 Developer (similar to Enterprise). My laptop is a development platform for testing purposes.

I successfully installed the ArcGIS Desktop 10 sp2, ArcGIS Server 10-GIS Services sp2, and ArcSDE 10 sp2, by following instruction on http://resources.arcgis.com/content/patches-and-service-packs?fa=viewPatch&PID=17&MetaID=1752.

I used Direct Connect to get ArcGIS Desktop 10 sp2 connecting to the ArcSDE geodatabase. The server login is a member of sysadmin, no custom functionality such as stored procedures,  by following instruction on http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q000000m6000000.

In ArcCatalog 10, I right-clicked the Direct Connect string (with login being a member of sysadmin) for the ArcSDE geodatabase, clicked the Properties. In the Database Properties dialog, I clicked the Upgrade geodatabase button. In the Upgrade geodatabase dialog, when I checked the Perform pre-requisite check box, I got the message

Executing: UpgradeGDB "Database Connections\gis@gravel.gis-g7760.sde" PREREQUISITE_CHECK NO_UPGRADE
Start Time: Tue Sep 06 13:51:46 2011
There are no other active connections.
User has privileges required to upgrade.
Running Pre-Requisite check (C:\Users\chenj.DHEC\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\gis@gravel.gis-g7760.sde).
Instance supports XML type.
Succeeded at Tue Sep 06 13:51:47 2011 (Elapsed Time: 1.00 seconds)

However, when I checked both the Perform pre-requisite check and Upgrade geodatabase checkboxes, I got the following error message

Executing: UpgradeGDB "Database Connections\gis@gravel.gis-g7760.sde" PREREQUISITE_CHECK UPGRADE
Start Time: Tue Sep 06 13:53:59 2011
Paused the database for upgrade.
There are no other active connections.
User has privileges required to upgrade.
Running Pre-Requisite check (C:\Users\chenj.DHEC\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\gis@gravel.gis-g7760.sde).
Instance supports XML type.
Updating ArcSDE server tables and stored procedures.
Could not update ArcSDE server tables and stored procedures.
Unpaused the database.
Failed to execute (UpgradeGDB).
Failed at Tue Sep 06 13:53:59 2011 (Elapsed Time: 0.00 seconds)

Any thoughts?

ForrestJones

Hi Jianwu,

Is there any more information in the client machine's %TEMP%\sdedc_SQL Server.log or the sde_setup.log?

Thanks,