user renaming creates problem for avatar

Hello Support,

we are using jira 6.2.7. we have just renamed our user in crowd. crowd tables changed were (cwd_user , cwd_user) . No changes done in jira DB. Ideally it incorporates the changes itself.

Now the real issue that avatar is not vsible on issue view screen. and it is showing different urls created . Lets take an example. -

The older user was apandey8 which is renamed to apand5.

++++++++++++++++++

query from crowddb--

+++++++++++++++++++

select * from cwd_user where user_name like 'apand5%' ;

gives

8495923 apand5 apand5 T 2014-08-19 09:38:27 2014-08-22 10:55:26 Ashish ashish Pandey pandey Ashish Pandey ashish pandey apandey8@myserver.com apandey8@myserver.com 8454145 nopass 8454145:a92cb93b-4b46-4ceb-a078-c91c95807603

++++++++++++++++

Queries from jiradb--

++++++++++++++++

select * from avatar where owner like 'apand%' ;

10907 aashish.JPG image/pjpeg user apandey8 0
16000 archanaa_passport_size_photo.jpg image/jpeg user apanda23 0
24100 aashishjrvtg.png image/png user apandey8 0

select * from cwd_user where user_name like 'apand5%' ;

35617 10300 apand5 apand5 1 2012-12-01 03:35:59 2014-08-22 10:55:26 Ashish ashish Pandey pandey Ashish Pandey ashish pandey apandey8@myserver.com apandey8@myserver.com nopass 0 8454145:8454145:a92cb93b-4b46-4ceb-a078-c91c95807603

select id,pkey,project,reporter,assignee,issuenum,creator from jiraissue where id like '304694%' ;

304694 \N 10301 apandey8 ssharma 20672 apandey8

on issue view screen there are two different url creating one with apand5 and one with apandey8.

I tried to change in avatar table , apandey to apand5 , but that didn't help. What all are the table mappings and how pages is generating the urls different.

snapshots are attached.

Thanks

2 answers

any update??

Any Update ??

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

434 views 7 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you