Forum

The forum is a free service supported by community members. Please consider opening a support ticket if you need timely help.

PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04 Aug 2017 04:22 AM by  Steve L
On upgrade dozens of notifications sent to the same customers
 5 Replies
Sort:
You are not authorized to post a reply.
Page 1 of 212 > >>
Author Messages


New Member


Posts:
New Member


--
20 Jul 2017 11:28 AM
    We have faced this problem with every upgrade of Revindex Storefront. It is a very costly mistake. So, I want to make sure that we get this right, this time.

    We recently upgraded from V 7.6 to the latest version of the storfront - V 11. The upgrade went smoothly however there were 10,000+ emails sent to our customers - dozens to the same person. As you can imagine, our customers are not pleased with this and we are sure to lose some over this issue.

    Since, this is a major upgrade to the DNN installation - we went from V 7.2.2 to V 8 - and multiple modules it involved many steps and stops and restarts of the appool and website etc. So, it is hard to note down the steps taken along the way. In any event, we are trying to solve a bigger issue - how do we proceed so this doesn't happen ever again.

    Please help me understand a few concepts so we can devise a solution:

    • Upon upgrade does Revindex Storefront automatically enable its scheduler jobs (recurring subscriptions, notifications ..) and override current settings? (we had disabled all scheduler jobs prior to upgrade)
    • Does the Revindex Storefront use core messaging dispatch service? (we did not disable messaging dispatch)
    • Is there a message queue created that can be accessed and deleted before it kicks in? (we want to remove SMTP credentials prior to upgrade so no emails are sent. However, if there is a message queue then it might kick in after the server is in production and SMTP credentials are restored!)
    • Is there a flag or other mechanism to make sure a customer gets only one notification? If so, where can we find that flag in the tables?
    • Any suggestions to upgrade without facing this issue? Why would multiple emails be sent to the same customer?

    Appreciate the work that you do, Stephen, and we really like the Revindex Storefront but this is a very big deal for us. Please help resolve it.

    Thanks!

    0


    New Member


    Posts:
    New Member


    --
    27 Jul 2017 01:26 AM
    • Accepted Answer

    Stephen,

    I reported this problem 6 days ago - no response from you! Today, we moved the installation from one website/appool to another and it sent out 4,000+ recurring order reminders to all our members who are up for renewal in three days!!!!!

    This program is in a loop - will you please respond?

    0


    New Member


    Posts:
    New Member


    --
    27 Jul 2017 02:10 AM
    • Accepted Answer

    Further investigation suggests the following is going on:

    1. By default, communications emails are active for ALL portals in the installation even if it doesn't use the shopping cart (we have 15 portals defined)
    2. Each time we stop and start an app pool the scheduler processes communication emails for EACH alias for EACH portal

    So, if an installation has 80 aliases assigned to 20 portals each app pool recycle will send thousands of emails TO THE SAME PERSON - even if they are on one portal.

    Unbelievable!!!!

    0


    New Member


    Posts:
    New Member


    --
    27 Jul 2017 10:49 AM
    • Accepted Answer

    Just checked the logs - Revindex Storefront Scheduled jobs - which are scheduled to run once every day - ran 2,000+ times in less than 30 minutes last night.

    Some members' recurring orders were processed 10 times resulting in their cards being charged 10 times.

    We are on day 7 of no response from you.

    0


    Veteran Member


    Posts:2957
    Veteran Member


    --
    27 Jul 2017 04:13 PM
    • Accepted Answer

    Hi Sourabh

    I apologize for the delay but I wished you had waited to get an answer before upgrading. We're currently experiencing an unexpectedly high number of support requests so we have little time to monitor the Community Forum. Also, you should not rely on the Community Forum for urgent matters. You should open a High priority support ticket instead. The Community Forum is completely "community" driven and we're not expected to provide a reply although we often do to help out.

    Oddly enough, we don't have anyone reporting any issue with the email sending out excessively on upgrade or restart (which may explain also why no one else from the community replied to your forum post since they never experienced the same issue). It might be your particular version of DNN or Storefront?

    What email exactly are you seeing going out (order invoice, order receipt, recurring reminder, etc.)? We have several email templates. Can you be certain the emails are coming from the Storefront?

    To answer your other questions:

    >> Upon upgrade does Revindex Storefront automatically enable its scheduler jobs (recurring subscriptions, notifications ..) and override current settings? (we had disabled all scheduler jobs prior to upgrade)

    No, it does not re-enable schedule jobs you disabled.

    >> Does the Revindex Storefront use core messaging dispatch service? (we did not disable messaging dispatch)

    No, it does not.

    >> Is there a message queue created that can be accessed and deleted before it kicks in? (we want to remove SMTP credentials prior to upgrade so no emails are sent. However, if there is a message queue then it might kick in after the server is in production and SMTP credentials are restored!)

    No, there is no message queue.

    >> Is there a flag or other mechanism to make sure a customer gets only one notification? If so, where can we find that flag in the tables?
    Any suggestions to upgrade without facing this issue? Why would multiple emails be sent to the same customer?

    No, there is no flag to limit the number of notifications. The scheduler is controlled by DNN system. Your DNN will wake up the task and call it to run and it should run once per day. It's possible there is a bug in your version of DNN that is causing it to wake up the scheduled job multiple times. Is your scheduler set to retry multiple times (RetryTimeLapse or catch up)? I found this bug DNN-4923 that can cause the DNN scheduler to fire multiple instances.

    You also want to make sure your IIS Application Pool is set to Maximum Worker Process = 1. If the value is larger than 1, you're running as a Web Garden and the scheduler could be running multiple instances.

    Are you sure the email is not coming from another part of the system like a different scheduled job somewhere?

    Again, I'm sorry for the delay. If it came in through a priority support, we would have seen it and answered right away :(


    0
    You are not authorized to post a reply.
    Page 1 of 212 > >>