Corrupted WTPart number

[ydubhashi]

Hello,

We have a set of WTPart part number. We are unable to load them in Windchill as it gives an error message of "Uniqueness"; neither we can find (search) them in Windchill, so that we can delete the set and reload them or modify them.

These WTPart part numbers were loaded in Windchill earlier as NLAG file type. Later the file try was changed to ZKIT file type. Once the file type was changed, the part numbers were vanished from the system. I am able to view the details through SQL query, but unable to locate them in Windchill and delete them.

We change the part type with the process that are listed in the document number CS7287 (https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS7287&posno=1&q=ChangeTypeSql&source=search).

Please review and suggest.

Thanks,

Yogesh

[bsindelar]

Yogesh,

If you are able to find the WTPart numbers in the WTPartMaster table, then they still exist.  Try these queries (assuming you are using Oracle as the DB):

select a.wtpartnumber as THE_NUMBER,b.namecontainerinfo as THE_CONTEXT, 'Product' as CONTEXT_TYPE

from wtpartmaster a

join pdmlinkproduct b on (b.ida2a2=a.ida3containerreference)

where a.wtpartnumber in ('number1','number2','number3', etc... )

union

select a.wtpartnumber as THE_NUMBER,b.namecontainerinfo as THE_CONTEXT, 'Library' as CONTEXT_TYPE

from wtpartmaster a

join wtlibrary b on (b.ida2a2=a.ida3containerreference)

where a.wtpartnumber in ('number1','number2','number3', etc... )

order by THE_NUMBER;

This will give you the number, context it is in, and whether that context is a product or library.  It will NOT give you the folder location, but you can then do a WC GUI search in that context as a user who is a Product/Library Manager, and that should get you around any ACL issues in seeing the WTParts.