Remove transactions that track deleted entries.
If the application is set up to track the changes a user makes to fields, then you will need to run Delete Tracking Information to remove the older entries to the tracking change log. It's best to back up each database before deleting the tracking change log.
Important! This routine can be set up to delete orphan records. An orphan record is a record that is not tied to an existing record.
Back up the database. See the help topic titled How do I back up a database?
1. Open Connect System Management > System Tools > Delete Tracking Information.
2. What is the name of the application with the change log?
Select the application name from the Application drop-down list.
3. How far back do you want to keep entries in the tracking change log?
Enter a MM/DD/YYYY in the Delete Tracking Information Prior To field. The routine will delete all of the entries that were created before the entered date.
4. What type of transactions do you want to delete from the tracking change log?
I want to delete history and management tracking. Select History and Management Tracking in the Delete field.
I want to delete only history tracking. Select History Tracking in the Delete field.
I want to delete only management tracking. Select Management Tracking in the Delete field.
5. Click GO (CTRL+G).
The tracking change log has been deleted.
1. Open Connect System Management > System Tools > Delete Tracking Information.
2. What is the name of the application with the change log?
Select the application name from the Application drop-down list.
3. How far back do you want to keep entries in the tracking change log?
Enter a MM/DD/YYYY in the Delete Tracking Information Prior To field. The routine will delete all of the entries that were created before the entered date.
4. Set up the Delete Orphan Records checkbox.
An orphan record is a record that is not tied to an existing record.
Do you want to delete orphan records?
Yes, I want to delete orphan records. Select the Delete Orphan Records checkbox.
No, I do not want to delete orphan records. Leave blank the Delete Orphan Records checkbox.
5. Click GO (CTRL+G).
The orphan records have been deleted.
Copyright © 2020 Caselle, Incorporated. All rights reserved.