Sometime, for troubleshooting purpose, we will do the db refresh from Production database to Dev database.
After the refresh, some data are using Production data.
So, we have a script which we will execute it after db refresh.
One of the script as below: (this sql is to update the Email Handler's Forward Email from Prod email account to dev email account (firstname.lastname@example.org)
--set the notification addresses for mail services
SET propertyvalue = 'email@example.com'
WHERE id IN (SELECT id
WHERE property_key = 'forwardEmail'
AND entity_name = 'ServiceConfig'
AND propertytype = 5);
From table, propertystring, I can see the propertyvalue has been updated to firstname.lastname@example.org.
When go to GUI, Log in to Jira > System > Incoming Mail ( we can see lists of Mail Handlers) , at this page, Under Properties, you can see the Forward Email: email@example.com.
But, problem now is if you click on Edit (for any of the Email Handlers), click Next (go to second page for mail Handler configuration), at Forward Email, it will state firstname.lastname@example.org(Production email account).
Can anyone advise any field in database that I miss out to update it? Thanks.
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot