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.
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)
Is there any more information in the client machine's %TEMP%\sdedc_SQL Server.log or the sde_setup.log?
Thanks,
Hey, FJ:
Everything such as ArcGIS Desktop and ArcSDE geodatabase in an instance of SQL Server 2008 R2 Developer is on one single laptop computer.
Under the "D:\Program Files\ArcGIS\ArcSDE\sqlexe\etc" folder, there are sde_setup.log and sdedc_SQL_Server.log files. Here are they.
sde_setup.log: ---
[Tue Aug 30 14:24:52 2011] VERSION table created... [Tue Aug 30 14:24:52 2011] SPATIAL_REFERENCES table being created... [Tue Aug 30 14:24:52 2011] SPATIAL_REFERENCES table created... [Tue Aug 30 14:24:52 2011] GEOMETRY_COLUMNS table being created... [Tue Aug 30 14:24:52 2011] GEOMETRY_COLUMNS table created... [Tue Aug 30 14:24:52 2011] LAYERS table being created... [Tue Aug 30 14:24:52 2011] LAYERS table created... [Tue Aug 30 14:24:52 2011] METADATA table being created... [Tue Aug 30 14:24:52 2011] METADATA table created... [Tue Aug 30 14:24:52 2011] RASTER_COLUMNS table being created... [Tue Aug 30 14:24:52 2011] RASTER_COLUMNS table created... [Tue Aug 30 14:24:52 2011] TABLE_REGISTRY table being created... [Tue Aug 30 14:24:52 2011] TABLE_REGISTRY table created... [Tue Aug 30 14:24:52 2011] STATES table being created... [Tue Aug 30 14:24:52 2011] STATES table created... [Tue Aug 30 14:24:52 2011] VERSIONS table being created... [Tue Aug 30 14:24:52 2011] VERSIONS table created... [Tue Aug 30 14:24:52 2011] MVTABLES_MODIFIED table being created... [Tue Aug 30 14:24:52 2011] MVTABLES_MODIFIED table created... [Tue Aug 30 14:24:52 2011] STATE_LINEAGES table being created... [Tue Aug 30 14:24:52 2011] STATE_LINEAGES table created... [Tue Aug 30 14:24:52 2011] LOCATORS table being created... [Tue Aug 30 14:24:52 2011] LOCATORS table created... [Tue Aug 30 14:24:52 2011] XML tables being created... [Tue Aug 30 14:24:52 2011] XML tables created... [Tue Aug 30 14:24:52 2011] COLUMN_REGISTRY table being created... [Tue Aug 30 14:24:52 2011] COLUMN_REGISTRY table created... [Tue Aug 30 14:24:52 2011] ARCHIVES table being created... [Tue Aug 30 14:24:52 2011] ARCHIVES table created... [Tue Aug 30 14:24:52 2011] LAYER_STATS table being created... [Tue Aug 30 14:24:52 2011] LAYER_STATS table created... [Tue Aug 30 14:24:52 2011] LOGFILE_POOL tables being created... [Tue Aug 30 14:24:53 2011] LOGFILE_POOL tables created... [Tue Aug 30 14:24:53 2011] DBTUNE table being created... [Tue Aug 30 14:24:53 2011] DBTUNE table created... [Tue Aug 30 14:24:53 2011] SERVER_CONFIG tables being created... [Tue Aug 30 14:24:53 2011] SERVER_CONFIG tables created... [Tue Aug 30 14:24:53 2011] DBMS stored procedures being created or updated... [Tue Aug 30 14:24:54 2011] DBMS stored procedures created or updated... [Tue Aug 30 14:24:54 2011] WARNING: Config parameter "B_CLUSTER_TO_DATE" not found in keyword "DEFAULTS". Inserting the default values. [Tue Aug 30 14:24:54 2011] WARNING: Config parameter "BLK_OUT_OF_ROW" not found in keyword "DEFAULTS". Inserting the default values. [Tue Aug 30 14:24:54 2011] WARNING: Config parameter "UI_TEXT" not found in keyword "SURVEY_MULTI_BINARY". Inserting the default values. [Tue Aug 30 14:24:54 2011] Successfully installed ArcSde.
[Tue Aug 30 14:24:55 2011] Successfully created GDB_Tables_Last_Modified table... [Tue Aug 30 14:24:59 2011] Successfully created GDB_Items table... [Tue Aug 30 14:24:59 2011] Successfully created GDB_ItemRelationships table... [Tue Aug 30 14:24:59 2011] Successfully created GDB_ItemTypes table... [Tue Aug 30 14:24:59 2011] Successfully created GDB_ItemRelationshipTypes table... [Tue Aug 30 14:25:00 2011] Successfully created GDB_ReplicaLog table...
After installing the ArcSDE 10 Service Pack 3, I was able to upgrade geodatabase in ArcCatalog. My ArcGIS Desktop was updated with ArcGIS 10 Service Pack 3 before I tried to upgrade geodatabase.
