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

#4135 - 10 M records in Smartlist_queue table!

Closed Bug? created by paulrogan Verified Purchase a year ago

Hi Support,

We have deactivated the SmartList scheduler as we do not use this functionality (we are managing list criteria in Sugar directly). Doing that we thought this feature was not running but we noticed this morning that we had 10 Million records in the Smartlist_queue table.

20,000 records were created today in this table. Analysing the data we also found that there were a lot of contact duplicates in this table.

Can you please help us prevent this from happening?
Thanks!

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    a year ago

    Hi Paul,

    Thanks for reaching out. You should be able to deactivate the SmartList from the Schedulers page. So that I can take a closer look, can you navigate to SugarChimp's Health Status and click "view scheduler" under "SmartList Scheduler Status" and send a screenshot of what appears? You can send this privately to mailchimp@fanaticallabs.com.

    Thanks!
    Heidi

    • paulrogan member avatar

      paulrogan Verified Purchase

      a year ago

      We have just sent you the requested screenshots (email from Alex)

  2. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    a year ago

    Thanks for that, Paul! I do see the SmartList is inactive. It's worth noting the Smartlist_queue will continue to grow as long as there are records being pushed to the queue. Making the scheduler inactive, however, will prevent those changes from being processed.

    Can you tell me what your list sync settings are? To do this:

    1. From Sugar Admin, click on Sync Settings
    2. Choose your Sugar Target List at the top and click Continue to Step 3
    3. For Contacts, Targets, and Leads (you can select them along the top) do you have "Only sync Contacts added to the Target List over to Mailchimp." or "Sync All SugarCRM Contacts automatically to the Audience." selected? You'll want to check these settings for all Target Lists you're syncing to Mailchimp.

    Also, are there lists you were previously syncing, but have since removed?

    Thanks for your help in troubleshooting.

    Heidi

  3. paulrogan member avatar

    paulrogan Verified Purchase

    a year ago

    Hi Heidi,

    Thanks for your answer. So are you saying that we cannot prevent the records to be created? Can we purge that table without compromising the sync with Mailchimp?

    Here is the setting we have:
    Screen Shot 2019-06-06 at 10.11.29 am.png

  4. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    a year ago

    Hi Paul,

    As long as the top option (in your screenshot shown below) is initially set for Contacts, Targets, and Leads for all the lists you're syncing, the number wouldn't grow. However, it sounds like you may have previously (prior to turning off the scheduler) had other options set so it's worth checking the smartlist table for any records where active=1. You can set these to active=0 for all those rows to ensure nothing is queued to the table. Here's the statement:

    UPDATE smartlist SET active='0';

    You can also empty the smartlist by using the following:

    TRUNCATE smartlist_queue;

    Let me know if you have any trouble with this process.

    Heidi

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "The team is always proactive in assisting with any questions. Keep up the great work! Great product and great support!"

    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.