English

How To: Release locked features from an ArcStorm layer

Summary

This document describes two methods to release locked features from an ArcStorm layer.

Procedure

 

  • Automatic release of locked features (recommended):

    1. Find the value of the transaction-id
     
    a) Use the SchemaEdit LISTTRANSACTIONS command to find all the existing valid transaction-id values.
     
    Code:
    SchemaEdit: LISTTRANSACTIONS
    Listing transactions for Database: sample_db (2 found)
    
    	12 CHECKOUT_COMPLETE user
    	14 CHECKOUT_COMPLETE user

    b) Record the transaction-id values and quit SchemaEdit.

    c) Open the layer in ArcEdit and make it editable.

    d) Select the features that are not associated with a valid transaction.
     
    Code:
    arcedit: SELECT lock__id <> 0 or lock__id <> 12 or lock__id <> 14
    2 element(s) now selected
    
    arcedit: LIST lock__id
     
    Note:
    	The lock__id and transaction-id are the same value.
    2. Run the RECOVERDB command in ArcPlot.
     
    Code:
    RECOVERDB LIBRARY <asdatabase>.<library> <transaction_id>
  • Manual release of locked features (caution is required):

    1. Find the value of the transaction-id.
     
    a) Use the SchemaEdit LISTTRANSACTIONS command to find all the existing valid transaction-id values.
     
    Code:
    SchemaEdit: LISTTRANSACTIONS
    Listing transactions for Database: sample_db (2 found)
    	
    	12 CHECKOUT_COMPLETE user
    	14 CHECKOUT_COMPLETE user
    

    b) Record the transaction-id values and quit SchemaEdit.

    c) Open the layer in ArcEdit and make it editable.

    d) Select the features that are not associated with a valid transaction.
     
    Code:
    arcedit: SELECT lock__id <> 0 or lock__id <> 12 or lock__id <> 14
    2 element(s) now selected
    	
    arcedit: LIST lock__id
     
    Note:
    The lock__id and transaction-id are the same value.

    2. Locate the tiles that contain the locked features.
     
    Code:
    Arcedit: select lock__id <> 0
    Arcedit: setdrawsymbol 2
    Arcedit: mapextent select
    Arcedit: backcoverage .index 4
    Arcedit: backenvironment polygon
    Arcedit: draw
    Arcedit: apc polygontext .index tile-name 

    Record the tile numbers that contain a locked feature.

    3. In SchemaEdit, use the SETEDITMODE command to make the layer editable.
     
    Code:
    Schemaedit: SETEDITMODE layer <library> <layer> all edit 

    4. Visit each of the tiles recorded in step 2 and use ArcEdit to calculate the locked features back to 0.
     
    Code:
    Arcedit: EDITCOVER <layer>
    Arcedit: EDITFEATURE <feature class>
    Arcedit: SELECT lock__id = <transaction-id>
    Arcedit: CALCULATE lock__id = 0
    Arcedit: SAVE
    Arcedit: QUIT 

    5. Set the edit mode back to protect with the SETEDITMODE command.
     
    Code:
    Schemaedit: SETEDITMODE layer <library> <layer> all protect