We are performing a phasewise scheduled maintenance of our Zephyr for Jira Cloud and Capure for Jira Cloud instances to be compliant with GDPR- Atlassian privacy policy (https://www.atlassian.com/trust/privacy) .Please expect a downtime during this phase of maintenance from Saturday, 01/12/2019, 9:30 PM PST up until Sunday 01/13/2019, 9:30 AM PST.This will be for our phasewise deployment of infrastructure changes, migration utility verification and customer data migration, as part of our GDPR and Atlassian privacy policy compliance efforts.For any further queries regarding this please rasie a ticket by using the option 'Submit a Ticket' below
Support | Zephyr

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

Created on


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

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


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