Adding a Label to an Attachment Returns an Error

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When Confluence users try to add a label to an attachment to a page, an error returns as seen in the screenshot below:

Confluence logs the following stack trace:

 -- url: /confluence/rest/ui/1.0/attachment/117347218/labels | userName: shimon | referer: http://localhost:8090/conf/pages/viewpageattachments.action?pageId=103252421
2014-09-07 15:20:58,445 ERROR [http-8090-188] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session
 -- url: /confluence/rest/ui/1.0/attachment/117638197/labels | userName: shimon | referer: http://localhost:8090/conf/pages/viewpageattachments.action?pageId=103252421
2014-09-07 15:20:58,447 ERROR [http-8090-188] [confluence.ui.rest.LoggingExceptionMapper] toResponse Exception while processing REST request: Hibernate operation: could not insert: [com.atlassian.confluence.labels.Labelling#117833847]; SQL []; ORA-01400: cannot insert NULL into ("CONF"."CONTENT_LABEL"."CONTENTID")
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONF"."CONTENT_LABEL"."CONTENTID")

 -- url: /confluence/rest/ui/1.0/attachment/117347218/labels | userName: shimon | referer: http://localhost:8090/conf/pages/viewpageattachments.action?pageId=103252421
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.labels.Labelling#117833847]; SQL []; ORA-01400: cannot insert NULL into ("CONF"."CONTENT_LABEL"."CONTENTID")
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONF"."CONTENT_LABEL"."CONTENTID")

Cause

Confluence always inserts a NULL value into the CONTENTID column of the CONTENT_LABEL table when it tries to add a label to an attachment.  This is done before executing an UPDATE command to fill in the correct CONTENTID. This issue occurs because the CONTENT_LABEL table does not allow a NULL value in the CONTENTID column when it is supposed to allow it.

Resolution

ALTER the CONTENT_LABEL table to allow the CONTENTID column to contain a NULL value. Please refer to the following details:

Please backup your database before performing any modifications

  1. MySQL : Alter Table Page
  2. PostgreSQL : Alter Table Page
  3. Oracle :

    ALTER TABLE 
       CONTENT_LABEL
    modify 
    ( 
       CONTENTID    NUMBER(19,0)
    );
Last modified on Mar 30, 2016

Was this helpful?

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