Known Issues – Canned Issues: ActiveObjectsSqlException

An error has been reported that the config page within the administration can not be called. On Checkig the logs errors similar to the one below showed up: 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 “@“ for table ‚AO_1E216A_MPZ_ST_BASE ‚ In all reported cased the customer was using MySQL 5.7.6 or upwards. When reading this article provided by atlassian: https://confluence.atlassian.com/adminjiraserver073/connecting-jira-applications-to-mysql-861253043.html there is a description on granting additional privileges like this: GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on .* TO “@“ … Known Issues – Canned Issues: ActiveObjectsSqlException weiterlesen