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