Re: FTS 2005 system exception c0000005 every few seconds



What are the contents of the document type extension column? They should be
pdf or .pdf. There is no program I know of which could spider the database
and check the validity of the PDFs. You would have to extract them and then
open them up using acrobat.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"phf" <phf@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9BE4E7FA-BED8-4374-A4A5-90B17D93B1E0@xxxxxxxxxxxxxxxx
We also receive this error. We're using a Program that imports all files
as
blobs into a SQL 2005 database ( www.columbiasoft.com ) and on importing
the
files (which contain 60 gigs worth of pdf's and docs and other document
types) we get this message.

How would I determine what problem PDF's are causing this? Is there a
program that can spider a drive and "validate" the PDF's to work? We do
use
a lot of foreign language PDF's and early version (i.e. version 1.1
PDF's.)



"Hilary Cotter" wrote:

can you post a problem PDF here, or email one to me offline?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



<roenepoen@xxxxxxxxxxx> wrote in message
news:1147166983.570391.107870@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
L.S.

While running a full population on a full-text index the following
message keeps coming almost every second in the Event Log:

Event Type: Error
Event Source: MSFTESQL$SQLEXPRESS
Event Category: MSFTESQL Service
Event ID: 1053
Date: 5/9/2006
Time: 10:44:51 AM
User: N/A
Computer: SVR-PROD1
Description:
The system exception c0000005 was raised at 0232A3C5. Stack:

I am indexing on an image field containing pdf files. And yes, I have
installed the Adobe IFilter and on other tables, similar in layout, it
works better. Then only once in a while the above message pops up.

Any help will be appreciated...

Jeroen
Netherlands






.



Relevant Pages

  • Re: Problem with SQL2005 and pdf Filter 6.0
    ... I tried with Varchar: ".pdf" too, ... "Hilary Cotter" wrote: ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problem with SQL2005 and pdf Filter 6.0
    ... What is the value of your document type column for the pdfs? ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... I can see the .pdf extension in the table sys.fulltext_document_types ...
    (microsoft.public.sqlserver.fulltext)

Loading