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



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