Having issue with our Importer utility for Zephyr for Jira Cloud.Please click here for the steps to resolve the issue. We want to make you aware that during Week 9 of the downtime schedule provided below, we will be migrating your Zephyr for Jira and ZAPI cloud instances as part of our GDPR and Atlassian privacy policy compliance efforts. Schedule : Friday, 04/19/2019 from 9:00 PM PST up until Sunday 04/21/2019 10:00 AM PST
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