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