Hello, While trying to attach the database to SharePoint 2007 after running successful PreScan on site, it gives below error on upgrade.log: [DocsUserDataUnificationPhase1] [3.0.21.0] [DEBUG] [7/12/2010 12:13:10 PM]: SqlCommand.CommandTimeout = 0 [SPContentDatabaseSequence] [ERROR] [7/12/2010 12:13:35 PM]: Action 3.0.21.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed. [SPContentDatabaseSequence] [ERROR] [7/12/2010 12:13:35 PM]: Cannot insert the value NULL into column 'tp_DirName', table 'MDshareai.dbo.AllUserData'; column does not allow nulls. UPDATE fails. [SPContentDatabaseSequence] [ERROR] [7/12/2010 12:13:35 PM]: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) [DocsUserDataUnificationPhase1] [3.0.21.0] [DEBUG] [7/12/2010 12:13:35 PM]: Begin Rollback() [SPContentDatabaseSequence] [ERROR] [7/12/2010 12:13:35 PM]: Action 3.0.21.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed to rollback. [SPContentDatabaseSequence] [ERROR] [7/12/2010 12:13:35 PM]: This SqlTransaction has completed; it is no longer usable. [SPContentDatabaseSequence] [ERROR] [7/12/2010 12:13:35 PM]: at System.Data.SqlClient.SqlTransaction.ZombieCheck() [DocsUserDataUnificationPhase1] [3.0.21.0] [DEBUG] [7/12/2010 12:13:35 PM]: Begin Dispose() [DocsUserDataUnificationPhase1] [3.0.21.0] [DEBUG] [7/12/2010 12:13:35 PM]: End Dispose() [DocsUserDataUnificationPhase1] [3.0.21.0] [DEBUG] [7/12/2010 12:13:35 PM]: Elapsed time: 00:05:57.9752106. [SPManager] [ERROR] [7/12/2010 12:13:35 PM]: Upgrade [SPContentDatabase Name=MDshareai Parent=SPDatabaseServiceInstance] failed. [SPManager] [ERROR] [7/12/2010 12:13:37 PM]: This SqlTransaction has completed; it is no longer usable. [SPManager] [ERROR] [7/12/2010 12:13:37 PM]: at System.Data.SqlClient.SqlTransaction.ZombieCheck() [SPManager] [ERROR] [7/12/2010 12:13:37 PM]: Action 3.0.21.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed to rollback. [SPManager] [ERROR] [7/12/2010 12:13:37 PM]: at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() [SPManager] [DEBUG] [7/12/2010 12:13:37 PM]: Elapsed time upgrading [SPContentDatabase Name=MDshareai Parent=SPDatabaseServiceInstance]: 00:08:48. [SPManager] [INFO] [7/12/2010 12:13:37 PM]: Resetting the status of PersistedUpgradableObject: SPContentDatabase Name=MDshareai Parent=SPDatabaseServiceInstance to Online. [SPManager] [DEBUG] [7/12/2010 12:13:37 PM]: Using cached [SPContentDatabase Name=MDshareai Parent=SPDatabaseServiceInstance] NeedsUpgrade value: True. [SPManager] [INFO] [7/12/2010 12:13:40 PM]: Inplace Upgrade session finishes. root object = SPContentDatabase Name=MDshareai Parent=SPDatabaseServiceInstance, recursive = False. 123 errors and 0 warnings encountered. I could not find much info.. Has anyone seen anything like this? Thanks in advance.

Hi PureLife, From your post, most likely that there is orphans in the SPS 2003 environment. First, run the following command to check whether you can get orphan count: stsadm -o databaserepair -url <http://URLofWindowsShwerePointServicesSite> -databasename DatabaseName If the orphan count is more than 0, run the command again with deletecorruption to remove the orphan entry. stsadm -o databaserepair -url <http://URLofWindowsShwerePointServicesSite> -databasename DatabaseName -deletecorruption Repeat the process until you see 0 orphan count. Run the prescan tool on the database, if it is successful, then attach the database to the new farm by running this command: Stsadm -o addcontentdb -url http://<servername> -databasename <databasename> Regards, Rock Wang Microsoft Online Community Support

I already tried that and there is no orphan. Anyway, I got the solution. Instead of backup/restore site to our dev envrionment I copied whole database and it worked fine.. no error after that. But please do let me know if you have any other tricks to check/remove the orphans from database. Thanks for you help.