sharepoint alerts not working

Posted on 2011-10-18
Last Modified: 2012-05-12
We have SharePoint 2007 and we rely heavily on the SharePoint email alerts. We have recently decided to migrate from our current url http://company-intranet   to and make the site accessible from the internet. We have also made it redirect to use SSL if the user doesn’t connect with SSL. We added the new url to the alternate mappings. Page       
When we did this it caused some problems with alerting .We are getting alerts for some sites but not all. I believe it definitely has to do with our URL change. When we go into the alerts some of them are behaving strangely. For instance, if I go into outlook 2010 and go to rules and alerts. I click on certain alerts and go to its properties then view item, I get two browser windows open with 404 not found and
I have tried a number of troubleshooting steps and I can’t seem to figure out what the issue could be. I am getting alerts for some sites but not all. Any help would be appreciated! I have attached a word doc with some screen shots showing some of the strange behavior and my AAM page.

Question by:jbla9028
    LVL 10

    Expert Comment

    by:Minesh Shah
    i believe smtp settings in iis, central admin & alert related features are fine, you checked it,

    Next thing to be checked would be the database tables, after I read about the same problem in this newsgroup posting. The following four tables in the content database contain entries related to the alert emails:

    ImmedSubscriptions (Stores the alerts for emails that are sent immediately when changes occur)
    SchedSubscriptions (Stores daily or weekly scheduled alerts)
    EventLog (This table contains events for which only non-immediate alerts exist)
    EventCache (This table contains a list of site events for which users have requested alerts. WSS inserts events into this table as they occur)

    I checked in these table to see if information about the alerts were being inserted and discovered that in the ImmedSubscriptions and EventLog tables there were actually entries which were related to the live server, as I believe the content database had been restored from a live copy a while ago, and the references obviously had not been updated automatically. So I cleared out each each one of these tables and re-tested the workflow. This made a bit of progress as I could now see that the alert information was getting inserted correctly into the EventCache and EventLog tables. However the ImmedSubscriptions table was still not receiving information about the alert.

    After some frustrated iisresets and restarts of the timer job service, I was still having no luck whatsoever at getting these alert emails working so I reverted back to trusty Google for some more answers. I found this blog, which although not directly related, provided the winning answer. Updating the alert templates. After running the following stsadm command on the development machine, the task notification alert emails automagically started working again woohoo!

    stsadm -o updatealerttemplates -url http://testserver -f "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML\alerttemplates.xml" -LCID 2057

    So I can assume that the problem transpired from a restore of the content databased from a different server which somewhere along the line maintained some references to the original server. A clear out of the relevant databases and re-registering the alert templates seemed to solve the problem for me.

    Hopefully this comes in handy..
    LVL 1

    Author Comment

    I will check this command to see if it helps. We just figured out a couple things. So the clicking "view" on the alert page in outlook which causes two browser pages to open seems to be a Firefox related issue. I set my default browser back to IE9 and the problem disappeared.

    The main issue where alerts were not being received seemed to be resolved by elevating my privileges on the page. Any page that I was the admin on I was receiving alerts but just being a "member" on a page doesn't allow me to receive alerts?
    LVL 1

    Author Comment

    The problem with the browser and sharepoint also exists in the latest release of google chrome. Good old Microsoft trying to keep it's dwindling market share :)
    LVL 1

    Accepted Solution

    My issues ended up being stemmed from the AAM settings. We had to set all the http and https links that we previously used and the new link under AAM to change to Once we did that and recrawled it worked.
    LVL 1

    Author Closing Comment

    My issues ended up being stemmed from the AAM settings. We had to set all the http and https links that we previously used and the new link under AAM to change to Once we did that and recrawled it worked.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now