Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
What is the AW2008FullTextCatalog on database AdventureWorks2008R2?

Frage What is the AW2008FullTextCatalog on database AdventureWorks2008R2?

  • Friday, September 14, 2012 6:40 PM
     
     
    Sign In to Vote
    0

    To run the sample MSDN walkthrough samples, e.g.http://msdn.microsoft.com/en-us/library/bb470363.aspx,
    I have installed the new Microsoft database, AdventureWorks2008R2.   Yesterday, our system admin showed
    me an error on this database. The ASP.NET 4.0 website has a LinqDataSource and a GridView control.

    I don't remember I coded any FullText searching on any ASP.NET web sites. Reviewing the database on SQL
    Server Management Studio showed the AW2008FullTextCatalog in the Storage folder.

    How was the AW2008FullTextCatalog created?  Can I delete it?

    *******************************************************************************
    The error in the Event Viewer logs.

    Event Type:   Error
    Description: A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is AdventureWorks2008R2 (id: 30); catalog name is AW2008FullTextCatalog (id: 5); table name JobCandidate (id: 1333579789). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.

    Jeffrey

     

All Replies

  • Friday, September 14, 2012 8:01 PM
     
     
    Sign In to Vote
    0

    It seems your FTS catalog population stopped by some issue.

    1) Check FTS services is runing or not

    2) Try to rebuild catalog by - ALTER FULLTEXT CATALOG ftCatalog REBUILD

    refer link : http://msdn.microsoft.com/en-us/library/ms176095(v=sql.105).aspx

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

     
  • Saturday, September 15, 2012 3:52 PM
     
     
    Sign In to Vote
    0
    Thanks.

    Just learned that it requires FullText feature in order to install the AdventureWorks2008R2 database.
    In fact, I do not need to use FullText feature for my ASP.NET 4 web sites.  Therefore, I just deleted
    the AW2008FullTextCatalog.

    We are still using the Windows Server 2003.  Is this the reason for this FullText error with the
    AdventureWorks2008R2 database?   We will upgrade to Windows 2008 soon.  In other words,
    we should not use AdventureWorks2008R2 on Windows Server 2003!?

    Jeffrey

     
  • Monday, September 17, 2012 5:56 PM
     
     
    Sign In to Vote
    0

    How to drop the fts catalog for this databse ?

    Run below query & sahre the details, if any output recived.

    USE <DBNAME>
    GO
    select * from sys.sysfulltextcatalogs

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.