Re: 9i Intermedia Text ORA-03113 when indexing PDF documents

After some reading and research, i found one cause of this problem, and the corresponding workaround.

The error is caused by a timeout during document filtering. According to the Oracle documentation, this shouldn't cause such an ORA-03113 error, so there's maybe a bug somewhere. The workaround is to disable the timeout.

"The INSO_FILTER document filter has a new timeout attribute that allows you to specify the maximum time Oracle waits for a document to be filtered during
indexing. You can use this mechanism to avoid hanging during the index operation." [Oracle 9i Text Reference - Release 9.0.1, p.xxviii]

"Default is 120. Setting this value 0 disables the feature. This value is the time Oracle waits for the INSO_FILTER to start writing filtered output for a document row. If this time is reached and the INSO_FILTER has not started to write output, the indexing operation terminates for the document row and an error is recorded in the CTX_USER_INDEX_ERRORS view. Oracle moves to the next document row to be indexed." [Oracle 9i Text Reference - Release 9.0.1 p.2-26]

Here is an example of using this timeout feature:

BEGIN
  ctx_ddl.create_preference ('NO_TIMEOUT_FILTER', 'INSO_FILTER');   ctx_ddl.set_attribute ('NO_TIMEOUT_FILTER','timeout',0); END;
/
alter index documents_text_cx rebuild parameters ('FILTER NO_TIMEOUT_FILTER'); "Achille Carette" <acarette_nospam_at_aprico-consult.com> wrote in message news:3c502c97$0$75157$ba620e4c_at_news.skynet.be...
> Oracle 9.0.1.1 / Win2000 SP2
>
> I'm trying to create an index on a column containing PDF files, using the
> CREATE INDEX DOCUMENTS_TEXT_CX ON DOCUMENTS(TEXT) INDEXTYPE IS
> CTXSYS.CONTEXT. The TEXT column contains a PDF file. For some documents, i
> get the ORA-03113: end-of-file on communication channel error.
>
> The CREATE INDEX column launches ctxhx for each row. I tried to run ctxhx
> alone, and it runs just fine.
>
> I don't have any problem with other formats, as MS Word or PowerPoint.
>
> Any idea ?
>
> Thanks in advance,
>
> Achille
>
>
Received on Mon Jan 28 2002 - 03:15:05 CST