We've had a couple of calls recently where users have been able to load a CV in to IQX when adding a new candidate but when they go to the CV tab in IQX it hangs and they have to come out of IQX. Running the SQL below will delete the CV and the searchable text. The user will then be able to load in another version of the CV (I found that by copying the text into notepad and then back in to a Word doc it works)
Select * from person where name = 'person name' ---- to get their personid
then
select * from blobstore where class='v' and id= 'personid'
then
delete from blobstore where class = 'v' and id = 'personid'
then
update person set cvtext=null where personid='personid'