BrowseProjects.jspa fails to load projects

I added projects using db scripts. Among the main tables were project_key, projectversion, nodeassociation and did a full re-indexing of JIRA instance.  But when I browse for projects by http://localhost/secure/BrowseProjects.jspa,  throws an exception "

"hasDefaultAvatar", exception: java.lang.NullPointerException

    at com.atlassian.jira.web.action.browser.BrowseProjects$ProjectCategoryBean$1$1.hasDefaultAvatar(


Unable to understand this exception.  What could have gone wrong?



2 answers

0 votes

>I added projects using db scripts

This is almost certainly the entire problem.  Your scripts have missed something.  I would very strongly recommend that you immediately revert to the backup you took before you ran your scripts.  Then do your project creation properly, not with SQL.

Thanks Nic.  what is the best approach to merge two JIRA instances? This is what i am trying to achieve.

Export and project import. Never SQL

Tried this option. But then, activeobjects data and jira configuration data couldn't be done through project import.

Moreover, during the project import the following exception is thrown. "Unable to import custom field 'Sprint'. The custom field type does not support project imports."

0 votes

Looks like you do not have an avatar set up? You might have to programmatically set that when creating the project using API.

Regarding the project import conversation, an easy approach is to transfer the AO data and configurations using scripts and rely on project import for everything else. We, Go2Group, has successfully done that for many customers.

Thanks Jobin, I got into the logs and found " /secure/BrowseProjects.jspa [webwork.util.ValueStack] METHOD: "hasDefaultAvatar", exception: ". Found there is mismatch between the avatar in project and the owner of avatartype in Avatar. I am just fixing that. Initially I started off like you suggested but when I couldn't go beyond this exception "Unable to import custom field 'Sprint'. The custom field type does not support project imports.", I started writing db scripts.

Probably you could include this in "How to" series in your next book.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,982 views 12 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot