User Picker From Project Role plugin error

I use the User Picker From Project Role plugin. This plugin occurs some trouble.

[Trouble]

1. I create the custom field "test" as "User Picker From Project".

2. I add our custom field configuration it.

3. I browse the configure page about "test" .

4. I click the "Edit Selected role" link.

5. Displaying Error.

I think I need to edit selected role to use this plugin but I can't do it. Additionaly, I have error on "Create Issue" page because I have not setting about selected role. If you know workaround this error, tell me it.

I attached the screen shots and error log. Please, check it.

(error.txt)

3 answers

This widget could not be displayed.

You have some users with null usernames in the database?

Check this!

https://confluence.atlassian.com/display/JIRAKB/NullPointerException+when+Selecting+the+User+from+the+User+Picker

Hope it helps!

Hi Daniel

Thank you for your advice. I tried to find who has NULL in username but there is nobody.

mysql> select count(*) from cwd_user where user_name is NULL;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.01 sec)

The reason why there are different from my command and your refference page is that JIRA database table had changed from JIRA 4.3.

https://confluence.atlassian.com/display/JIRA044/JIRA+4.3+Upgrade+Guide#JIRA43UpgradeGuide-Databasetableshavechanged

Thanks,

Tarr

This widget could not be displayed.

Seems to be failing to find the field config scheme in the database. I've never seen this one before...

Can you try it again, maybe in a different instance? Perhaps there is something else wrong with this instance.

Hi Jamie,

Thank you for your comment. I tried to another instance but I couldn't find NULL username user. I use Crowd database as JIRA user directory.

mysql> select count(*) from cwd_user where user_name is NULL;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from cwd_user where user_name = "takahiro.tokunaga";
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.01 sec)

Please, check this. There is my account "takahiro.tokunaga" in this table but I couldn't find NULL username user.

If I made mistake, tell me about it.

Thanks,

Tarr

I don't think you should have user with username null... can you delete that one from the db?

This widget could not be displayed.

Have you solved this problem ? I have the same problem on our jira and we also don't have a username null in the database.

BR Elke

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

510 views 3 18
Read article

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