Issue Statuses with (No Category) are auto-generated by Jira Service Management

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform Notice: Server, Data Center, and Cloud By Request - This article was written for the Atlassian server and data center platforms but may also be useful for Atlassian Cloud customers. If completing instructions in this article would help you, please contact Atlassian Support and mention it.

Problem

There are some issue statuses: (Waiting for support) & (Waiting for customer) that auto-generated by Jira Service Management are categorized with a "No Category". The "No Category" is not allowed in normal Jira usage where all statues are required to be categorized into: 

  • To Do
  • In Progress
  • Done

If the statues is changed to either three of the categories above, the category will not be able to change back to "No Category". 

Details

This is just the Jira Service Management created the statuses without the requirement, it will not cause any further issues other than changing the color of some status lozenges. 

Workaround

If you wanted to change it back to "No Category", you may do so by modifying the database directly as suggested in JRASERVER-44020 - Getting issue details... STATUS

Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  1. Backup your Jira database so that you can rollback if you encountered any problems.
  2. Stop Jira.
  3. Run the SQL query below in your database to modify the intended status category to "No Category": 

    UPDATE issuestatus SET statuscategory = 1 WHERE pname = 'STATUS_NAME';

    (info) Just change the STATUS_NAME to the status name that you wanted to change.

  4. Start Jira.



Last modified on Oct 3, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.