BrowseProjects.jspa fails to load projects

[krishnan]

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

[Jobin Kuruvilla [Adaptavist]]

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.

[krishnan]

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.

[krishnan]

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

[Nic Brough -Adaptavist-]

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

[krishnan]

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

[Nic Brough -Adaptavist-]

Export and project import. Never SQL

[krishnan]

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

[krishnan]

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."