Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-55478

Improvement of error message in confluence

XMLWordPrintable

    • 1
    • 1
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Summary

      When customer hit into an issue editing a page or saving a page, the error message that shows to the customer are "Unable to communicate with server. Saving is not possible at the moment". However, this could cause confusion to the customer as the root cause of the issue is caused by a page containing some special characters.

      2018-04-20 12:44:20,074 ERROR [http-nio-8001-exec-72] [common.error.jersey.ThrowableExceptionMapper] toResponse Uncaught exception thrown by REST service: Hibernate operation: could not execute statement; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x8F\x84</...' for column 'BODY' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x8F\x84</...' for column 'BODY' at row 1
 -- referer: https://agile.richemont.com/confluence/pages/editpage.action?pageId=90463260 | url: /confluence/rest/tinymce/1/drafts | traceId: 2f068cc8f23f5c11 | userName: koen.gillard@pycogroup.com
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute statement; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x8F\x84</...' for column 'BODY' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x8F\x84</...' for column 'BODY' at row 1
Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x8F\x84</...' for column 'BODY' at row 1

      Suggestion

      It will be better to have a clear error message when a page is not able to edit or save.

            [CONFSERVER-55478] Improvement of error message in confluence

            Sen Geronimo made changes -
            Workflow Original: JAC Suggestion Workflow 4 [ 3570825 ] New: JAC Suggestion Workflow 3 [ 4339193 ]
            set-jac-bot made changes -
            Fixed in Long Term Support Release/s New: [Download 6.13|https://confluence.atlassian.com/enterprise/atlassian-enterprise-releases-948227420.html]
            Ganesh Gautam made changes -
            Fix Version/s New: 6.13.13 [ 92114 ]
            Fix Version/s New: 7.3.4 [ 91625 ]
            Resolution New: Fixed [ 1 ]
            Status Original: Gathering Interest [ 11772 ] New: Closed [ 6 ]

            Ganesh Gautam added a comment -

            Hi All,

            I wanted to follow up on our update above. The Confluence server development team has now completed both item 1 (Support for emoji in MySQL) and item 2 (providing meaningful error messages). We strongly encourage customers to follow the steps outlined in our documentation to migrate from UTF8 to UTF8MB4, completely resolving this issue.

            If you are unable to migrate to UTF8MB4 we have added a number of meaningful error messages to Confluence to stop users attempting to add unsupported 4-byte characters. We have added these errors to:

            • page publish/save events for pages and blogs 
            • page titles
            • comment/inline comment saves.

            Thanks,

            Ganesh

            Ganesh Gautam added a comment - Hi All, I wanted to follow up on our update above. The Confluence server development team has now completed both item 1 ( Support for emoji in MySQL ) and item 2 ( providing meaningful error messages ). We strongly encourage customers to follow the  steps outlined in our documentation  to migrate from UTF8 to UTF8MB4, completely resolving this issue. If you are unable to migrate to UTF8MB4 we have added a number of meaningful error messages to Confluence to stop users attempting to add unsupported 4-byte characters. We have added these errors to: page publish/save events for pages and blogs  page titles comment/inline comment saves. Thanks, Ganesh
            Ganesh Gautam made changes -
            Link New: This issue is resolved by CONFSERVER-18509 [ CONFSERVER-18509 ]
            Ganesh Gautam made changes -
            Assignee New: Ganesh Gautam [ ggautam ]
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 2
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow 2 [ 3186028 ] New: JAC Suggestion Workflow 4 [ 3570825 ]
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1

              ggautam Ganesh Gautam
              lng@atlassian.com Lipkent Ng
              Votes:
              6 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated:
                Resolved: