DRG-10602 Failed To Queue DML Change To Column For Primary Key While Updating Text Indexed Table (Doc ID 1076551.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 08-Apr-2013***

Symptoms

An update to a table with a text index which name is 25 characters long and schema name is 15 characters long results in error:

ERROR at line 1:
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column B for primary key
AAASYeAABAAAVnxAAB
DRG-50857: oracle error in drekqkd (n_stmt)
ORA-06550: line 1, column 258:
PLS-00103: Encountered the symbol "TTH_MTV_RC1_ACT"
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 747


test case:

create user TTH_MTV_RC1_ACT
identified by TTH_MTV_RC1_ACT default tablespace SYSTEM temporary
tablespace TEMP quota unlimited on SYSTEM
/

grant connect, create procedure, create trigger, create table,
create type, create cluster, ctxapp to TTH_MTV_RC1_ACT;

conn TTH_MTV_RC1_ACT/TTH_MTV_RC1_ACT

create table foo (a number, b varchar2(30));

begin
for i in 1..10 loop
insert into foo values(i, 'aa bb cc dd');
end loop;
end;
/

create index EGPL_KB_INDEX_ON_ARTICLE5 on foo(b) indextype is ctxsys.context;

-- this update will fail with the same error
update foo set b ='xx yy zz' where a=2;


Output:

ERROR at line 1:
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column B for primary key
AAASYeAABAAAVnxAAB
DRG-50857: oracle error in drekqkd (n_stmt)
ORA-06550: line 1, column 258:
PLS-00103: Encountered the symbol "TTH_MTV_RC1_ACT"
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 747

Changes

Upgrade to 11.2

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