Jira throws SQL exception (Active Objects library) when setup the repeating

Problem

When trying to setup details of repeating Jira throws an error like:

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.codedoers.repeatingissues.jira-app]
com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.codedoers.repeatingissues.jira-app]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95) [?:?]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:86) [?:?]
	at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38) [?:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_202]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
    Database:
    	- name:MySQL
    	- version:5.7.26
    	- minor version:7
    	- major version:5
    Driver:
    	- name:MySQL Connector Java
    	- version:mysql-connector-java-5.1.36 ( Revision: 4fc1f969f740409a4e03750316df2c0e429f3dc8 )
    
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user 'jirauser'@'localhost' for table 'AO_DDFFC4_CALENDAR'

Solution

The problem is related with database setup. Please note that this problem may also affect not only the Repeating Issues app in your environment.

Atlasssian provide solutions for this problem on his Jira Knowledge base here https://confluence.atlassian.com/jirakb/jira-server-throws-unknown-error-when-creating-projects-using-mysql-833998922.html. After applying solutions please restart your Jira instance.

If problem still exists then please do the following:

Uninstall the Repeating Issues app
Remove AO_DDFFC4_CALENDAR and AO_DDFFC4_NON_WORKING_DAY_RULE tables from your Jira database
Restart your Jira instance
Install the Repeating Issues app.
Check if you can use the app now.

Note that after removing the tables you need to reconfigure your non-working day rules for the Repeating Issues app. See Managing non-working days for details.