major problem during 3.0 upgrade to 4.0

[rodney]

upgrading crm 3.0 to 4.0 today, and it keep failing in the same spot.
its getting a little old to have to restore, and try once again.

here is a copy of the error log

16:43:56| Info| Changing ntext attributes to nvarchar(max)
16:43:56| Error| System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Data.SqlClient.SqlException: Cannot alter or drop column
'KeyWords' because it is enabled for Full-Text Search.
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.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.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase
database, String sql, Int32 timeout)
at
Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility
dbUtility)
at
Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseCollection
releases, Int32 currentProgress)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.installInternal()
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32
languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary
parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---, Error, RetryCancel, Option1
16:47:52| Info| InputResult: Retry
16:47:52| Info| Dropping v3 sql jobs
16:47:52| Info| Dropping v3 sql jobs
16:47:52| Info| Dropping v3 sql jobs
16:47:52| Info| Creating v3.0 metabase tables in database
16:47:52| Info| Creating v3.0 metabase tables in database
16:47:52| Info| Creating v3.0 metabase tables in database
16:47:52| Error| System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Data.SqlClient.SqlException: There is already an object named
'AttributeTypes' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.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.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase
database, String sql, Int32 timeout)
at
Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility
dbUtility)
at
Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseCollection
releases, Int32 currentProgress)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.installInternal()
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32
languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary
parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---, Error, RetryCancel, Option1
16:47:53| Info| InputResult: Cancel
16:47:53| Error| Install exception.System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Data.SqlClient.SqlException: There is already an object named
'AttributeTypes' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.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.Crm.Setup.Database.DatabaseUtility.ExecuteSql(InstallDatabase
database, String sql, Int32 timeout)
at
Microsoft.Crm.Setup.Database.SqlScriptAction.Execute(DatabaseUtility
dbUtility)
at
Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseCollection
releases, Int32 currentProgress)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.installInternal()
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32
languageCode, String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary
parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
at Microsoft.Crm.Setup.Server.DatabaseInstaller.Install(IDictionary
stateSaver)
at
Microsoft.Crm.Setup.Common.ComposedInstaller.InternalInstall(IDictionary
stateSaver)
at Microsoft.Crm.Setup.Common.ComposedInstaller.Install(IDictionary
stateSaver)
at Microsoft.Crm.Setup.Server.ServerSetup.Upgrade(IDictionary data)
at Microsoft.Crm.Setup.Server.ServerSetup.Run()
16:47:53| Info| Microsoft Dynamics CRM Server upgrade Failed.
16:47:53| Info| Microsoft Dynamics CRM Server Setup did not complete
successfully.

Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed.
There is already an object named 'AttributeTypes' in the database.

[rodney]

all set now, was able to get the problem resolved by completely removing
the ftcat file from SQL and alos remove the folder from the c drive,
then completely recreating the full text index... then i was able to
have a successful upgrade...

what a pain! wasted a beautiful weekend...