Alerts not working after migration

Announcement alerts (daily 11AM, new items only) set up forabout 30 site members are not being generated, and our Exchange adminhas confirmed that they are not getting to the Exchange box at all.The same alert is being sent correctly to the 4 site owners. This is asite collection that was originally created in WSS3.0, then latermigrated (using stsadm backup/restore) to a MOSS server under the"http://server/sites/" managed path. The site members were all addedafter the migration to MOSS.

I can see all the site member alerts within the dbo.SchedSubscriptionstable. The rows for alerts not receiving emails have an EventType of"1", whereas the successful alert rows have a "-1".

Also, the properties string for the non-working alerts contain this:

<property name="eventtypeindex" value="1"/>

Whereas the working alerts have:

<property name="eventtypeindex" value="0"/>

Unfortunately, I can't find any resources that explain exactly whatthese values indicate. I've tried deleting and re-creating the alerts,but still end up with the same values.

I turned logging on to Verbose (briefly), but I'm not sure what tolook for with either a successful or unsuccessful alert.

Possibly related: during troubleshooting, when attempting the stsadmgetproperty command, alerts-enabled property, for the web appcontaining the migrated site collection, I get:

"The server administration programs and the Windows SharePointServices Web applications on this Web server are not compatible.Ensure that the administration program is the same version as the Webapplication."

I understand this is usually seen when using an older version ofstsadm (WSS) in a MOSS environment. However, we built our MOSS boxfrom scratch using the MOSS+SP1 installer, and . So, I am suspiciousthat somehow the migrated-from-WSS site collection is to blame. Thesame command returns correct results when run against our other webapps (central admin, ssp, mysites).

6 Answers Found

We have content approval turned on. During testing, I added a newannouncement and approved it. The Announcements list Approval Columnshows "Approved" on my new item.

Now, I get the daily alert email and it shows my new item but says itis still "Pending". This would explain why my site members are notgetting their new item alerts...they're not supposed to see Pendingitems, only site owners and the author of the item.

Did your daily alert also include the announcement being approved, ordid it just show the pending entry? You should get one for both. Thealerts get written to a table as they happen, then a timer job comesalong once a day and pulls all the entries out and emails you. It isn'tsmart enough to see pending and approved and remove the pending alert.Are these people getting any other daily alerts or is it just this list?

Maybe I'm remembering issues from 2003, but I didn't think alerts took anynotice of approval status at all. In other words, I didn't think moving fromPending to Approved would actually generate an Item Changed Alert. I thoughtthe alert was fired when the Item was added as Pending and re-fired if othermetadata changed, but not approval status. I know that was an issue in SPS2003, but can't remember now if I've seen it in 2007 also.

I also just tried this same thing on a document library with contentapproval turned on, and setting up an immediate alert for "New itemsare added". Guess what?...same thing. Site owner gets the "test.docxhas been added" email, but with an approval status of pending, eventhough I uploaded the doc and approved it right away. My test memberreceived no email.

My assumption was that the EventCache table would get updated when anitem moves from pending to approved. Incorrect? Does the combinationof content approval and using "new items are added" alerts simply notwork for non-owners? Does this require an "All changes" alert typeinstead? I can see that limiting to new items only, an alert wouldnever go out to a site member, because technically, approving anannouncement takes it out of the "new item" category and moves it intothe "existing items are modified" category.

Alerts are for List/Libraries andif your alert is set for Daily, thenyou will only get the first alert for that List/Library. If you wantan alert for each event, you should set your alert to immediate thenyou should get an alert for each status change.

Yes, visitors will never see any alerts for "new items" in a librarythat requires approval. They don't have rights to see the item whenit is newly added, and they won't get an alert when it is approvedbecause it is not a new item. We raised this issue with Microsoft,but it would require major re-design to fix. Visitors need toregister for alerts on all changes.

Go4Sharepoint, is a Microsoft Featured Community.
Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation.
All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.