-
Type:
Suggestion
-
Resolution: Fixed
-
Component/s: Content - Page
-
None
-
1
-
1
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.
- is resolved by
-
CONFSERVER-18509 MySQL databases incapable of handling 4byte UTF-8 Characters. Confluence should handle this gracefully
-
- Closed
-