Update for our Zephyr for Jira Server/DataCenter customers : Our team is working on a major version release of Zephyr for Jira to be compatible with Jira 8 .The tentative ETA for the release of this compatible version is by end of March 2019.Please watch this space and anticipate further notifications from the Zephyr team on the updates with regards to the release of the same.Till then we suggest you to use lower version of Jira for seamless operations of Zephyr plugin.For any further feedback , follow up queries or suggestions kindly 'Submit a Ticket' with us.
Support | Zephyr



Issues with test executions export in Zephyr for JIRA server

Created on

Problem statement:

Test Executions export is not working in Zephyr for JIRA server

 

Summary:

Test executions export to csv or excel do not work at some times. The reason for this issue could be missing test step execution statuses (no status at all). It may be observed that there may be a single execution that prevent the bulk export from completing. Only the progress bar is shown and actual export file is not downloaded. 

When the problematic executions are unchecked the export takes place as expected. 

 

Solution:

Connect the the database that is configured with JIRA.

Please use the below SQL queries to find out all the steps that have empty execution results.

SELECT "SCHEDULE_ID", "STATUS" FROM "AO_7DEABF_STEP_RESULT" WHERE "STATUS" is NULL;
SELECT "SCHEDULE_ID", "STATUS" FROM "AO_7DEABF_STEP_RESULT" WHERE "STATUS" NOT IN ('-1', '1', '2', '3', '4', '5');

Once you have the results for any of the above queries, You can go to Tests => Search Test Executions and use the below mentioned zql query to filter the executions that contain the steps with no results. Please use the SCHEDULE_ID found in the above queries and use it in the in query below.

execution in (65, 78)


Environment:

Jira

Zephyr for Jira Server version. 


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