FTS 2005 system exception c0000005 every few seconds

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

roenepoen@hotmail.com - 09 May 2006 10:29 GMT

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

Reply to this Message

Hilary Cotter - 09 May 2006 23:47 GMT

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

Signature

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

> L.S.
>
[quoted text clipped - 20 lines]
> Jeroen
> Netherlands

Reply to this Message

phf - 22 Sep 2006 18:06 GMT

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.)

> can you post a problem PDF here, or email one to me offline?
>
[quoted text clipped - 22 lines]
> > Jeroen
> > Netherlands

Reply to this Message

Hilary Cotter - 23 Sep 2006 02:33 GMT

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.

Signature

> We also receive this error. We're using a Program that imports all files
> as
[quoted text clipped - 35 lines]
>> > Jeroen
>> > Netherlands

Reply to this Message