by Fanatical Labs

Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.

Free 30 day trial
Try it Now

#3616 - Sugarchimp table size

Closed Bug? created by janin a year 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

    a year 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

    a year 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
  • "Support was fantastic. Great bit of programming and we will be using it for the foreseeable future."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.