The Infor CRM (formerly Saleslogix) database uses the GLOBALCHANGETRACKING table to track changes. Over time, the number of deletes recorded in the table can grow quite large, as there is no built-in process to get rid of them. This can cause an issue with some processes, such as syncing mail. The sync process wants to check if an item has been deleted, so it can slow down or fail if the number of deletes is too high. If you are running some sort of email sync, and it having issues completing, one possible solution is to purge the GLOBALCHANGETRACKING table of all its old delete records. This table records deletes as change type 1, so you can use the following query to list all of the delete records:
Select * from sysdba.GLOBALCHANGETRACKING
where CHANGETYPE = 1
To actually delete those records, use the query:
Delete
FROM sysdba.GLOBALCHANGETRACKING
where CHANGETYPE=1
Remember all standard SQL warnings apply. Running change and delete queries without a “where” will affect the entire table, always a good idea to back up the database first in case you make a mistake.
