DB Maint.: Restoring Deleted Lots

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

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

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

Procedure 1 (within Bundle-Track):
Use this method if your version of Bundle-Track offers it. Otherwise, try Procedure 2.

1. In Bundle-Track, menu select Activities / Purge and Recover Lots / Recover Lots.
    
2. Use this tool to recover the Lots you want.

Procedure 2 (within ISQL):

1. Get ISQL ready to run your commands.
   • If you don't know how, click here to learn, and then return.
      
2. Copy and Paste the following code into ISQL:
   

   Select * from LOTMAS where ACTIVEINFO = 'F';

   
    
3. Click the Lightning Bolt icon to execute.
    
4. Identify the Lot you want.
   • The LOTMASLAB column lists Lot Codes.
   • The LOTMASDES column lists Lot Descriptions.
      
5. Note the Lot's LOTMASKEY.
    
6. Copy and Paste the following code into ISQL:
   

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

   
    
7. Edit that code, placing the LOTMASKEY you noted above in place of ZZZZZ.
    
8. Click the Lightning Bolt icon to execute.
    
9. Exit ISQL and IBConsole.
    
10. In Bundle-Track, confirm that the Lot 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.