Need some delete advice

[msteffke]

Somebody checked in this generic and its version 2.3 (first thing in
list below, 161-b6i-0005). They want it deleted. I am deleting, using
the Delete Latest Iterations option. When I try to delete it fails,
saying it cant delete (the last 3 objects) because they are rev 1.0.

What to do here?



Running WC9.1 I have admin rights. Thanks, Mark







Mark Steffke

Engineering System Administrator

The Delfield Company

Manitowoc Foodservice

T 989.775.9215 or 989.773.7981, ext 12484

Integrity, Commitment to Stakeholders, and Passion for Excellence




This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

[RandyJones]

On 01/24/14 10:56, Steffke, Mark J wrote:
>
> Somebody checked in this generic and its version 2.3 (first thing in list below, 161-b6i-0005). 
> They want it deleted.  I am deleting, using the Delete Latest Iterations option.   When I try to
> delete it fails, saying it cant delete (the last 3 objects) because they are rev 1.0.
>
> What to do here?
>

I ***** doesn't it?
The delete function in Windchill can't handle this simple task which was trivial in Intralink 3.x.

The problem is that you need to simultaneously delete the latest iteration of the generic and all
iterations of the 3 instances. The brain dead Windchill delete can't handle this. I have done this
by some back door work. You most certainly want to try this on a test system. And this is assuming
the only instances checked in with generic 2.3 were the 3 in question.

So my steps are going to do this:

1. revise the generic to create a new version 3.1
2. change generic version 3.1 to 3.2 via oracle
3. change generic version 2.3 to 3.1 via oracle
4. delete latest iteration of generic 3.2
5. delete all iterations of generic 3.1 and the 3 instance 1.0's

And these are the steps to do this

1. Revise the generic (and only the generic) to create Version 3.1
      * This will create a new entry in the epmdocument and the controlbranch oracle tables
2. using a sql editor (ie Oracle SQL Developer) get the epmdocumentmaster, epmdocument, and
    controlbranch oracle tables showing
3. filter epmdocumentmaster on the generic: CADNAME = '161-b6i-0005.prt'
      * find the ida2a2 column and copy this value
4. filter the epmdocument table on IDA3MASTERREFERENCE = 'ida2a2 just copied in step 3'
      * sort by VERSIONIDA2VERSIONINFO and then by ITERATIONIDA2ITERATIONINFO
      * VERSIONIDA2VERSIONINFO column == the revision
      * ITERATIONIDA2ITERATIONINFO == the iteration
5. filter the controlbranch table on IDA3B5 = 'ida2a2 just copied in step 3'
      * VERSIONID == the revision
6. in the epmdocument table for generic 3.1
      * change ITERATIONIDA2ITERATIONINFO from '1' to '2' and commit
      * this changes generic 3.1 to 3.2
      * after doing this you can have another look at the history page and see this change
7. in the epmdocument table for generic 2.3
      * change LATESTITERATIONINFO from '1' to '0'
      * change VERSIONIDA2VERSIONINFO from '2' to '3'
          o this changes it to revision 3
      * change VERSIONSORTIDA2VERSIONINFO to same as generic 3.2
          o this tells windchill how to sort the revisions
      * change ITERATIONIDA2ITERATIONINFO from '3' to '1'
          o this changes it to iteration '1'
          o after this it is now 3.1
      * change BRANCHIDITERATIONINFO to same as generic 3.2
          o this changes it to the correct controlbranch table record
      * commit the changes
8. in the epmdocument table for generic 2.2
      * change LATESTITERATIONINFO from '0' to '1'
      * commit
      * copy the ida2a2 value for use in the next step
9. in the controlbranch table for version 3(VERSIONID field)
      * change ida3c5 to the value copied in step 8
10. At this stage we are finished with oracle table modifications and if you take a look in
    Windchill you will see the generic now has ..., 2.2, 3.1, and 3.2 versions
11. Delete the generic 3.2 (and only the generic): latest iteration
      * you have to remove all other items from the delete dialog
      * when you select OK you are deleting all items left whether they are checked or not
12. delete generic 3.1 and the 3 instances 1.0: All iterations

> Running WC9.1 I have admin rights.    Thanks,   Mark
>
> *Mark Steffke*
>
> Engineering System Administrator
>
> The Delfield Company
>
> Manitowoc Foodservice
>
> T 989.775.9215  or  989.773.7981, ext 12484
>
> /Integrity, Commitment to Stakeholders, and Passion for Excellence/
>
>
> ----------


--
------------------------------------------------------------------------
Randy Jones
Systems Administrator
Great Plains Mfg., Inc.
1525 E North St
PO Box 5060
Salina, KS USA 67401
email: -
Phone: 785-823-3276
   Fax: 785-667-2695
------------------------------------------------------------------------