Immediate Alerts stopped working after Detach/Attach of Database
Sharepoint Server Windows Server 2008 Standard SP2 32bit Windows SharePoint Services 3.0 SP1 SQL Server Windows Server 2003 R2 Standard Microsoft SQL Server 2005 Symptom description Our SQL Server was running out of harddrive space on the C: Drive where the SharePoint WSS_Content database was stored. So I did the following steps to move the WSS_Content.mdf and WSS_Content_Log.ldf to diffrent partitions on the same disk. Stopped all SharePoint services and IIS From SQL Server Management Studio Detached WSS_ContentMoved WSS_Content.mdf to the E: DriveMoved WSS_Content_Log.ldf to the D: DriveFrom SQL Server Management Studio Attached WSS_Content.mdf from the new locationOpened up the WSS_Content Database Properties and pointed WSS_Content_log to the new locationStarted all SharePoint Services and IIS After doing the above steps Sharepoint appered to be working fine until one of our users reported that Alerts had stopped working. In SharePoint Central Administration>Operations>Timer Job Status the Immediate Alerts status is showing as Failed and the time stamp coincides with when I did the above maintenance. After a lot of googling and reading Microsoft blogs and KB's I have tried the following steps to fix the issue with no luck. Restart SharePoint ServerRestarted Windows SharePoint Services TimerSame as above but left the Services Timer stopped for atleast half an hour before trying again.Checked Windows SharePoint Services Timer credentials and re-entered them Used STSADM to verify properties which come back correct STSADM -o getproperty -url http://YourSiteURL -pn alerts-enabled You should see <Property Exists=Yes /> STSADM -o getproperty -url http://YourSiteURLpn job-immediate-alerts You should see something like the default (but can be changed) <Property Exists=Yes Value=every 5 minutes between 0 and 59 /> Used STSADM to reset properties stsadm o setproperty url http://YourSiteURL pn alerts-enabled pv False stsadm o setproperty url http://YourSiteURL pn alerts-enabled pv True stsadm o setproperty -url http://YourSiteURL pn job-immediate-alerts pv Every 5 minutes between 0 and 59" Used STSADM to re-register the alerts template stsadm -o updatealerttemplates -url http://YourSiteURL -f "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML\alerttemplates.xml" -LCID 1033 Navigated to C:\ProgramData\Microsoft\SharePoint\Config on our SharePoint Server and deleted all the XML files apart from Cache.ini Open Cache.ini and replaced it's content with 1 I don't know what else I can try anyideas? Kind Regards Ryan McMaster
April 8th, 2012 8:23am

Sorry it's took a while to get back you I've not had chance to touch this again until now... I've just moved the WSS_Content database back to it's original location on the C Drive of the SQL Server as a long shot but it still doesn't work! I've not had chance to try a new web app... think I'll install Sharepoint Foundation 2010 on another server and migrate the data across. Does this sound ok to you or will I encounter any other problems? Cheers
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2012 1:50pm

The status for the timer job Immediate Alerts is still failed? How many servers do you have in the farm? All the other timer jobs are working correctly? Here you have two links regarding alert troubleshooting steps: http://blogs.technet.com/b/steve_chen/archive/2009/11/20/alerts-in-sharepoint-troubleshooting-moss-wss.aspx http://blogs.technet.com/b/steve_chen/archive/2010/04/27/alerts-in-sharepoint-part-ii-troubleshooting-moss-wss.aspxMCITP|MCTS SharePoint| SharePoint Performance blog
April 8th, 2012 2:54pm

Thank you for getting back to me... All the other Timer Job's are Succeeded apart from Immediate Alerts and CEIP Data Collection which show as Failed. I believe CEIP Data Collection is showing as Failed because we've opt out sharing error data with Microsoft etc It's just one standalone installation of Sharepoint Services 3.0 SP1 using a seperate server with SQL 2005 on for the Database. I've already been through all the steps in your first link and I'm sure the second holds no relevance but thankyou. Cheers Ryan
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2012 6:14am

Have you tried to create a new alert or to delete an old one and recreate it again? You have the same issue?MCITP|MCTS SharePoint| SharePoint Performance blog
April 9th, 2012 6:34am

Yes I have tried creating new alerts and modifying old ones etc. When you click 'Alert Me' to setup a new alert we recieve the welcome email saying alerts have been setup but after that nothing comes through and Immediate Alerts are still showing as Failed.
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2012 6:49am

The issue is present only on this web application that is associated with the migrated content_db? If you create a new web app for tests you have the same issue? MCITP|MCTS SharePoint| SharePoint Performance blog
April 9th, 2012 7:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics