DB Maint.: Restoring Deleted Cuts

The following procedure applies to Bundle-Track versions 3.6 and above.

You may be able to restore a deleted Cut. When you delete a Cut, the records remain in the database in a hidden (but recoverable) form until both of the following have occurred:

• The Cut's ticket scans have fallen beyond the period of Historic Production Detail Protection.
• Your database has been compressed.

Also, in order to restore a Cut, its parent Lot must not be in a deleted state. If the parent Lot has been deleted, you must restore the Lot before you can restore the Cut.

Procedure:

1. Confirm that the Cut's parent Lot is visible in Bundle-Track.
   • Open your Lots list and locate the Lot. If it is not there, you will have to restore the Lot before you can restore the Cut.
      
2. Identify Lot Code of the Cut's parent Lot. 
    
3. Get ISQL ready to run your commands.
   • If you don't know how, click here to learn, and then return.
      
4. Copy and Paste the following code into ISQL:
   

   Select LOTMASKEY from LOTMAS where LOTMASLAB='ZZZZZ';

   
    
5. Edit that code, replacing ZZZZZ with the Lot's Code.
   • Keep the single quotes.
      
6. Click the Lightning Bolt icon to execute.
    
7. Note the Lot's LOTMASKEY.
    
8. Copy and Paste the following code into ISQL:
   

   Update TPSMAS set ACTIVEINFO = 'T' where LOTMASKEY = ZZZZZ; Commit;

   
    
9. Edit that code, placing the LOTMASKEY you noted above in place of ZZZZZ.
    
10. Click the Lightning Bolt icon to execute.
     
11. Exit ISQL and IBConsole.
     
12. In Bundle-Track, confirm that the Cut has been restored.
    

We welcome your comments at support@bundle-track.com.

If you would like our live assistance, you may hire us at our professional services rate.