My Oracle Support Banner

DRG-11611: URL store: unknown protocol specified in (Doc ID 1359022.1)

Last updated on JANUARY 08, 2014

Applies to:

Oracle Text - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Jan-2014***

Symptoms

Creating a Text index on a table completed without errors.

SQL> create table url_test (id number, url_string varchar2(100));

Table created.

SQL> insert into url_test values (101, NULL);

1 row created.

SQL> insert into url_test values (201,' ');

1 row created.

SQL> insert into url_test values (301,'');

1 row created.

SQL> commit;

Commit complete.

SQL> exec ctx_ddl.create_preference('URL_PREF','URL_DATASTORE');

PL/SQL procedure successfully completed.

SQL> exec ctx_ddl.set_attribute('URL_PREF','HTTP_PROXY','xxx.oracle.com');

PL/SQL procedure successfully completed.

SQL> create index datastores_text on url_test ( url_string )
  2   indextype is ctxsys.context
  3   parameters ('datastore URL_PREF');

Index created.


But ctx_user_index_errors show DRG-11611 were generated while indexing.

SQL> select * from ctx_user_index_errors;

ERR_INDEX_NAME  ERR_TIMES ERR_TEXTKEY        ERR_TEXT
--------------- --------- ------------------ ------------------------------
DATASTORES_TEXT 15-SEP-11 AAAXmmAAEAAAAKnAAA DRG-11611: URL store: unknown
                                             protocol specified in
DATASTORES_TEXT 15-SEP-11 AAAXmmAAEAAAAKnAAB DRG-11611: URL store: unknown
                                             protocol specified in
DATASTORES_TEXT 15-SEP-11 AAAXmmAAEAAAAKnAAC DRG-11611: URL store: unknown
                                             protocol specified in


The ROWID showed which row(s) generated the errors.

SQL> select rowid,u.* from url_test u;

ROWID              ID   URL_STRING
------------------ ---- --------------------
AAAXmmAAEAAAAKnAAA 101
AAAXmmAAEAAAAKnAAB 201
AAAXmmAAEAAAAKnAAC 301

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.