Bulk edit of a deployment task?

[burt repine]

We have hundreds and hundreds of deployment plans that contain a task that uses a now defunct 'linked repository'.

We would like to have the tasks updated to use the new repository but were hoping for a non-manual way of doing it?

Thanks for the help.

[Anik Sengupta]

Hi Burt,

Thanks for your question.

May be you can try the workaround mentioned in the BAM -

https://jira.atlassian.com/browse/BAM-18273

This can be done using a database update:

1. Stop Bamboo
2. Back up your Bamboo database for restore/recovery purposes
3. Run the following update query, replacing <old-url> and <new-url> as needed:

PostgresDb:
update VCS_LOCATION as V

set xml_definition_data = replace(xml_definition_data,'<old-url>','<new-url>');

MSSQL Server: 

update VCS_LOCATION  set XML_DEFINITION_DATA = replace( cast( XML_DEFINITION_DATA as nvarchar(max) ),'<old-url>','<new-url>');

 Note: If you are using a port other than 22, you will also need to amend the port number to the new URL or configure port forwarding from the default port (22) as explained in this KB article.

4. Start Bamboo

Regards,
Anik Sengupta
**please don't forget to Accept the answer if your query was answered**

[Anne Li]

Hi Annie,

We did as you suggested, it worked. but one thing is bothering: after the replacement, the repository loading is extremely slow, more than 1 min, all other repos are normal, just this updated one. from both deploy plan or linked repository page.

any suggestions?

thank you!

Anne