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>';

Note: you can use 3rd party addon, like Database Explorer in order to execute these queries

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

"Uncaught DOMException: Permission denied to access property "document" on cross-origin object" in the JavaScript”

message appears when trying an import checklist from a Template

Jira version 8.12

Known bug introduced by Atlassian in Jira v 8.12

Fixed in Jira 8.12.3, 8.13.1

More details: https://jira.atlassian.com/browse/JRASERVER-71747

Upgrade your Jira to 8.12.3, 8.13.1 or higher version.

Checklist item could not be added. The following error shown in Jira log:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:53) at com.railsware.ao.upgrade.v2.MigrateProjectTemplates.upgrade(MigrateProjectTemplates.java:59) at com.atlassian.activeobjects.internal.ActiveObjectUpgradeManagerImpl$1.doInTransaction(ActiveObjectUpgradeManagerImpl.java:68) at

Reproduced on

• Jira v7.6

• MySQL DataBase v5.7

MySQL DB was not set properly

Check if mysql DB has set as suggested by Atlassian: https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html

Especially

• character_set_server=utf8mb4

• innodb_large_prefix=ON

Using “Clone” Issue doesn’t copy “Checklists” field content to the newly created issue.

“Checklists” field is not added to the Projects, where Clone operation is executed.

• Go to Issues → Custom Fields → search for ”Checklists“ field → Configure

• Check Applicable contexts for scheme

• Click “Edit Configuration”

• Go to “Choose applicable context”

• Make sure there selected  “Global context. Apply to all issues in Jira.”

• Even if it is - Click “Modify”

• Now, the cloning should work properly

Note: For users who started using checklist fro m version 5.5.0 that should already been fixed.