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