Crawl Fails With ORA-00904 Exception

(Doc ID 2040300.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Secure Enterprise Search - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.2.2.0 version,

The crawl schedule for SES source fails with the following error
 

[2015-07-06T09:28:43.300+02:00] [search] [ERROR] [EQG-30724] [oracle.search] [tid: main] [ecid: 0000KtYH4yrEgKo_OTXBid1LaYsc000001,0] Invalid SQL command: eq_task.start_tasks
[2015-07-06T09:28:43.301+02:00] [search] [ERROR] [] [oracle.search] [tid: main] [ecid: 0000KtYH4yrEgKo_OTXBid1LaYsc000001,0] java.sql.SQLException: ORA-20000: Oracle Secure Enterprise Search error[[

EQG-60503: task execution error (ID = 1938)

EQG-60401: populate document table error (MERGE INTO SEARCHSYS.eq$doc x USING (select /*+ LEADING(s u) index(sEQ$URL_STAGE_PK) index(u EQ$URL_URLID_UNQ) */ u.url_id, u.url display_url, u.access_url, u.signature, u.ds_id, u.la)

ORA-00904: "Y"."SHINGLE": invalid identifier

EQG-60401: populate document table error (MERGE INTO SEARCHSYS.eq$doc x USING (select /*+ LEADING(s u) index(sEQ$URL_STAGE_PK) index(u EQ$URL_URLID_UNQ) */ u.url_id, u.url display_url, u.access_url, u.signature, u.ds_id, u.la)

ORA-00904: "Y"."SHINGLE": invalid identifier
ORA-06512: at "SEARCHSYS.EQ_ERR", line 260
ORA-06512: at line 1



 

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