ORA-00600 qesmaGetDomIdxSeg1 on text query (Doc ID 2296312.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Query on context index (contains)

When attempting to

select
MO.BUS_PROTOCOL_STATUS,
MO.CLIENT_ID, MO.CREATED,
CASE WHEN MO.PAYLOAD_FILENAME IS NULL THEN MO.FILENAME ELSE MO.PAYLOAD_FILENAME END AS FILENAME,
MO.HASHVALUE, MO.ID, MO.IS_CONTAINER, MO.MESSAGE_UUID, MO.OUTPUTENDPOINT_ID, MO.PARENT_UUID,
MO.PAYLOADFORMAT_ID, MO.PROCESSING_STATUS, MO.PROCESSTYPE_ID, MO.MESSAGETYPE_ID, MO.RESEND_COUNTER,
MO.STATUS, MO.SUMAMOUNT, MO.SYN_PROTOCOL_STATUS, MO.TRANSACTIONS, MO.TYPE, MO.HEADER, MO.INCOMING_PROTOCOL_STATUS,
MO.INCOMING_PROTOCOL_TIMEOUT, MO.UUID, MOP.FILENAME AS MOP_CONTAINERFILENAME
from PMT_MESSAGEOUTPUT MO
left outer join PMT_MESSAGE M on M.UUID = MO.MESSAGE_UUID and M.CREATED = MO.CREATED
left outer join PMT_MESSAGEOUTPUT MOP on MO.IS_CONTAINER = 0 AND MOP.UUID = MO.PARENT_UUID and MOP.CREATED = MO.CREATED
WHERE contains(m.status, '( 1 WITHIN (CLIENT_ID) OR EMPTY WITHIN (CLIENT_ID) ) AND SDATA(CREATED <= "2017-08-08 23:59:00") AND 12 WITHIN (OUTPUTENDPOINT_ID)', 1) > 0
AND MO.OUTPUTENDPOINT_ID = 12 order by MO.created DESC

the following error occurs.

ERROR
-----------------------
ORA-00600: Interner Fehlercode, Argumente: [qesmaGetDomIdxSeg1], [4294967295], [8], [], [], [], [], [], [], [], [], []

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