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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: iNDYCZ (indy_at_indy.cz)
Date: 07/28/04


Date: Wed, 28 Jul 2004 05:05:11 -0700

I am now having the same problem. Send me please e-mail,
if you know fix or resolution for this error.

Thanks, iNDY
 
>-----Original Message-----
>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

  • Alert Notification could not access database. Database appears to be offline or
    ... portal based alerts. ... Notification could not access database. ... Microsoft.SharePoint.Portal.Alerts.at.a(Guid A_0, String ...
    (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)
  • Beware "lowclearances.com"?
    ... To have a database such as you say you offer would depend on municipal ... information on low clearances on approved municipal and county routes ... Our database does include alerts nationwide on county, ...
    (misc.transport.trucking)
  • Re: SqlNotificationInfo
    ... Notification Services demo in my sessions. ... Microsoft MVP ... database and so far, the only result I've had is to lock up the ... so I figured that SqlNotifications was just vaporware. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Fatal error 682 and SqlDependency
    ... Cannot execute as the database principal because the ... However, this error is unrelated to the size of the query notification, is ... When this error happens in the server messages for one query notification ... SqlServer 2005 Notification Services feature to get notified about changes ...
    (microsoft.public.dotnet.framework.adonet)