I get the error Action 4.0.100.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed to rollback. Find below some of the log file STSADM] [SPContentDatabaseSequence] [ERROR] [4/19/2012 9:49:19 AM]: Exception: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.AllDocStreams' and the index name 'AllDocStreams_CI'. The duplicate key value is (47e5bede-f234-497f-a67e-8e43af904fc7, d81baa35-cb97-4919-84ce-cea9fbecf804, 257). The statement has been terminated. [STSADM] [SPContentDatabaseSequence] [INFO] [4/19/2012 9:49:19 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPContentDatabaseSequence] [ERROR] [4/19/2012 9:49:19 AM]: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.ExecuteDataDefinitionMethodCore(SqlSession sqlSession, ISqlSession isqlSession, String sqlscript, SPLog log) at Microsoft.SharePoint.Upgrade.UpgradeAllDocStreamsSize.Upgrade() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() [STSADM] [SPContentDatabaseSequence] [INFO] [4/19/2012 9:49:19 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPContentDatabaseSequence] [ERROR] [4/19/2012 9:49:19 AM]: Action 4.0.100.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed to rollback. [STSADM] [SPContentDatabaseSequence] [INFO] [4/19/2012 9:49:19 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPContentDatabaseSequence] [ERROR] [4/19/2012 9:49:19 AM]: Exception: This SqlTransaction has completed; it is no longer usable. [STSADM] [SPContentDatabaseSequence] [INFO] [4/19/2012 9:49:19 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPContentDatabaseSequence] [ERROR] [4/19/2012 9:49:19 AM]: at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback(String transactionName) at Microsoft.SharePoint.Utilities.TransactionalSqlSession.Rollback() at Microsoft.SharePoint.Upgrade.SPDatabaseAction.Rollback() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() [STSADM] [SPUpgradeSession] [INFO] [4/19/2012 9:49:23 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPUpgradeSession] [ERROR] [4/19/2012 9:49:23 AM]: Upgrade [SPContentDatabase Name=WSS_Content] failed. [STSADM] [SPUpgradeSession] [INFO] [4/19/2012 9:49:23 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPUpgradeSession] [ERROR] [4/19/2012 9:49:23 AM]: Inner Exception: This SqlTransaction has completed; it is no longer usable. [STSADM] [SPUpgradeSession] [INFO] [4/19/2012 9:49:23 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPUpgradeSession] [ERROR] [4/19/2012 9:49:23 AM]: at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Rollback(String transactionName) at Microsoft.SharePoint.Utilities.TransactionalSqlSession.Rollback() at Microsoft.SharePoint.Upgrade.SPDatabaseAction.Rollback() at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() [STSADM] [SPUpgradeSession] [INFO] [4/19/2012 9:49:23 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPUpgradeSession] [ERROR] [4/19/2012 9:49:23 AM]: Exception: Action 4.0.100.0 of Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence failed to rollback. [STSADM] [SPUpgradeSession] [INFO] [4/19/2012 9:49:23 AM]: SPContentDatabase Name=WSS_Content [STSADM] [SPUpgradeSession] [ERROR] [4/19/2012 9:49:23 AM]: at Microsoft.SharePoint.Upgrade.SPActionSequence.Upgrade() at Microsoft.SharePoint.Upgrade.SPDatabaseSequence.Upgrade() at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.Upgrade() at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)

Hi, Have you run stsadm -o preupgradecheck on the SP2007 environment prior to upgrade? If so did you clean up all of the issues, if not please do so and let us know what you find? Sounds like it may be an Orphaned Object but I have never had this specific issue. -IvanIvan Sanders My LinkedIn Profile, My Blog, @iasanders.