Customer is unable to change form group in ROLES.
When he clicks over save button, it hangs and never saves the changes a lock in the USP_PROPERTIES ROLE_SEARCH_FREE_TEXT in ROLE_SEARCH_FREE_TEXT column is generated.
Release/Version: 14 SP4-RUP1
OS/Platform: Windows Server2008
the column ROLE_SEARCH_FREE_TEXT has corrupted content
1. Take a full backup of the MDB database
2. Run the following SQL command to clear out the USP_PROPERTIES table
delete FROM USP_PROPERTIES
3. Take an OOTB extracted file from USP_PROPERTIES table from a working server
4. Via a command prompt from the directory where the 'usp_properties.txt' file is located, run the following commands
pdm_load -f usp_properties.txt
5. Restart the SD service
6. Try to update a SD role and advise of the results