by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so you can work in your preferred app. Segment and group your Mailchimp subscribers based on Sugar data so you can market to the right people at the right time. Compatible with all versions and editions of Sugar and SuiteCRM. Created by Fanatical Labs, 2023 SugarCRM Partner Award Winner.

Free Trial

By clicking you consent to share your profile with the developer

#3616 - Sugarchimp table size

Closed Bug? created by janin 6 years ago

I having several problem with sugarchimp. The table of sugarchimpactivity is huge 4.1gb, sugarchimp 3.4gb and sugarchimpactivity_contact 1 gb. When I try to go to the healt status I have an error message of timeout.

  1. fanatical_jon member avatar

    Jon S Provider

    6 years ago

    Hello there,

    The sugarchimpactivity table can grow quite large as we store all MailChimp Activities that come in. The same goes for the sugarchimpactivity_contact table, as it holds those relationships. This is a situation where your client might not care about activities that are a year old from MailChimp, so you can delete those without harming their data. That is something you can ask them about that could help free up some space.

    However, the sugarchimp table should be quite small, as it should be our queue of items waiting to be processed. Since this is so large, then I suggest we get on a call together to figure out what could be going wrong. Can you schedule a time for us to meet here: https://calendly.com/fanaticallabs/sugarchimp-support

    We should be able to figure out what's going on with that sugarchimp table.

    Thanks, Jon

  2. fanatical_jon member avatar

    Jon S Provider

    6 years ago

    Hello,

    I just wanted to update the support case to say that we are finding many scheduler failures in your logs for all of our jobs, as well as the process author jobs. We are going to look over the logs you've sent to us and we have scheduled a second call for Monday morning to look at the state of the integration again.

    Thanks for your patience as we debug the issue with your schedulers.

    Kind Regards, Jon

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Does a great job of syncing all of our registrant information. They go the extra mile with one-on-one support!"

    Read More Reviews