Crawler Schedules Page in SES Admin is Empty. ORA-20000, ORA-01489, ORA-06512 Errors in the Oc4j.log (Doc ID 737436.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Secure Enterprise Search - Version 10.1.8.3 and later
Information in this document applies to any platform.
***Checked for relevance on 28-Jun-2013***

Symptoms

-- Problem Statement:
SES : 10.1.8.3

  1. The Crawler Schedules page in SES Admin is empty , even though schedules exist.
  2. Looking at the oc4j.log, you could  see this error statement.
    ORA-20000: Oracle Secure Enterprise Search error
    ORA-01489: result of string concatenation is too long
    ORA-06512: at "EQSYS.EQ_ERR", line 186
    ORA-06512: at line 1
  3. Checking the schedule with searchadminctl results in an error.
    [<User >@<Server Name> bin]$ ./searchadminctl schedule -list
    Please enter SES administrator password: *******
    list operation failed with error: ORA-20000: Oracle Secure Enterprise Search error
    ORA-01489: result of string concatenation is too long
    ORA-06512: at "EQSYS.EQ_ERR", line 186
    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