Conference allvax::team-see

151.0. "PCMS unreserve/cancel chk out Problem" by STOSS1::HORVATH () Wed Mar 26 1997 13:12

    Hello,
    
    Hope someone is still monitoring this conference.
    
    Using Cwx 2.2 Team/SEE v1.3 PCMS 4.0.5.1 Oracle 7.0.16.
    
    I realized a problem in reserving a product item from the PIB. 
    
    The problem is known to PCMS and has a work around solution as follows:
    
    "1173: Error item uid ##### does not exist"
    
    This problem is caused by there being an entry in the table cm_impacts
    for a non-existent item_uid, most likely that of an item that was
    related.  
    
    In all my example cases where this has occured, its been with related
    items.  
    
    Entries show up in cm_impacts which references an item which nolonger
    exists for whatever reason.  
    
    SQL software's work around is to do following:
    
    select affect_uid from cm_impacts where impact_type='I'
    minus select item_uid from items
    
    delete from cm_impacts where impact_type ='I'
    and affect_uid = #####    
    
    This works.  
    
    One way to replicate this problem is by using the unreserve options 
    from MB3 in the PIB for a specific product. I believe the unreserve
    feature is a Team/SEE customized option.  If so is there a 
    patch for this problem?  
    
    Once an item is reserved to the desktop the MB3 options allow a 
    "cancel checkout".  This option also will cause the 1173 error.  Is
    this also a Team/SEE Customized feature?  
    
    *********************************************************************
    Could someone please explain the unreserve and cancel checkout options
    and how they are suppose to work?  
    
    If one manually removes an item from the response_to block from the
    change control (show links) menu, this error can be avoided.  
    
    In other words, before one unreserves or issues a "cancel checkout"
    they should use the selected option in "change control" to remove the
    item from the reponse_to block.  When this is done the user will not
    get the 1173 error when using the unreserve or "cancel Checkout"
    options. 
    
    
    Thanks,
    
    
    
    

COHESION Team/SEE is still being supported and this conference is still being 
monitored. 

The problem you have reported is caused by an inconsistency being created in 
the Oracle data that describes the PCMS items under CM. As you have noted,
SQL has provided instructions to repair such an inconsistency. The "easy" way
to create such an inconsistency is by using Team/SEE in the way you describe
but it is also possible to create it directly from within PCMS V4.0.5. (I do
not know if it is prevented in later versions of PCMS Dimensions.) Thus it is
not just a case of patching Team/SEE.

Anyway, there is no patch that I'm aware of that will _prevent_ this behavior.
The only response I can offer at this point is that you should be careful to 
not cancel checkout or unreserve items that still have an association
with a change document. These items must be dis-associated with the change 
document first. 

I have checked the release notes and find that this problem is _NOT_
documented
in that place. (It is noted in some guidelines that are used when
we provide demonstrations but these are not suitable for customers.)

If you wish to try to elevate this issue, Andy Starvaski is still handling the

support line and will be able to advise you what your options are and how to 
proceed.

[Posted by WWW Notes gateway]