Alert Notification could not access database. Database appears to be offline or

From: Brad Slatten (bslatten_at_hdma.net)
Date: 07/12/04


Date: Mon, 12 Jul 2004 09:26:33 -0700

Our sharepoint portal has had a recurring problem with
portal (Topic/Area) based alerts. We have seen the same
error completely or partial discrupt the flow of these
alerts. The error is as follows:

07/12/04 11:09:31:203 UNK 00000000 00000940 Alert
Notification could not access database. Database appears
to be offline or tables are locked
07/12/04 11:09:31:203 UNK 00000000 00000940 The
notification could not be generated temporarily. Retrying
(limited). Notification details:{Seed Owner=a2165cbe-1e69-
47ff-9215-1503ffda8536 TypeId=AlertResultNotification
SeedValue=3394;1;Jul 12 2004 2:51:41:137PM Tag=2} Portal
site details:{site=HDMA id=43996182-2462-4734-a589-
35e997c8185d} Exception information:
Microsoft.SharePoint.Portal.Alerts.NotificationDataTempora
rilyUnavailableException: Failed to generate
notification:Alert Notification could not access
database. Database appears to be offline or tables are
locked --->
Microsoft.SharePoint.Portal.Alerts.SecurityAccessCheckFail
edException: Tripoli Security trimmer failed and returned
a null array at Microsoft.SharePoint.Portal.Alerts.x.a
(PortalContext A_0, SecurityTrimmer A_1, DataTable A_2,
Hashtable A_3, Boolean A_4, WindowsIdentity A_5, Byte[]
A_6, Boolean[]& A_7, Int32& A_8) at
Microsoft.SharePoint.Portal.Alerts.x.a(at A_0,
PortalContext A_1, SecurityTrimmer A_2, DataSet& A_3,
Guid A_4, WindowsIdentity A_5, Byte[] A_6) at
Microsoft.SharePoint.Portal.Alerts.at.a(Guid A_0, String
A_1, SqlParameter[] A_2, WindowsIdentity A_3, Byte[] A_4)
at Microsoft.SharePoint.Portal.Alerts.at.a(Guid A_0,
String A_1, SqlParameter[] A_2) at
Microsoft.SharePoint.Portal.Alerts.j.a(String A_0,
SqlParameter[] A_1) --- End of inner exception stack
trace --- at Microsoft.SharePoint.Portal.Alerts.j.a
(String A_0, SqlParameter[] A_1) at
Microsoft.SharePoint.Portal.Alerts.NotificationTypes.a.a
() at Microsoft.SharePoint.Portal.Alerts.ai.c()

We have checked the following per other newgroups and
logical troubleshooting:

E-mail System- Connectivity (WSS (Sitebased) alerts are
fine as are new alert setup notifications)

Indexing or searching process (Working, My Alerts summary
on my sites are being populated)

Services are running and security is appropriate

Access to SQL databases by service logon accounts is
appropriate and sufficient.

Last time we had this lock up it required a re-
installationa and restore of the portal content. I'm
hoping that isn't required again.

Any help out there?



Relevant Pages

  • RE: Error creating BAM Alerts file location:
    ... the share and either re-create it manually or through config. ... database: BizTalkDB_SDEV on computer: SQLSERVER001 ... Management Database: BizTalkDB_SDEV on server SQLSERVER001 ... File Location: alerts. ...
    (microsoft.public.biztalk.general)
  • RE: Monkeybrains.net and badtrans compromise information
    ... We alerted a number of companies whose employees, customers, etc., were ... Had we known of monkeybrains.net's intention to charge for releasing the ... we would have noted so in the alerts that we sent to companies ... that we found in their database. ...
    (Incidents)
  • Alert Notification could not access database. Database appears to be offline or
    ... >portal based alerts. ... >Notification could not access database. ... >notification could not be generated temporarily. ... >Access to SQL databases by service logon accounts is ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Alert Notification problem
    ... Alerts cannot be processed if the account that the SharePoint Timer Service ... is running under does not have access to the content database. ... notification that the alert was set up, ...
    (microsoft.public.sharepoint.windowsservices)
  • Sharepoint Alerts Not Working
    ... Recently, I deleted some old profile, site and server databases that we ... 001C50C8 UNK ... 0000160C Alerts are active for the following ... are still alerts tied to database tables which no longer exist. ...
    (microsoft.public.sharepoint.portalserver)