Symptoms

When you press the 'Like' button or leave a comment on a page that has watchers, an internal error like the following is displayed in the browser:

In the atlassian-confluence.log file, you will see errors similar to the following:

2012-12-24 21:17:18,291 ERROR [http-443-55] [atlassian.event.internal.EventPublisherImpl] invokeListeners There was an exception thrown trying to dispatch event 'com.atlassian.confluence.event.events.content.comment.CommentCreateEvent[source=com.atlassian.confluence.pages.DefaultCommentManager@1d9fed19]' from the invoker 'com.atlassian.event.internal.SingleParameterMethodListenerInvoker@18e16a6b'.
 -- url: /rest/tinymce/1/content/33196214/comment | userName: admin | referer: https://kb.corp.good.com/display/TOOLS/Home
java.lang.RuntimeException: java.lang.reflect.UndeclaredThrowableException

...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONFDB"."AO_9412A1_AONOTIFICATION"."ID")
...

Cause

This can be caused by CONF-26965 - Getting issue details... STATUS , which means that the sequence on the table was not created due to permissions errors.

Workaround

Disable the Notifications plugin in the Confluence administration screens.  This will allow users to 'like' and comment on pages that have watchers.

Resolution

• Shutdown Confluence
• Run the following SQL against the database

 The following is a data destructive process which will remove all existing notifications in workboxes.  Be sure to create a backup of the database before enacting the following as well as test in a development environment before enacting in production

DROP TABLE AO_9412A1_AONOTIFICATION;
DROP SEQUENCE AO_9412A1_AONOTIFIC1763171329;
COMMIT;

 The SQL statement above refers to Oracle databases. This issue has not been seen in other databases but if you are experiencing this in another environment the commands may need to be adjusted.

• Start Confluence