Searching Knowledge Base Gives Error: JBO-27122: SQL Error During Statement Preparation
(Doc ID 416129.1)
Last updated on JULY 21, 2020
Applies to:Oracle Knowledge Management - Version 11.5.8 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
You are receiving an error when entering a simple search within the Knowledge Base, or using the Search Knowledge function from the Service Request form:
JBO-27122: SQL error during statement preparation.
select count(*) total
from cs_incidents_b_sec sr,
where sr.incident_id = tl.incident_id
and tl.language = userenv('lang')
and sr.incident_id <> :1
and contains (tl.text_index, :2, 1) > :3
and rownum <= :4
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document