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

Unable to import requirement after migration of Zephyr from SaaS instance to On-Prem

Created on

Problem: Getting error message while importing the requirement after migration Zephyr from SaaS instance to On-Prem. Error message (The user specified as a definer ('zephyr'@'localhost') does not exist') and attached screen shot also.


Cause: Zephyr SaaS uses "zephyr" username and on-premises uses "root". During the import the ownership of view is unclear, so getting the error. 


Fix: Perform the below steps 

1. shut down zephyr.
2. Login with root user
3. use <itcc> ;
4. Execute these SQLs. These will drop/recreate the views.
These are shipped along with startupdata itself. NO change here.

DROP VIEW IF EXISTS `release_testcase_count`;
DROP VIEW IF EXISTS `release_testcase_count_intermediate`;
CREATE OR REPLACE VIEW `release_testcase_count_intermediate` AS
( select `rtm`.`requirement_id` `reqId`, tc.release_Id `relId`
from (`requirement_testcase_mapping` `rtm` left outer join `testcase` `tc` on `rtm`.`testcase_id` = `tc`.`id`));

CREATE OR REPLACE VIEW `release_testcase_count` AS
(select reqId as `requirement_id`, concat(relId, ':', count(relId)) as `tcCntbyRel` from release_testcase_count_intermediate as counttbl group by relId, reqId);

5. Start zephyr.



Title:               Unable to import requirement after migration Zephyr from SaaS instance to On-Prem

Product:            Zephyr Enterprise/Saas

Version:             All

Summary:         Update the DB to modify the requirement view to root from zephyr user.


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