MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Alerts not working after migration

  Asked By: Conor    Date: Apr 20    Category: MOSS    Views: 2405

Announcement alerts (daily 11AM, new items only) set up for
about 30 site members are not being generated, and our Exchange admin
has 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 a
site collection that was originally created in WSS3.0, then later
migrated (using stsadm backup/restore) to a MOSS server under the
"http://server/sites/" managed path. The site members were all added
after the migration to MOSS.

I can see all the site member alerts within the dbo.SchedSubscriptions
table. 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 what
these 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 to
look for with either a successful or unsuccessful alert.

Possibly related: during troubleshooting, when attempting the stsadm
getproperty command, alerts-enabled property, for the web app
containing the migrated site collection, I get:

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

I understand this is usually seen when using an older version of
stsadm (WSS) in a MOSS environment. However, we built our MOSS box
from scratch using the MOSS+SP1 installer, and . So, I am suspicious
that somehow the migrated-from-WSS site collection is to blame. The
same command returns correct results when run against our other web
apps (central admin, ssp, mysites).



6 Answers Found

Answer #1    Answered By: Tamika Cummings     Answered On: Apr 20

Also, I noticed an oddity with this announcement  alert list.

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

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

Any ideas why these are out of sync?

Answer #2    Answered By: Linsey Bauer     Answered On: Apr 20

Did your daily  alert also include the announcement  being approved, or
did it just show the pending entry? You should get one for both. The
alerts get written to a table as they happen, then a timer job comes
along once a day and pulls all the entries out and emails  you. It isn't
smart 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?

Answer #3    Answered By: Ivy Salinas     Answered On: Apr 20

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

Answer #4    Answered By: Kevin Davis     Answered On: Apr 20

Here's the "New items  are added" alert  email that I, a site  admin, got
for a daily  11 AM alert, for an item that was added AND approved at
10:25 AM:

Title Modified Modified by
***** ******** ***********
test 7/9/2008 10:25 AM Eric Riehl New!
Title test
Approval Status Pending
Body test

Site members  did not get this email.

I also just tried this same thing on a document library with content
approval turned  on, and setting up an immediate alert for "New items
are added". Guess what?...same thing. Site owner gets the "test.docx
has been added" email, but with an approval status of pending, even
though I uploaded the doc and approved it right away. My test member
received no email.

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

Answer #5    Answered By: Meenakshi Khochar     Answered On: Apr 20

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

Answer #6    Answered By: Latrice Henson     Answered On: Apr 20

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

Didn't find what you were looking for? Find more on Alerts not working after migration Or get search suggestion and latest updates.