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 Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,644 views 18 21
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