{"id":1332,"date":"2020-04-05T10:34:48","date_gmt":"2020-04-05T10:34:48","guid":{"rendered":"https:\/\/porzelt.net\/?page_id=1332"},"modified":"2020-04-05T10:43:08","modified_gmt":"2020-04-05T10:43:08","slug":"known-issues-activeobjectssqlexception","status":"publish","type":"page","link":"https:\/\/porzelt.net\/en\/documentation\/canned-issues\/known-issues-activeobjectssqlexception","title":{"rendered":"Known Issues – Canned Issues: ActiveObjectsSqlException"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

An error has been reported that the config page within the administration can not be called.<\/p>

On Checkig the logs errors similar to the one below showed up:<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
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_1E216A_MPZ_ST_BASE '<\/pre>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
In all reported cased the customer was using MySQL 5.7.6 or upwards.<\/p>
When reading this article provided by atlassian: https:\/\/confluence.atlassian.com\/adminjiraserver073\/connecting-jira-applications-to-mysql-861253043.html<\/a> there is a description on granting additional privileges like this:<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JiraDatabase>.* TO '<SQLUser>'@'<ServerHostname>' IDENTIFIED BY '<Password>';
flush privileges;<\/pre>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
So the solution to the problem is to execute this query for your database. Remember to replace the < > placeholders.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"
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 ”@” […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1305,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/pages\/1332"}],"collection":[{"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/comments?post=1332"}],"version-history":[{"count":5,"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/pages\/1332\/revisions"}],"predecessor-version":[{"id":1337,"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/pages\/1332\/revisions\/1337"}],"up":[{"embeddable":true,"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/pages\/1305"}],"wp:attachment":[{"href":"https:\/\/porzelt.net\/en\/wp-json\/wp\/v2\/media?parent=1332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}