Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: Full Text Index not populating

    I have a table with 13,000,000 records. I want to generate a full-text index on one column (a varchar 2000). I am able to define the full-text index, but when I click on "Start Full population", there is virtually no activity (no disk activity, no CPU activity, very little to indicate anything is happening.

    When I check the properties of the catalog, it shows 1 MB size and 0 records in the catalog. The status of the catalog is "idle" and the display in EM shows that the last full population occurred at (about) the time that I generated the population request. I have generated the request by using EM (right click on table) and through SQL Agent with the same result (no catalog generated).

    I am running SQL 2000 (SP4) on Windows 2000 (SP4) with 4 GB RAM and sufficient disk space available. I have enabled the full-text service and verified that it is running (I have stopped and restarted it as well).

    I have worked with Full Text indexes before and never had any kind of issue before. Any thoughts or suggestions would be welcome.

    Regards,

    hmscott

    Code:
    CREATE TABLE [OMBRE_AUDIT_LOG] (
    	[LOG_SEQ_NBR] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
    	[APP_NAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    	[USER_ID] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    	[USER_ORGANIZATION] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    	[ACTION_START_DATE] [datetime] NOT NULL ,
    	[ACTION_END_DATE] [datetime] NULL ,
    	[ACTION_CODE] [int] NOT NULL ,
    	[VIEW_NAME] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    	[USER_DEF_TRACKING_NBR] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    	[CMD_XML_STREAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    	[REC_CREATE] [datetime] NULL CONSTRAINT [DF_OMBRE_AUDIT_LOG_REC_CREATE] DEFAULT (getdate()),
    	[REC_UPDATE] [datetime] NULL ,
    	[ATTENTION] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    	[REASON] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    	CONSTRAINT [PK_OMBRE_AUDIT_LOG] PRIMARY KEY  CLUSTERED 
    	(
    		[LOG_SEQ_NBR]
    	) 
    ) 
    GO
    Have you hugged your backup today?

  2. #2
    Join Date
    Jun 2003
    Posts
    269

    Thumbs up

    Poor scott ,

    Have u checked any errors in Microsoft Windows 2000 Event Viewer application log which related to Microsft Search?

    Another hint is ,

    Make sure that the BUILTIN\Administrators login exists in SQL Server.
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by mallier
    Poor scott ,
    I don't want sympathy, I want answers!!!

    Quote Originally Posted by mallier
    Have u checked any errors in Microsoft Windows 2000 Event Viewer application log which related to Microsft Search?
    Ding! Score 1 point for mallier!

    Quote Originally Posted by mallier
    Make sure that the BUILTIN\Administrators login exists in SQL Server.
    Ding! Ding! We have a winner!

    WTF? Best practice says remove the BUILTIN\Administrator account and yet it's required for this!?! I gotta go read up more on Full text.

    Thanks for the help!

    Regards,

    hmscott
    Have you hugged your backup today?

  4. #4
    Join Date
    Jun 2005
    Posts
    22
    Hi,
    I also got the same problem as you Scott.
    I found I have the BUILTIN\Administrator in SQL Server.

    So what will be the reason?

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    To access existing full-text search catalogs, rebuild and repopulate them. The existing catalogs can also be accessed by switching back to an administrator account.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Jun 2005
    Posts
    22
    Hi Satya,

    I have the exact problem as Scott, could you give me some idea how to solve the problem please?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •