|
Hi, I am working DO version 3.8.9.17096 on asp.net 3.5 web application. I am having a problem migrating a database from SQL2000 to SQL2005. I backup the database on SQL2000 and then Restore it on SQL2005. I was not using Full Text Catalog on SQL2000 but SQL2005 installs by default. When the domain builds I am getting an error indicating the Full Text Catalog already exist..This is true since I can see via SQL management studio. You see the error below. An intersting thing is if I create a brand new database on SQL2005 then the FT index gets created without any problems and can use the application without problems. The problem only happens when I restore the database from SQL2000 and try to run the application. I appreciate you collaboration on this matter. Thank you, Richard -------------------------------------------- A full-text catalog named 'VO' already exists in this database. Use a different name. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: A full-text catalog named 'VO' already exists in this database. Use a different name. Source Error: Line 128: { Line 129: //domain.Build(DomainUpdateMode.Recreate); Line 130: domain.Build(DoUtils.GetDomainUpdateMode()); Line 131: } Line 132: Source File: e:WebSitesVOApp_CodeGlobal.asax.cs Line: 130 Stack Trace: [SqlException (0x80131904): A full-text catalog named 'VO' already exists in this database. Use a different name.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1099 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +2858575 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +470 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +182 DataObjects.NET.Domain.UpdateDatabase(DomainBuildContext context, DomainUpdateMode updateMode) +2055 DataObjects.NET.Domain.Build(DomainUpdateMode updateMode) +2353 [DomainConstructionException: Domain construction error. Inner exception: System.Data.SqlClient.SqlException: A full-text catalog named 'VO' already exists in this database. Use a different name.] DataObjects.NET.Domain.Build(DomainUpdateMode updateMode) +5581 VirtualOffice.Global.Application_Start(Object sender, EventArgs e) in e:WebSitesVOApp_CodeGlobal.asax.cs:130 [ApplicationException: Domain is inaccessible - application startup process wasn't completed successfuly. Fix the problem and run 'iisreset' command from server console to restart the application. The following exception was thrown on application startup: DataObjects.NET.Exceptions.DomainConstructionException: Domain construction error. Inner exception: System.Data.SqlClient.SqlException: A full-text catalog named 'VO' already exists in this database. Use a different name.] VirtualOffice.Global.Application_Start(Object sender, EventArgs e) in e:WebSitesVOApp_CodeGlobal.asax.cs:154 |
|
Hi Alex, Actually I tried to do that but I got another error..sorry don't have the exact message.. To resolve the problem I had to do these steps. 1) Set the database compatibily level to SQL2005 2) Delete and recreate the FT index via the management studio. 3) Tried creating the FT index but I got and errpr message that I needed to backup the transaclog before it would let me create the FT index. 4) Backup the Database transaction log 5) Create FT index 6) Set the dbo.doFTRecord table in FTIndex 7) In DataObjects set domain.TransactionalUpdate = false during the creation of the domain. I don't know if this was the easiest path to solve the problem but it work for me. Thanks, Richard |
Did you try to remove FT catalog after restoring database? In this case DataObjects will create and populate a new one from scratch. I think this would resolve the problem.