Closed the issue status before technical support answer me....sql server 2005 Full text search

Ticket #: 999136
Department: Support
Status: Open

Subject: problem with full text search sql server 2005





From: [email protected]
11/29/2007 2:14:05 PM


I am getting the following error, please help me. I have demo for my project otherwise i will be BIG trouble


Full-text catalogs can be scheduled for population by sysadmins or members of the SQLAgentUserRole only. (SqlManagerUI)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.FullTextCatalogPropertiesSchedule.Microsoft.SqlServer.Management.SqlMgmt.IPanelForm.OnInitialization()
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.SetView(Int32 index, TreeNode node)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.OnBeforeSelection(Object sender, TreeViewCancelEventArgs e)



From: [email protected]
11/29/2007 2:18:40 PM


I am issuing the following
SQL Server Management Studio, giving problem. Plz help me urgent.
EXEC sp_fulltext_catalog 'FTCatalogCndtResume', 'start_full';

Warning: Request to start a full-text index population on table or indexed view 'dbo.cndt_prof' is ignored because a population is currently active for this table or indexed view.




From: [email protected]
11/29/2007 2:19:00 PM


Dear Customer,

Please provide us with a URL or a detailed explanation of how we can replicate this issue.

- Mike O.

DiscountASP.NET - Microsoft Gold Certified Partner
- asp.netPRO Magazine 2007 Readers' Choice Award for Best Hosting Service
- Visual Studio Magazine 2007 Readers' Choice Award for Best Hosting Service



From: [email protected]
11/29/2007 2:25:58 PM


Dear Customer,

Please refer to the following article regarding full text searches.
http://kb.discountasp.net/article.aspx?id=10467


- Mike O.

DiscountASP.NET - Microsoft Gold Certified Partner
- asp.netPRO Magazine 2007 Readers' Choice Award for Best Hosting Service
- Visual Studio Magazine 2007 Readers' Choice Award for Best Hosting Service



From: [email protected]
11/30/2007 5:39:05 AM


Let me explain whats problem i am faacing.

I was using Sql server 2000, 2 days back I migrated to Sql server 2005. Previously in Sql server 2000 database I had Full Text Catalog and table with image datatype. Because poor performances I would like to migrated to Sql server 2005.

Tell me explain how I did in detail,
1) log into the control panel and create a backup of the SQL 2000 database 2)Add the SQL 2005 service if you have not done so and use the SQL 2005 Retore Tool
3) enter the name of the SQL 2000 database backup file create in step 1
4) make sure that database is working and objects transferred
5) send an email to support to cancel the SQL 2000 service

AS of now everything went fine.
Now I connected the remote Sql server 2005. I got all objects and Full Text Catalog but here is THE PROBLEM, the Full Text Catalog -- catalog size is 0 (i mean not populated). So I removed and tried once again with following steps..

1) Authenticate against the SQL Server and scroll to your database
2) Expand the Storage Folder, right click "Full text Catalogs," "Create New"
3) Enter only Full-text Catalog Name and owner fields and select its options
4) Right-Click created catalog
5) Select "Properties," select "Tables/Views," assign table/views to catalog
6) Click Ok

Everything went fine, but Once again catalog size is 0

Important note: here my table structure...

CREATE TABLE [dbo].[cndt_prof](
[id_prof] [int] IDENTITY(1,1) NOT NULL,
[id_user] [int] NOT NULL,
[name_prof] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[doc_name] [varchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[document] [image] NULL,
[doctype] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[docuid] [uniqueidentifier] NULL,
[val_srch_type] [tinyint] NOT NULL,
[dt_prof_creatn] [datetime] NOT NULL,
[dt_lst_prof_updt] [datetime] NOT NULL,
[val_prof_loc] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[doc_file_extn] [char](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_cndt_prof_doc_file_extn] DEFAULT ('log'),
PRIMARY KEY CLUSTERED
(
[id_prof] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


TABLE HAS ONLY ONE RECORD...EVEN ITS ONLY SMALL DOCUMENT SIZE AS 25 KB.

SELECT * FROM CNDT_PROF
WHERE CONTAINS(DOCUMENT,'"ASP.NET"')
its not fetching any records......I am very much fraustrated..and may be i will be in big trouble about my work..Please help man...

Could you run this from your side
exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
go
I have local server, its showing path to all doc types, but when I try with discountasp.net its showing NULL so I think thats the problem...
for your refenercces plz have a look so you will understand what I mean
http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/
I guess problem with IFilters ...

Server Name: sql2k510.discountasp.net
Dabasebase name: SQL2005_366039_arc
table name: cndt_prof
Full text object name: CandidateResumeSearch

Record in the table
23 12 Resume1 BhuppalKumar(MCAD).doc application/msword 6f9ec925-8a9f-496f-bdd1-ed5c8fc7eeca 1 11/27/2007 11:05:39 AM 11/27/2007 11:05:39 AM log

Tell me what more details you want from me to help me...I beg you man...otherwise I will be big trouble...for my job..I only recommended to use www.discountasp.net but now I am in big trouble plz help me

Plz call me 571-217-9991 if you wish










From: [email protected]
11/30/2007 5:49:34 AM


Dear Customer,

You cannot upload a db backup on our server with indexing enabled on it. The backup you restored on our server appears to not have the Full Text Catalog on it. What you will need to do is recreate the index on our SQL 2005 server and recreate the full text index using SQL Server Management Studio.

Thank you,

Raymond

DiscountASP.NET - Microsoft Gold Certified Partner
- asp.net PRO Magazine 2007 Readers' Choice Award for Best Hosting Service
- Visual Studio Magazine 2007 Readers' Choice Award for Best Hosting Service



From: [email protected]
11/30/2007 5:55:06 AM


Hi Raymond,

Let me try and get back to you.
Thanks so much for your quick reply
Thanks
Bhuppal



From: [email protected]
11/30/2007 7:44:30 AM


Hi Raymond,

Once again I started from the begin.
Sucessfully restore from sql server 2000 to 2005.
Drop table cndt_prof and again created table cndt_prof on which I am going to Full Text Search.
Followed as per instructions, created sucessfully.
1) Authenticate against the SQL Server and scroll to your database
2) Expand the Storage Folder, right click "Full text Catalogs," "Create New"
3) Enter only Full-text Catalog Name and owner fields and select its options
4) Right-Click created catalog
5) Select "Properties," select "Tables/Views," assign table/views to catalog
6) Click Ok

The table cndt_prof don;t have any records...before I insert any record, I issued the following
SELECT fulltextcatalogproperty('c1', 'PopulateStatus')
Its showing "1" value for long time.

Could you find that whatever I am doing is right with my database. Same process I was trying and trying for loong time man...Plz help me

my question, when the Population process going to stop, I am sure that table cndt_prof does not have any record and why its taking tooo much time for start population.
I am sure whenever I use CONTAINS no record

select * from cndt_prof
where containts(document,'"ASP.NET"')
No records...plz help me.

If you need any further details plz reply me idly..waiting for your reply

Thanks




From: [email protected]
11/30/2007 8:26:30 AM


Waiting for your reply...plz help me. Its urgent and production issue for me.

Thanks
Bhuppal



From: [email protected]
11/30/2007 8:42:30 AM


I feel this is the problem, When I try local server its working fine but not with discountasp.net plz make confirm that when you issue following command, all the filetype have respective path value.

exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
go

I tried local server with the following command,
ITS WORKING FINE IN LOCAL SERVER
CREATE DATABASE SAMPLE

USE SAMPLE

CREATE TABLE [dbo].[Doc] (
[ID] uniqueidentifier ROWGUIDCOL NOT NULL ,
[Extension] [varchar] (10) NOT NULL ,
[Content] [image] NOT NULL ,
[FileSize] [int] NOT NULL ,
[FileName] [nvarchar] (500) NOT NULL ,
[Stamp] [timestamp] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


ALTER TABLE [dbo].[Doc] WITH NOCHECK ADD
CONSTRAINT [PK_Doc] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO


ALTER TABLE [dbo].[Doc] ADD
CONSTRAINT [DF_Doc_ID] DEFAULT (newid()) FOR [ID]
GO

exec sp_fulltext_database N'enable'



if not exists (select * from dbo.sysfulltextcatalogs where name = N'Doc')
exec sp_fulltext_catalog N'Doc', N'create'
GO

exec sp_fulltext_table N'[dbo].[Doc]', N'create', N'Doc', N'PK_Doc'
GO

exec sp_fulltext_column N'[dbo].[Doc]', N'Content', N'add', 1033, N'Extension'
GO

exec sp_fulltext_table N'[dbo].[Doc]', N'activate'
GO


INSERT INTO [DOC] ([Extension], [Content], [FileSize], [FileName])
VALUES ('.txt', 'Hello John! It''s me: Garfield!', 30, 'Cartoon1.txt')

INSERT INTO [Doc] ([Extension], [Content], [FileSize], [FileName])
VALUES ('.txt', 'Oh my god!', 30, 'Shout.txt')

INSERT INTO [DOC] ([Extension], [Content], [FileSize], [FileName])
VALUES ('.txt', 'NOWANs web site: <A href="http://www.nowan.hu/">http://www.nowan.hu/</A>', 30, 'nowan.txt')


SELECT * FROM ContainsTable([doc], Content, '"nowan"')

SELECT Doc.* FROM [Doc]
INNER JOIN ContainsTable([doc], Content, '"nowan"') AS FT
ON Doc.ID = FT.[Key]


SELECT * FROM DOC
WHERE CONTAINS(CONTENT,'"NOWAN"')


but NOT with discountasp.net server.
If you need any further details let me ....I am dieing there man



From: [email protected]
11/30/2007 8:46:15 AM


I am sure that I could not able to do population for my catalog
I am getting this error
Full-text catalogs can be scheduled for population by sysadmins or member of the SQLAgentUserRole only.(SqlManagerUI)

Plz help me I hope that if I can able to populate then I can fetch rows

I will be tring and tring help me my man
Thanks
Bhuppal



From: [email protected]
11/30/2007 9:22:16 AM


Dear Customer,

Your ticket is being escalated. Someone will reply to you as soon as possible.

- Mike O.

DiscountASP.NET - Microsoft Gold Certified Partner
- asp.netPRO Magazine 2007 Readers' Choice Award for Best Hosting Service
- Visual Studio Magazine 2007 Readers' Choice Award for Best Hosting Service



From: [email protected]
11/30/2007 9:27:48 AM


Hello Mike,

Thanks for your reply, Plz work with my database and give some positive result...I am almost dead

Thanks
Bhuppal



From: [email protected]
11/30/2007 11:23:38 AM


Dear Bhuppal,

can you please advise if you grant us permission to purge and recreate the indexes in your database. We want to purge them so that awe are able repopulate them as we are not able to do so at the moment.


Thank you,
Jorge

DiscountASP.NET - Microsoft Gold Certified Partner
- asp.netPRO Magazine 2007 Readers' Choice Award for Best Hosting Service
- Visual Studio Magazine 2007 Readers' Choice Award for Best Hosting Service




From: [email protected]
11/30/2007 12:24:28 PM


I would like to know the reason why i am not able to do full text search with my sql server 2005. I gave all my information about the problem.
I am still waiting for the reply.
Don't close the issue, before you gave preoper explanation.

Thanks
Bhuppal