Automation page keeps loading

Still need help?

The Atlassian Community is here for you.

Ask the community

 

 

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

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 Nov 23, 2020

Was this helpful?

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