What is the use of table MX_U ? Can we cleanup old records ?
Is there any built-in cleanup mechanism for THREESIXTY_OUTPUT_HISTORY and PERSON_LOGIN_HISTORY ? If no, should we consider cleaning up old records?
It seems that the CONTACT table also holds the same records as present in TASK_CONTACT table. When archiving, the TASK_CONTACT are getting archived but not from the CONTACT table. How can we archive CONTACT records as well ?
Best answer by Erin McQuestion
As quoted from Aaron Sleight: “That table (MX_U) is used internally for usage tracking purposes that could aid in troubleshooting. The data does not need to be persisted long term though, so if you are finding that it is consuming too much storage in the database, you can safely truncate the table periodically without fear of doing harm elsewhere.”
There is no built-in mechanism for these two tables, as well as quite a few others. If desired, you could create a Scheduled Process to periodically delete records of a certain age.
The data in the Contact table is not considered to be transactional, as the Task Contact table is. You can configure Metadata to archive Contact data if desired, however the archiving process will remove the source data records. So if those contacts are still valid for the Place, Contact, Product, Project, etc., for which they were created, they would need to be added back when needed.
As quoted from Aaron Sleight: “That table (MX_U) is used internally for usage tracking purposes that could aid in troubleshooting. The data does not need to be persisted long term though, so if you are finding that it is consuming too much storage in the database, you can safely truncate the table periodically without fear of doing harm elsewhere.”
There is no built-in mechanism for these two tables, as well as quite a few others. If desired, you could create a Scheduled Process to periodically delete records of a certain age.
The data in the Contact table is not considered to be transactional, as the Task Contact table is. You can configure Metadata to archive Contact data if desired, however the archiving process will remove the source data records. So if those contacts are still valid for the Place, Contact, Product, Project, etc., for which they were created, they would need to be added back when needed.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.