Re: Can't delete profile picture

yundlu316 · ‎06-12-2019

yes I did that as well

sachin_namjoshi · ‎06-12-2019

What can you (as that avatar should be stored in sys_attachment as well) is the following:

- using Chrome browser right click on the avatar and then Inspect

- in the inspector you should see something like below:

- the sys_id you see there in red is the sys_id to the corresponding record in sys_attachment. Go to sys_attachment.list and in the filter use sys_id is <that sys_id>. This way you should get a record back. Let me know if this shows a record for you.

Regards,

Sachin

yundlu316 · ‎06-12-2019

Thanks Sachin, but I've tried that as well:

Soumita3 · ‎06-13-2019

Hi,

I would like you to check whether that particular image is deleted from the table where it is stored.

Could you please check the same and reload the page?

I hope your issue will be resolved.

Please mark the answer as correct if it suffice your query.

Thanks.
Soumita.

yundlu316 · ‎06-13-2019

Hey Everyone,

I opened a HI Ticket and the technician helped me solve the issue. This issue was completely my fault; should not delete profile pictures directly from the sys_attachment table for anyone who's facing the same problem. Here is the solution that fixed it:

The below KB article documents how to delete/update user profile pictures:
https://hi.service-now.com/kb_view.do?sysparm_article=KB0687598

The delete should be performed from the live_profile table.

Still using the steps above I was not able to empty the photo field for the corrupt record and I had to run 2 clean up scripts:

Clear photo value in live profile:

var gr = new GlideRecord('live_profile');
gr.addQuery('sys_id', '0280fc77dba4d700af88f5861d961971');
gr.query(); 
while(gr.next()) 
{ 
gs.print("Updating user"+ gr.name);
gs.print("Actual Photo"+ gr.photo);
gr.photo = '';
gr.setWorkflow(false); 
gr.update(); 
}

Clear photo value in sys_user:

var gr = new GlideRecord('sys_user');
gr.addQuery('sys_id', '62826bf03710200044e0bfc8bcbe5df1');
gr.query(); 
while(gr.next()) 
{ 
gs.print("Updating user"+ gr.name);
gs.print("Actual Photo"+ gr.photo);
gr.photo = '';
gr.setWorkflow(false); 
gr.update(); 
}

After clearing the cache using cache.do everything was back to order.

View solution in original post