Comments and Likes Fail with Internal Server Error
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:
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") ...
Disable the Notifications plugin in the Confluence administration screens. This will allow users to 'like' and comment on pages that have watchers.
- 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