AlistairFrith

Deleting AF trees

Discussion created by AlistairFrith on Mar 5, 2014
Latest reply on Mar 6, 2014 by pcombellick

We have an AF hierarchy with 3 large trees. I need to delete the largest tree, which has tens of thousands of elements within it, before running a custom application to re-create it. Unfortunately, I am having difficulty with this.

  • First I deleted all the elements under the top of this tree, about 300 in all with the others thousands below them.
  • Then I tried to check this change in. After about 10 minutes it timed out.
  • So I tried undoing the checkout. Again it timed out after about 10 minutes
  • Then I exported the rest of the AF database to a file, intending to create a new DB and re-import. 
  • Then I tried to rename the existing database. Again, this timed out after about 10 minutes.
  • Then I tried to delete the AF database but had to go home before it completed.
So my question is, what is the best way to do this and how can I recover from it? As a last resort, I can delete the PIFD SQL database hosting the AF database if that will help, but I need to know the best way.
--- Alistair.

Outcomes