Automation page keeps loading

Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.

Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Problem

When browsing Jira Service Management project > Settings > Automation, the page shows a spinning wheel and never finish loading.

The following appears in the atlassian-jira.log.

java.lang.NullPointerException
at com.atlassian.servicedesk.plugins.automation.internal.configuration.ruleset.dao.querydsl.RuleDao.createRule(RuleDao.java:125)
at com.atlassian.servicedesk.plugins.automation.internal.configuration.ruleset.dao.querydsl.RuleDao.lambda$getForRuleSetRevisionIds$2(RuleDao.java:109)
at java.util.stream.Collectors.lambda$mapping$8(Collectors.java:355)
at java.util.stream.Collectors.lambda$groupingBy$45(Collectors.java:909)
...

Diagnosis

Check if there is any NULL value in the Automation table in the database, both the queries below should return a NULL value for the first column.

  1. select * from `AO_9B2E3B_RULE` where ENABLED is null;
  2. select IS_SYSTEM_RULE_SET, RULE_SET_ID, ID from `AO_9B2E3B_RULESET_REVISION` where IS_SYSTEM_RULE_SET is null;


Cause

There is at least one Automation rule in the database with NULL value in the "Enabled" column.


Resolution

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. Update the table to include the value needed. (info)ID = 3 is an example here, please change the 3 into the actual IDs you have obtained from the previous select queries.

    update `AO_9B2E3B_RULE` set ENABLED = '1' where ID = 3;
    update `AO_9B2E3B_RULESET_REVISION` set IS_SYSTEM_RULE_SET = '0' where ID = 3;
  2. Restart Jira.


Last modified on Feb 5, 2025

Was this helpful?

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