Following Upgrade to WebCenter Content (WCC) 11.1.1.9, Unable to Check-In or Search for Content. Error ORA-00904: "DRELEASESTATE" invalid identifier is visible (Doc ID 2065812.1)

Last updated on MAY 04, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

WCC or URM system upgraded from 11.1.1.6.0 to 11.1.1.9.0.  Content can no longer be checked-in or searched for.

In the logs the error ORA-00904: "DRELEASESTATE" invalid identifier is visible.

Changes

 The field 'dReleaseState' was added to search queries.

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