E-SES: SES Searching Is Not Working After doing Unload and Reload Schema (Doc ID 2060810.1)

Last updated on FEBRUARY 10, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.
In general we do not recommend trying to reclaim space as typically SES will just reuse the space as documents are added or deleted. We only support using RMAN to backup and restore the database and I'm not sure that this tool would reclaim any unused table space. Using the export and import doesn't always seem to keep the correct data organization that SES depends on.

Symptoms

On : 8.54 version, Search Framework

ERROR
-----------------------
DRG-10599: column is not indexed


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue SES Searching is not working

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