Having issue with our Importer utility for Zephyr for Jira Cloud.Please click here for the steps to resolve the issue. If you are not able to access Capture Cloud and seeing a message, it means your Capture cloud instance is not migrated as part of our GDPR and Atlassian privacy policy. Please click here for the steps to Migrate your Capture Cloud instance to use Capture.
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