Hi community,
I got errors in my Jira project with JSD :
"Customer notifications missing
We can't find your customer email notification rules. To fix this, restore your email rules"
But when I clic on Restore Email Rules I got :
"An error occurred while trying to restore the email notification rules. Please try again."
In Catalina.out the error is :
/rest/servicedesk/notifications/1/misconfiguration/SUP/fix [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: Failed to insert rule component configuration data
According to the folowing link the error is related to the database collation:
But when I test it seems to be OK:
SELECT C.collation_name, T.table_name FROM information_schema.tables AS T,information_schema.`collation_character_set_applicability` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jira-desk' AND C.collation_name != 'utf8_bin';
Empty set (0,01 sec)
SELECT default_collation_name
-> FROM information_schema.schemata S
-> WHERE schema_name = (SELECT 'jira-desk'
-> FROM DUAL);
+------------------------+
| default_collation_name |
+------------------------+
| utf8_bin |
+------------------------+
1 row in set (0,00 sec)
My config is : JSD 3.5.0, Jira Core 7.3.6 and Mysql 5.7.18
Can someone help me please ?
Thank you very much.
Baptiste
Hi Baptiste,
Can you also provide us the result of this query run against your database:
select table_schema, table_name, column_name, character_set_name, collation_name from information_schema.COLUMNS where collation_name != 'utf8_bin';
If this shows that some columns are not set to the correct collation, short of migrating the entire database, I believe you should be able to update these by using the Changing Column Collation section of How to Fix the Collation and Character Set of a MySQL Database.
Cheers,
Branden
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.