Search With A Profile Fails - Cannot Delete and Recreate Failed Profile - SDATA Error
Last updated on JUNE 07, 2017
Applies to:Oracle WebCenter Content - Version 7.5.0 to 188.8.131.52.0 [Release Stellent to 11g]
Information in this document applies to any platform.
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.
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).
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.
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