Unable to change form group in ROLES

Document ID : KB000074364
Last Modified Date : 22/03/2018
Show Technical Document Details
Issue:
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.
Environment:
Release/Version: 14 SP4-RUP1
OS/Platform: Windows Server2008
 
Cause:
the column ROLE_SEARCH_FREE_TEXT has corrupted content
Resolution:
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
pdm_d_refresh USP_PROPERTIES

5. Restart the SD service
6. Try to update a SD role and advise of the results