SDE v10 sp1 - Upgrade Geodatabase fails

[JasonMarshall]

I have SQL Server 2008 r2.

We are jumping to v10sp1 from 9.3.1.

Our databases have multiple user schemas - one for SDE and others for users. The user databases all contain spatial data. For example:

MyDatabase.UserA.SpatialLayer1
MyDatabase.UserA.SpatialLayer2
MyDatabase.UserA.SpatialLayer3
MyDatabase.UserB.SpatialLayer1
MyDatabase.UserB.SpatialLayer2
MyDatabase.UserB.SpatialLayer3
...etc...

I am attempting to use the "Upgrade Geodatabase" using the procedures described here:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Upgrading_an_ArcSDE_geodatabase_in_SQL...

The database is isolated on a test instance and no other users have access.

The results of the process has the following messages:


Executing: UpgradeGDB "Database Connections\MSSQL.sde" PREREQUISITE_CHECK UPGRADE
Start Time: Wed Dec 22 16:19:44 2010
Paused the database for upgrade.
There are no other active connections.
User has privileges required to upgrade.
Running Pre-Requisite check (C:\.....\Application Data\ESRI\Desktop10.0\ArcCatalog\MSSQL-D-TEMP - CSCDataV10.sde).
Instance supports XML type.
Checking datasets.
Checking dataset (s_CSCData.WEBMERC.IMG_FP).
Could not open object class (s_CSCData.WEBMERC.IMG_FP).
Invalid database name [s_CSCData.WEBMERC.IMG_FP][STATE_ID = 16]
Checking dataset (s_CSCData.WEBMERC.MISSIONS_FP).
Could not open object class (s_CSCData.WEBMERC.MISSIONS_FP).
Invalid database name [s_CSCData.WEBMERC.MISSIONS_FP][STATE_ID = 16]
Checking dataset (s_CSCData.S_CSCDATA.IMG_FP).
Could not open object class (s_CSCData.S_CSCDATA.IMG_FP).
Invalid database name [s_CSCData.S_CSCDATA.IMG_FP][STATE_ID = 16]
Checking dataset (s_CSCData.S_CSCDATA.MISSIONS_FP).
Could not open object class (s_CSCData.S_CSCDATA.MISSIONS_FP).
Invalid database name [s_CSCData.S_CSCDATA.MISSIONS_FP][STATE_ID = 16]
Checking dataset (s_CSCData.WEBMERC.MISSIONS_FP_Simplified93_5M).
Could not open object class (s_CSCData.WEBMERC.MISSIONS_FP_Simplified93_5M).
Invalid database name [s_CSCData.WEBMERC.MISSIONS_FP_Simplified93_5M][STATE_ID = 16]
Checked datasets.
Checking representations.
Checked representations.
Checking domains.
Checked domains.
Checking replicas.
Checked replicas.
Checking historical markers.
Checking historical marker (DEFAULT).
Check succeeded (DEFAULT).
Checked historical markers.
Finished checking prerequisites.
Updating ArcSDE server tables and stored procedures.
Could not update ArcSDE server tables and stored procedures.
Object was open.
Unpaused the database.
Failed to execute (UpgradeGDB).
Failed at Wed Dec 22 16:19:45 2010 (Elapsed Time: 1.00 seconds)




Any ideas?

[PrashantSingh]

Hi,

I saw a few instances wherein the database was upgraded even when an error message was encountered. Probably it was specific to a particular configuration (ArcSDE 10 + SQl 2008 R2 + Windows 2008) and ESRI might also have a bug logged for the issue.

Check the SDE_VERSION  table, does it still say 9.3.1? your case may be different ..just a guess.

Regards,

[VinceAngelo]

It looks as though this instance failed at validation, so it is unlikely to have been upgraded.
Do the WEBMERC.IMG_FP, WEBMERC.MISSIONS_FP, WEBMERC.MISSIONS_FP_Simplified93_5M,
S_CSCDATA.IMG_FP, and S_CSCDATA.MISSIONS_FP tables exist in the database?  If not, they
were likely deleted in a way that corrupted the geodatabase table registry.

The easiest way to address nominal corruption like this is to create tables of the same owner
and name (no need for more than a single INTEGER "objectid" column), then use ArcGIS to
delete the tables (and their metadata entries).  Once this is done, validation should succeeed,
and then the instance wil be viable for upgrade.

- V

[PrashantSingh]

Hey Vince,

I thought that begining ArcSDE 10, the prerquisite checks did not check for orphaned entries. I guess I heard this to be the case so just trying to clarify my doubt 🙂

Jason - Were you able to compress the database successfully to state 0 before trying to upgrade (not necessary but but always a good option to compress before upgrade)

You could also refer the following link (referring to Vince's suggestion)-
HowTo:  Clean up orphaned records in the SDE repository tables using ArcCatalog
http://resources.arcgis.com/content/kbase?fa=articleShow&d=34050

Regards

[TrentPell]

I had problems recently upgrading from 9.3.1 to 10sp1.  When I ran the upgrade it looks as if everything ran successfully it even showed as being upgraded in the sde_version table.  However, after the upgrade I could not get a direct or application connection to the geodatabase.  I received an error like this:

XML Parser initialization failed

Ended up having to delete the Database from SQL Server and restore from the backup made before upgrading.  The issue was resolved by uninstalling MSXML 4 SP2 from the client machine and upgrading that to MSXML 4 SP3.

[anthonysanchez]

sql_monkey,
when the environment was created, was it created from a backup/restore from another system?

If so, were the database names changed during restore?

-Anthony