Troubleshooting

Not able to add new checklist items. Here is what is logged in the browser consolde:

PUT https://[instance]/rest/railsware/1.0/checklist/-1/item 500
{errorMessage: "bundle [com.railsware.rw-smart-checklist-biz]"}

This error can happen anytime the database user has not be granted the needed permissions, and JIRA is expected to create a new foreign key constraint.

Explained here

https://confluence.atlassian.com/jirakb/com-mysql-jdbc-exceptions-jdbc4-mysqlsyntaxerrorexception-references-command-denied-to-user-872266070.html

Grant proper permisisons to Jira User by executing SQL command

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

Checklist statuses are not available

Conflict with settigns left after prevous version of Smart Addon that was installed on this instance

1. Stop the Jira instance

2. Delete the following hidden plugin cache directories (just these two):

   1. JIRA_HOME/plugins/.bundled-plugins

   2. JIRA_HOME/plugins/.osgi-plugins
      

3. Restart JIRA