My Oracle Support Banner

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.

Symptoms

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:

oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.
Statement:
select count(*) total
from cs_incidents_b_sec sr,
cs_incidents_all_tl tl
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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.