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

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

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?

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 Nov 29, 2018 in Marketplace Apps

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,431 views 0 8
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