Confluence label autocomplete does not work in a certain page

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.

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 adding a label into a page, the autocomplete does not show any label even the label have been added into other page. The label autocomplete does shows in other pages.

The following appears in the atlassian-confluence.log

ERROR [http-nio-8090-exec-18] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
 -- referer: https://mycompany.com/display/TEST/Test+Page | url: /labels/autocompletelabel.action | userName: test
java.lang.NullPointerException
    at com.atlassian.confluence.plugins.labels.actions.AutocompleteLabelsAction.filterLabelsByQuery(AutocompleteLabelsAction.java:192)
    at com.atlassian.confluence.plugins.labels.actions.AutocompleteLabelsAction.getSuggestedLabels(AutocompleteLabelsAction.java:133)
    at com.atlassian.confluence.plugins.labels.actions.AutocompleteLabelsAction.findLabels(AutocompleteLabelsAction.java:101)
    at com.atlassian.confluence.plugins.labels.actions.AutocompleteLabelsAction.execute(AutocompleteLabelsAction.java:77)
    at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)

Diagnosis

Diagnostic Steps

Run the following database query in your Confluence database:

1. Verify if there is a label with empty name.

select * from LABEL where NAME is null and OWNER is null;
 

2. Verify if there is content associated to that label.

select * from CONTENT_LABEL where LABELID=<labelid_from_query_above>;
select TITLE from CONTENT where CONTENTID=<contentid>;
If the first query return any result, this may trigger the issue with label autocomplete in the affected pages as return in the second query

Cause

The issue is caused by the label with empty name by checking the result from the database query in the diagnostic step.

Resolution

Please run the following database query in order to delete the label:

delete from CONTENT_LABEL where LABELID = <labelid_from_first_query>;
delete from LABEL where LABELID = <labelid_from_first_query>;

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.

 

Last modified on May 31, 2016

Was this helpful?

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