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(BrowseProjects.java:332)

 

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

Thanks

Krishnan

2 answers

0 vote

>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 vote

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

771 views 2 19
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