|
|
|
date: Wed, 14 Feb 2007 20:35:03 -0800,
group: microsoft.public.sharepoint.portalserver
back
Sharepoint 2007 alerts failing after database restore
Hi all,
I’m currently having an issue with Sharepoint Portal Server 2007 and alerts.
I know the alerts are set up and working correctly because if we create a new
site collection/sites and add alerts to list under these, they work as
advertised.
The issue I am having is after we have imported a site from a dev/test
Sharepoint environment and then add or modify alerts for this site. I had to
move an entire site collection from a development environment running
Sharepoint 2007 Beta2TR to a production environment running the RTM version.
I accomplished this by just backing up the content database, restoring it to
the production server, and then attaching it to a web application using the
stsadmin – attachcontentdb command. This worked well for everything (lists,
content, etc etc) but alas the alerts failed to work at all after this move.
The only thing I can see in the logs that seems relevant is: 0x1E90 Windows
SharePoint Services General 75ko High Unknown
Change Microsoft.SharePoint.SPChangeAlert
If I create a new list in this restored site, we get alerts from that, but
we receive nothing from the lists that were associated with the restore. Even
deleting and re-adding the alerts fails to kick them off.
If anyone has any ideas, or experience like this, I would be forever
grateful! I would even be happy if there is a way to reset and wipe alerts
for a given site collection and start them again.
Cheers,
Matt.
date: Wed, 14 Feb 2007 20:35:03 -0800
author: Matt
RE: Sharepoint 2007 alerts failing after database restore
Matt,
Please check the following
1. Are you receving a confirmation that you've got subscribed for the alerts ?
2. Alerts are based on SMTP, check whether you have configured the proper
SMTP server and check whether MOSS 2007 server has access to SMTP server
3. If you have anti-virus software on the server, check whether it is
blocking the bulk mail functionality, becuase alerts are going to be sent as
bulk mails
4. Please check whether the events are turned-on the MOSS 2007 server, else
explicity the turn on the events in the server
5.Please check whether the following tables in MOSS 2007 database have
entries related to your alerts
EventLog table
EventCache table
SchedSubscription table
ImmedSubscription table
6. Verify all of your accounts (Service LOG ON accounts, APP Pool accounts
and DataBase accounts)
whether it has proper access
7. Verify whether the indexing and Crawling has happened properly.
8. Check the gatherer log and see whether there are any errors
Please update me after all the checks
As far as i know, there is no way to turn-off/turn-off/re-start the alerts
at Site Collection level
--
Thanks & Regards,
Mark Nelson
"Matt" wrote:
> Hi all,
>
> I’m currently having an issue with Sharepoint Portal Server 2007 and alerts.
> I know the alerts are set up and working correctly because if we create a new
> site collection/sites and add alerts to list under these, they work as
> advertised.
>
> The issue I am having is after we have imported a site from a dev/test
> Sharepoint environment and then add or modify alerts for this site. I had to
> move an entire site collection from a development environment running
> Sharepoint 2007 Beta2TR to a production environment running the RTM version.
> I accomplished this by just backing up the content database, restoring it to
> the production server, and then attaching it to a web application using the
> stsadmin – attachcontentdb command. This worked well for everything (lists,
> content, etc etc) but alas the alerts failed to work at all after this move.
> The only thing I can see in the logs that seems relevant is: 0x1E90 Windows
> SharePoint Services General 75ko High Unknown
> Change Microsoft.SharePoint.SPChangeAlert
>
> If I create a new list in this restored site, we get alerts from that, but
> we receive nothing from the lists that were associated with the restore. Even
> deleting and re-adding the alerts fails to kick them off.
>
> If anyone has any ideas, or experience like this, I would be forever
> grateful! I would even be happy if there is a way to reset and wipe alerts
> for a given site collection and start them again.
>
> Cheers,
> Matt.
>
date: Wed, 14 Feb 2007 23:10:08 -0800
author: Mark Nelson
RE: Sharepoint 2007 alerts failing after database restore
Hi Mark,
Thanks for your reply. I have outlined your questions below (and solved
based on your suggestions).
1. Yes, we are receiving the confirmation of subscription to the list we add
the alert to – just no immediate alerts are received.
2. We have no problems sending any other type of email from this site and
have ensured the smtp server details are set up correctly.
3. Will follow up with the security team re this (apparently not an issue).
4. Yes, Events are turned on and being logged.
5. **This was the issue**
The alerts in the ImmedSubscription had the wrong details for the alerts
ported from the development server for some reason. Wiping out everybody’s
alerts in this list and the SchedSubscription table seemed to do the ‘reset’.
The result was that all alerts migrated across from dev were lost but I can
live with getting people to re-enter them as it was a small quantity at this
stage.
The alerts were not being placed in the EventLog either until they were
wiped and re-added.
6. I’m assuming all the accounts have the right access because any new sites
that are created have alerts working flawlessly.
7. Full indexing is functioning once per day and incremental is churning
through every 10 mins.
8. I cannot see any gather log errors or warning relating to the crawls
around the time the alerts should be processed.
Thanks for all the ideas – it helped me solve the problem in record time
after spending a fair bit trying to research!
Cheers,
Matt.
"Mark Nelson" wrote:
> Matt,
>
> Please check the following
>
> 1. Are you receving a confirmation that you've got subscribed for the alerts ?
> 2. Alerts are based on SMTP, check whether you have configured the proper
> SMTP server and check whether MOSS 2007 server has access to SMTP server
> 3. If you have anti-virus software on the server, check whether it is
> blocking the bulk mail functionality, becuase alerts are going to be sent as
> bulk mails
> 4. Please check whether the events are turned-on the MOSS 2007 server, else
> explicity the turn on the events in the server
> 5.Please check whether the following tables in MOSS 2007 database have
> entries related to your alerts
> EventLog table
> EventCache table
> SchedSubscription table
> ImmedSubscription table
>
> 6. Verify all of your accounts (Service LOG ON accounts, APP Pool accounts
> and DataBase accounts)
> whether it has proper access
> 7. Verify whether the indexing and Crawling has happened properly.
> 8. Check the gatherer log and see whether there are any errors
>
> Please update me after all the checks
>
> As far as i know, there is no way to turn-off/turn-off/re-start the alerts
> at Site Collection level
> --
> Thanks & Regards,
> Mark Nelson
>
>
> "Matt" wrote:
>
> > Hi all,
> >
> > I’m currently having an issue with Sharepoint Portal Server 2007 and alerts.
> > I know the alerts are set up and working correctly because if we create a new
> > site collection/sites and add alerts to list under these, they work as
> > advertised.
> >
> > The issue I am having is after we have imported a site from a dev/test
> > Sharepoint environment and then add or modify alerts for this site. I had to
> > move an entire site collection from a development environment running
> > Sharepoint 2007 Beta2TR to a production environment running the RTM version.
> > I accomplished this by just backing up the content database, restoring it to
> > the production server, and then attaching it to a web application using the
> > stsadmin – attachcontentdb command. This worked well for everything (lists,
> > content, etc etc) but alas the alerts failed to work at all after this move.
> > The only thing I can see in the logs that seems relevant is: 0x1E90 Windows
> > SharePoint Services General 75ko High Unknown
> > Change Microsoft.SharePoint.SPChangeAlert
> >
> > If I create a new list in this restored site, we get alerts from that, but
> > we receive nothing from the lists that were associated with the restore. Even
> > deleting and re-adding the alerts fails to kick them off.
> >
> > If anyone has any ideas, or experience like this, I would be forever
> > grateful! I would even be happy if there is a way to reset and wipe alerts
> > for a given site collection and start them again.
> >
> > Cheers,
> > Matt.
> >
date: Thu, 15 Feb 2007 19:23:08 -0800
author: Matt
|
|
