Problem to add Tests to test cycle - JIRA with HSQL database throws SQL exception

July 04, 2019

Problem

Problem to add Tests to test cycle - JIRA with HSQL database.

Cause

The below error was thrown due to the incompatibility of the database with ZFJ plugin versions.

In adding issue to Cycle. {"message":"There was a SQL exception thrown by the Active Objects library:\nDatabase:\n\t- name:HSQL Database Engine\n\t- version:1.8.0\n\t- minor version:8\n\t- major version:1\nDriver:\n\t- name:HSQL Database Engine Driver\n\t- version:1.8.0\n\njava.sql.SQLException: Unexpected token 0, requires FROM in statement [SELECT DISTINCT LIMIT 0 1 ORDER_ID FROM PUBLIC.AO_7DEABF_SCHEDULE WHERE ORDER_ID IS NOT NULL ORDER BY ORDER_ID DESC]","status-code":500,"stack-trace":"com.atlassian.activeobjects.internal.ActiveObjectsSqlException:There was a SQL exception thrown by the Active Objects library

Fix

The Latest versions of Zephyr for JIRA installed on JIRA with HSQL database will cause this issue.

  1. Check what version of ZFJ installed and check the compatibility at https://marketplace.atlassian.com/plugins/com.thed.zephyr.je/versions
  2. Install a lower version (V2.2.1.22101482) of Zephyr for JIRA to work with JIRA 5.x by downloading.
  3. Once you download the *.obr file upload it using the JIRA's upload add-on function navigating to Administration -> Add-ons -> Manage add-ons

Products: