Zephyr test details doesn't show up error - rendering com.thed.zephyr.je view issue step section

January 31, 2019

Problem

After installation of Zephyr add-on over the atlassian market,  create a test case with test steps but it was not possible to see the test details section. Gives the below error:

 error - rendering com.thed.zephyr.je view issue step section

This error is commonly seen in JIRA Server environments that have been setup to use a MySQL 5.7.6 database version or higher. 

The most common times when you might see this kind of error would be:

  • During an initial setup of JIRA
  • During a migration from Cloud to Server
  • If you have recently upgraded your database server or migrated your JIRA database to a different database server
  • During a plugin installation/update

error in the logs - 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user

at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:72)
at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:91)
... 6 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: REFERENCES command denied to user 'jiradbuser'@'localhost' for table 'AO_5FB9D7_AOHIP_CHAT_LINK'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance

Cause

 Permission issue

Solution

Grant permission to the users.

Stop you JIRA sever . Please use the below query to grant permission in your database. And then restart you JIRA:

SQL COMMANDS
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
flush privileges;

Products:

Versions: Mysql 5.7.X  , Zephyr for jira - 4.0.X , JIRA 7.3 onward

Environment: Database affected version - My SQL 5.7.x