Driving me nuts!! 
Author Message
 Driving me nuts!!

Hi all,

Am having this problem with incremental population in a full-text enabled
table in SQL7.0 SP3 FT enabled database.It was working fine till a month
ago.

These days the job is failing within 3 seconds.and no details are available
either in event viewer nor in the job history.

When I try to do either a full/incremental population OR even try to remove
FT indexing manually,it fails with an error message saying:

' Error 7608:An unknown full text failure(an 8 digit number) occured in
function (a functionname like crawlcatalog or removestartpage) on full-text
catalog 'catalogname' '

Now am unable to do anything with that.No rebuild index..no full/incremental
population and also not being able to remove it either .

The table has decimal value (5) with precision 7 as primary key which is
also the unique key for FT . And a total of 5 columns of total 88 stands for
the full-text indexes.I had a full catalog population way back in jun 2000
and since then the incremental population has been scheduled to work every
hour.Though the table doesnt have a timestamp datatype, it should do a full
population,right? But here the job fails within the first 3 seconds.I even
tried to make it work atleast once a day,but in vain .

I have posted this message before,but I dont know the whole of the group is
just afraid even to put forward a suggestion.
Pls help as the developers depend heavily on this index.
Sara.



Sun, 14 Sep 2003 23:27:53 GMT
 Driving me nuts!!

I seem to be having a similar problem.  Lots of ideas out there on how to
fix it.  Tried them all with no luck... check this out.  Ideas anyone?  I've
done just about everything but throw the server out the window and start
over from scratch.

03/28/2001 15:23:34

Event Class Text Start Time
+SQL:BatchStarting use [master] 15:25:02.183
+SQL:BatchStarting xp_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'FulltextDefaultPath'
15:25:02.183
+SQL:BatchStarting use [Operations] 15:25:04.450
+SQL:BatchStarting EXEC master.dbo.xp_fixeddrives 15:25:04.450
+SQL:BatchStarting set noexec off set parseonly off  15:25:04.497
+SQL:BatchStarting EXEC master.dbo.xp_fileexist N'D:\MSSQL7\FTDATA'
15:25:04.497
+SQL:BatchStarting set noexec off set parseonly off  15:25:04.513
+SQL:BatchStarting EXEC master.dbo.xp_getfiledetails N'D:\MSSQL7\FTDATA'
15:25:04.513
+SQL:BatchStarting set noexec off set parseonly off  15:25:04.543
+SQL:BatchStarting select DatabaseProperty( N'Operations',
N'isfulltextenabled' ) 15:25:04.543
+SQL:BatchStarting exec sp_fulltext_database N'enable'  15:25:04.560

Server: Msg 7608, Level 17, State 1, Procedure sp_fulltext_database, Line 37
An unknown full-text failure (80004005) occurred in function EnumCatalogs on
full-text catalog ''.

Line 37 of master/sp_fulltext_database:


Quote:
> Hi all,

> Am having this problem with incremental population in a full-text enabled
> table in SQL7.0 SP3 FT enabled database.It was working fine till a month
> ago.

> These days the job is failing within 3 seconds.and no details are
available
> either in event viewer nor in the job history.

> When I try to do either a full/incremental population OR even try to
remove
> FT indexing manually,it fails with an error message saying:

> ' Error 7608:An unknown full text failure(an 8 digit number) occured in
> function (a functionname like crawlcatalog or removestartpage) on
full-text
> catalog 'catalogname' '

> Now am unable to do anything with that.No rebuild index..no
full/incremental
> population and also not being able to remove it either .

> The table has decimal value (5) with precision 7 as primary key which is
> also the unique key for FT . And a total of 5 columns of total 88 stands
for
> the full-text indexes.I had a full catalog population way back in jun 2000
> and since then the incremental population has been scheduled to work every
> hour.Though the table doesnt have a timestamp datatype, it should do a
full
> population,right? But here the job fails within the first 3 seconds.I even
> tried to make it work atleast once a day,but in vain .

> I have posted this message before,but I dont know the whole of the group
is
> just afraid even to put forward a suggestion.
> Pls help as the developers depend heavily on this index.
> Sara.



Tue, 16 Sep 2003 04:07:37 GMT
 Driving me nuts!!
I seem to be having a similar problem.  Lots of ideas out there on how to
fix it.  Tried them all with no luck... check this out.  Ideas anyone?  I've
done just about everything but throw the server out the window and start
over from scratch.

03/28/2001 15:23:34

Event Class Text Start Time
+SQL:BatchStarting use [master] 15:25:02.183
+SQL:BatchStarting xp_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'FulltextDefaultPath'
15:25:02.183
+SQL:BatchStarting use [Operations] 15:25:04.450
+SQL:BatchStarting EXEC master.dbo.xp_fixeddrives 15:25:04.450
+SQL:BatchStarting set noexec off set parseonly off  15:25:04.497
+SQL:BatchStarting EXEC master.dbo.xp_fileexist N'D:\MSSQL7\FTDATA'
15:25:04.497
+SQL:BatchStarting set noexec off set parseonly off  15:25:04.513
+SQL:BatchStarting EXEC master.dbo.xp_getfiledetails N'D:\MSSQL7\FTDATA'
15:25:04.513
+SQL:BatchStarting set noexec off set parseonly off  15:25:04.543
+SQL:BatchStarting select DatabaseProperty( N'Operations',
N'isfulltextenabled' ) 15:25:04.543
+SQL:BatchStarting exec sp_fulltext_database N'enable'  15:25:04.560

Server: Msg 7608, Level 17, State 1, Procedure sp_fulltext_database, Line 37
An unknown full-text failure (80004005) occurred in function EnumCatalogs on
full-text catalog ''.

Line 37 of master/sp_fulltext_database:


Quote:
> Hi all,

> Am having this problem with incremental population in a full-text enabled
> table in SQL7.0 SP3 FT enabled database.It was working fine till a month
> ago.

> These days the job is failing within 3 seconds.and no details are
available
> either in event viewer nor in the job history.

> When I try to do either a full/incremental population OR even try to
remove
> FT indexing manually,it fails with an error message saying:

> ' Error 7608:An unknown full text failure(an 8 digit number) occured in
> function (a functionname like crawlcatalog or removestartpage) on
full-text
> catalog 'catalogname' '

> Now am unable to do anything with that.No rebuild index..no
full/incremental
> population and also not being able to remove it either .

> The table has decimal value (5) with precision 7 as primary key which is
> also the unique key for FT . And a total of 5 columns of total 88 stands
for
> the full-text indexes.I had a full catalog population way back in jun 2000
> and since then the incremental population has been scheduled to work every
> hour.Though the table doesnt have a timestamp datatype, it should do a
full
> population,right? But here the job fails within the first 3 seconds.I even
> tried to make it work atleast once a day,but in vain .

> I have posted this message before,but I dont know the whole of the group
is
> just afraid even to put forward a suggestion.
> Pls help as the developers depend heavily on this index.
> Sara.



Tue, 16 Sep 2003 04:07:37 GMT
 Driving me nuts!!

Hey Ken,Adam,

Thanks for putting forward suggestions.

Well I just sorted things out :-)The sqlservice was operating on sqlagent
acount which apparently had all privileges.One month back,a developer
changed the sqlserver account password in control panel,but i dont know
whether it was refected in MSSQL enterprise manager or not.But somehow the
increm.catalog just wont work.A while back, I changed the sqlservice account
from sqlagent to local system account and then the increm.pop started
working.Half way down, i had to revert back to sqlagent since the sqlmail
was not working with local system acccount.This time,correct password was
supplied for the account in SQL Entrp.manager .And voila! the increm.pop
worked as a beauty!

So what I conclude is may be a mismatch in the accounts in control panel and
sqlEnterp.manager.Anybody got any other thoughts?
From the number of emails I got, I feel many had experienced this problem
before.........

Hope this helps someone out there.....
Sara.



Tue, 16 Sep 2003 05:12:49 GMT
 Driving me nuts!!
AFAIK, you have to change account from EM to properly reflect that account change to
the MS Search service. Just to spell out exactly what (I think) happened.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.


Quote:

> Hey Ken,Adam,

> Thanks for putting forward suggestions.

> Well I just sorted things out :-)The sqlservice was operating on sqlagent
> acount which apparently had all privileges.One month back,a developer
> changed the sqlserver account password in control panel,but i dont know
> whether it was refected in MSSQL enterprise manager or not.But somehow the
> increm.catalog just wont work.A while back, I changed the sqlservice account
> from sqlagent to local system account and then the increm.pop started
> working.Half way down, i had to revert back to sqlagent since the sqlmail
> was not working with local system acccount.This time,correct password was
> supplied for the account in SQL Entrp.manager .And voila! the increm.pop
> worked as a beauty!

> So what I conclude is may be a mismatch in the accounts in control panel and
> sqlEnterp.manager.Anybody got any other thoughts?
> From the number of emails I got, I feel many had experienced this problem
> before.........

> Hope this helps someone out there.....
> Sara.



Tue, 16 Sep 2003 15:00:37 GMT
 Driving me nuts!!
Tibor,
I do agree with you.
MS KB also offers the same troubleshooting.Gosh!MSSQLserver shld have
mentioned a more user friendly error message rather than something like 'An
unknown full text failure occured in function blah blah.... '

Sara.



Tue, 16 Sep 2003 22:04:00 GMT
 Driving me nuts!!
Tibor,
I do agree with you.
MS KB also offers the same troubleshooting.Gosh!MSSQLserver shld have
mentioned a more user friendly error message rather than something like 'An
unknown full text failure occured in function blah blah.... '

Sara.



Tue, 16 Sep 2003 22:04:00 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. DTS from ASP security driving me nuts!

2. SQL Error 2417 driving me nuts

3. Triggers drive me NUTS!

4. I'm sure it something simple but it's driving me nuts :-(

5. Synax problem driving me nuts

6. HELP: isql is driving me nuts!

7. Index Tuning Wizard Driving me NUTS

8. Please Help, this is driving me nuts !!

9. SUB QUERY driving me NUTS!

10. This query is driving me nuts - please help !!

11. Stored Procedure Problem --- Driving me nuts!

12. HTTP 404 - File not found Driving me NUTS!!!!


 
Powered by phpBB® Forum Software