Irecruitment Search Function Down Since OATM Migration Getting ORA-20000: Oracle Text error: DRG-10599 (Doc ID 1317703.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle iRecruitment - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms




After doing an Oracle table migration, when an individual  or an applicant logs into the iRecruitment web site and searches for a job by location, the following error occurs
the following error occurs.

ERROR
-----------------------
## Detail 0 ## java.sql.SQLException: ORA-20000: Oracle Text error: DRG-10599: column is not indexed at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2566) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2963) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658) at


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Navigate to the iRecruitment Web site
2. Do a job search or log in and the do a job search by location
3. Error occurs

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