JIRA ERROR

[matheus nascimento camargo]

After changing an issue type screen scheme, the system stopped opening events, and I can not change the configuration of the project or delete the issues types of the jira, I deleted all the correncias and even the project because the error persists

[matheus nascimento camargo]

[Andy Heinzer]

Hi @matheus nascimento camargo

The error message you are seeing is consistent with there being a problem in the Jira database.  Please see the KB NullPointerEx ception when creating issue, editing issue, move issue, accessing the Screen tab from the Project

This KB has diagnosis steps you can take in order to identify the problematic record in the database and then take the steps needed to remove this manually via SQL.   Of course we would recommend that you take a backup of your database before trying those steps.  

Please let us know the results.  If you run into problems I would be interested to see the specific results of the diagnosis SQL queries here.

[matheus nascimento camargo]

Good afternoon I have followed the steps that the Andrew Heinzer did not report any links, first worked, after a while, when it was deleted another question of the type that was no previous relationship, the system gave the same problem

[matheus nascimento camargo]

[Andy Heinzer]

Could let me know the results of this slightly modified query instead?

select cf.optionid from optionconfiguration cf where cf.fieldid = 'issuetype' and cf.optionid not in (select it.id from issuetype it);

Also, please generate a support zip so we can get a better look at your logs.   If you could then upload this to a site like Google Drive or Dropbox and then share the link with us here, I can get better understanding of all the errors in your Jira site and not just those in these screenshots.

Thanks,

Andy

[matheus nascimento camargo]

I created a .RAR by the tool, but I can not find the folder it is generated in directories

[Bastian Stehmann]

Hi @matheus nascimento camargo,

did you try to delete the duplicate issue type? If not, can you please try that.

[matheus nascimento camargo]