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)
-> 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.
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.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG