Skip to content
+1-888-319-3663

COMMUNITY FORUM

Database cleanup

asked 11 months ago

I’d like to do some cleanup in the SmartConnect database to prevent its growth.

It seems safe to delete records older than 5 days from TraceLine, TraceHeader, ProcessErrors and LogEventLog according to the article “Moving SmartConnect to a new server” and the link to the cleanup script.

Does anybody know if it is safe to also delete rows from StatsShedulerId and MapRunActivity?

I am running SmartConnect 21.1.0.471 on premises.

Thank you

Answers
Ethan Sorenson Staff answered 3 months ago

Yes it is safe to clear records from these two tables (StatsSchedulerId and MapRunActivity). These are just historical log tables and do not impact product function.


If you would like to submit an answer or comment, please sign in to the eOne portal.