Database Maintenance

Validate Database

This report checks the STS database for any broken links that may be due to database objects having been removed after the simulation is running or because of other events that may have corrupted some of the database components.
Locations without a valid link to a station These locations will not be displayed on the List Locations screen because of the broken link. Use the Fix Ghost Locations function to remove these locations.
No Location link errors found
Shipments with invalid links To repair these shipments, use the Edit Shipment screen and select a replacement for the missing item. If necessary, create a new item to replace what is missing and then link the shipment to it.
No Shipment link errors found
Cars with invalid links To repair broken Car Code, Status, Current Location, Home Location and Job links, click on a car's reporting marks and use the Edit Car screen to select a replacement for the missing item. If necessary, create a new item to replace what is missing and then link the car to it. Cars that have been assigned to car orders can have missing Loading and/or Unloading locations if the shipment associated with that car order has broken links to those locations. (See Shipments with Invalid Links above.)
No Car link errors found
Cars shown as Empty but may still be loaded Any car with a status of Empty should not be shown as having a consignment. Use the Find and Fix Empty Cars having Consignments function to repair these problems.
No Cars with the Empty/Loaded conflict found
Orphaned Cars These repositioned cars are assigned to car orders which are missing their links to an unloading location or the cars have a status code other than "Ordered." Use the Find and Fix Orphaned Cars function to repair these problems.
No Orphaned Cars found
Incomplete Waybills These waybills were not closed out when the cars attached to them were unloaded at their final destination. Use the Find and Fix Incomplete Waybills function to repair these problems.
No Incomplete Waybills found
Job Steps without a valid link to a station These job steps will not be displayed in the Job Step list because of the broken link. Use the Fix Ghost Job Steps function to remove the missing steps, then recreate the job step and link it to an existing station.
No Job Step link errors found
Ghost Cars These cars are referenced in car orders but don't exist in the cars database. Use the Fix Ghost Cars function to remove these car orders.
No Ghost Cars found
Ghost Trains These jobs/trains, while no longer in the database, still have job steps associated with them that are taking up resources and may cause database corruption. Use the Fix Ghost Trains function to eliminate each ghost job's abandoned steps.
No Ghost Trains found
Illegal Characters in Reporting Marks Reporting marks may only consist of alphabetic letters. The & is not allowed. Use the Fix Reporting Marks function to remove illegal characters.
No illegal characters found in reporting marks