Notification Box Is Empty
Symptoms
When opening the notification or task box in the upper right corner, it is empty.
The following appears in the atlassian-confluence.log:
caused by: java.sql.SQLException: Incorrect string value: '\xE3\x81\xAB\xE3\x81\x82...' for column 'DATA' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
2013-05-30 12:27:40,139 ERROR [http-8090-1] [xxxx] toResponse Exception thrown from resource
-- referer: http://xx.xxx.de:8090/plugins/servlet/notifications-miniview#notification | url: /rest/mywork/latest/notification/nested | userName: admin
com.google.common.util.concurrent.UncheckedExecutionException: java.util.NoSuchElementException
at com.google.common.cache.CustomConcurrentHashMap$ComputedUncheckedException.get(CustomConcurrentHashMap.java:3305)
at com.google.common.cache.CustomConcurrentHashMap$ComputingValueReference.compute(CustomConcurrentHashMap.java:3441)
at com.google.common.cache.CustomConcurrentHashMap$Segment.compute(CustomConcurrentHashMap.java:2322)
Diagnosis
Run the following query against the Confluence database. The collation for all tables should be unicode utf-8, if they are not set to unicode utf-8 then proceed to the resolution section of this article.
For Oracle databases, the equivalent for utf-8 is AL32UTF8
show table status;Cause
Incorrect configuration of database encoding.
Resolution
Follow the instructions at the following page to convert the database to utf-8 character encoding:
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.