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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms