Support | Zephyr



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

Created on

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


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk