Known issue with error bundle [com.riadalabs.jira.plugins.insight]
Description
You might encounter the following error:
Additionally, we found the following logs:
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:MySQL
- version:5.7.17
- minor version:7
- major version:5
- name:MySQL Connector Java
- version:mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 )
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' for table 'AO_8542F1_IFJ_OBJ_SCHEMA'Solution
Execute the following query for your database. Remember to replace the < > placeholders.
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
flush privileges;
Last modified on Sep 23, 2022
Powered by Confluence and Scroll Viewport.