Search With A Profile Fails - Cannot Delete and Recreate Failed Profile - SDATA Error
(Doc ID 1381712.1)
Last updated on SEPTEMBER 27, 2019
Applies to:Oracle WebCenter Content - Version 7.5.0 to 126.96.36.199.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.
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