Search With A Profile Fails - Cannot Delete and Recreate Failed Profile - SDATA Error (Doc ID 1381712.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle WebCenter Content - Version 7.5.0 to 11.1.1.8.0 [Release Stellent to 11g]
Information in this document applies to any platform.

Symptoms

Searches performed by a user with a profile fail, especially date range searches.  Deleting the profile and recreating the profile does not resolve the issue.  Creating the same profile, but with a different name, works correctly. 

This particular error occurred in one case.

Content Server Request Failed
Unable to retrieve search results Error generated when executing query '(((( SDATA(dInDate >= '2011/11/15 12:00:00') ) and ( SDATA(dInDate < '2011/11/16 12:00:00') ) and ( (((1) WITHIN xIsRecord)) ) and ( (((0) WITHIN xIsVital)) ))))'. Possible database connection failure encountered. Error message: (!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$No more data to read from socket).

Changes

Content Server patches were installed, but a few components did not update correctly.  This was not discovered until sometime after the update since no error messages indicated a problem when the patches were installed. 

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