Backup and Restore of Agile Application to another SN instance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-16-2019 05:51 AM
We are currently utilizing the Agile application in our Test instance. This was done as we were initially using the tool at the recommendation of our implementation partner. We have found the tool useful and plan to continue using it in production. We have purchased licenses and now need to migrate the data from Agile Test to Agile Production.
In addition, we had a need to clone our Production environment over our Test environment to facilitate other project work occurring in Test. We backed up several tables via XML export and then re-imported the tables via XML import. What we are finding is the Activity Formatter on the rm_story table is replicating the user and date/time for the Work Notes field in some cases using the created date as the date and the created by as the user in the formatter.
We opened a HI incident with SN support and they restored a pre-clone backup to a temp instance of SN. We have tried many different ways to restore the tables but the activity formatter is still replicating in some cases. We can't clone over Test again as we have other project work going on there. We also need to replicate this same type of restore process when we move the Agile data to production. Any ideas how we can repair the activity formatter content?
- Labels:
-
Best Practices
- 1,286 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-02-2020 06:08 AM
We are attempting something similar in our DEV prior to a PROD cloneback (all in Madrid), but are running into issues. We keep our Agile stories and products in DEV, but are having trouble backing it up into TEST. I've moved all of our Story, Product, Sprint and Epic table data successfully, but none of the update sets grabbed the related Journal Entries, History, or Audit Sets from PROD (we used a direct connection for the update, but a test of a remote XML export didn't pull them either).
I'm currently trying to figure out a database left join that will query only the story-referenced activity records in these three tables, but haven't worked on Java-SQL recently and incredibly time-consuming. Were you able to pull all your associated Agile data at once, did you have to do it table-by-table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2020 01:58 PM
Sorry for the late response on this. We had to go through table by table and perform XML export and imports. We cleared the record history tables which get rebuilt from the sys_audit table upon open of the record.