My Oracle Support Banner

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

Last updated on DECEMBER 10, 2019

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

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
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.