Sharepoint Portal 2003 alerts not working

[derk]

We currenlty use Sharepoint Portal 2003 and WSS 2.0. the alerts are working fine on wss2.0 but not the portal sites.

I have restarted the services and the server. and i have even rebuilt the index no such lucky. connection to the mail server is fine and i have checked the service accounts also and they are fine.

this is what i am getting in the spsnotficationserver log file



000004C2 UNK 00000000 00001C3C Alerts are active for the following site:
Site Name: 'Enterprise Portal' Site ID: '27d08d31-06f9-4242-9e27-62209142de29' SMTP Server: 'NT08.intranet.victorstanley.com(Normal)' Loaded templates:
D:\Program Files\SharePoint Portal Server\DATA\Alerts\1033\AlertAutoDeactivationNotification.xsl
D:\Program Files\SharePoint Portal Server\DATA\Alerts\1033\AlertResultNotification.xsl
D:\Program Files\SharePoint Portal Server\DATA\Alerts\1033\AlertCreationConfirmation.xsl
D:\Program Files\SharePoint Portal Server\DATA\Alerts\1033\AlertNewsLetterNotification.xsl<BR>
000004C2 UNK 00000000 00001C3C AppDomain: SPSNotificationService.exe<BR>
00000A7F CRI 8000FFFF 00001C3C MSSCNTRS: Cannot get perf statistics on library SSO.<BR>
000DB13F UNK 00000000 00000654 The notification could not be generated temporarily. Retrying(limited).
Notification details:{Seed Owner=2e8623e8-fb81-48c0-b897-c35d43f9511e TypeId=AlertResultNotification SeedValue=55479;2;Dec 12 2008 7:49:15:060PM Tag=531}
Portal site details:{site=Enterprise Portal id=27d08d31-06f9-4242-9e27-62209142de29}
Exception information: Microsoft.SharePoint.Portal.Alerts.NotificationDataTemporarilyUnavailableException: Failed to generate notification:The DocSpecialProps data may not be ready yet. Retry.
at Microsoft.SharePoint.Portal.Alerts.NotificationTypes.a.a()
at Microsoft.SharePoint.Portal.Alerts.ai.c()<BR>
00123C94 CRI 00000000 000014A0 CResourceManager::_GetGlobalConnectionString Global database: 'Provider=SQLOLEDB;Extended Properties='Server=NT17;Database=SPS01_Config_db;Trusted_Connection=yes;App=SharePoint Portal Services;';'.<BR>
00123CB3 CRI 00000000 000014A0 CResourceManager::_StaticConstruct Initialized.<BR>

 

[PatricktheAnalyst]

I wonder if you lost the full text indexes on your portal content databases and if that could triger the failure. I would disable and then re-enable those indexs using the stored procedures in the databases. Make sure that your sql full text search is working corectly.

Patrick

http://sharepointglobal.blogspot.com/

 

[derk]

How would i check the sql full text search?