DRG-11112: LENGTH OF CLOB QUERY VALUE EXCEEDS MAXIMUM OF 64000 Searching For Careers In HCM 9.2 (Doc ID 2091948.1)

Last updated on JULY 11, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On Careers page in HCM 9.2 Getting EQG17060: Internal query syntax error.
Receiving errors in the server log when trying to search in the Careers page by typing characters.
Error - -> EQG17060: Internal query syntax error.

search_server1 log shows
EQG-ARG: EQG-ARG: EQG-ARG:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-11112: length of CLOB Query Value exceeds maximum of 64000
ORA-06512: at "SEARCHSYS.EQ_ERR"

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