Email Alerts Are No Longer Working in any site on SharePoint 2007
Steven,
No, it was born a 2007 site, and just stopped working one day. Which is why I'm puzzled. I've gone the route of the common "fixes" to no avail, I guess I was just looking for any other possible answers prior to completing the psconfig.
November 19th, 2011 9:46am
Rahul,
As stated, I have verified that its not an SMTP problem as the initial email notification that a user has subscribed for alerts is still being delivered. As also stated, the timer services have all been restarted manually at the service, & command
prompt levels, all advising that they have been successfully restarted to no avail.
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2011 9:50am
So here's what I have assessed so far:
·
Users can successfully receive initial alert setup mail.
·
Users can successfully edit documents and they are successfully updated in the Document Library on the site.
·
"dbo.ImmedSubscriptions" and "dbo.SchedSubscriptions" tables in SQL are showing edits as they take place, proof that events are successfully being written
to the SQL Content DB.
·
Verified that alerts are enabled via "stsadm -o getproperty -url
http://portalsitename -pn alerts-enabled; resulted in <Property Exist="Yes" Value="yes"
·
Completed and verified command: "stsadm -o setproperty -url
http://portalsitename -pn job-immediate-alert -pv "every 5 minutes"
·
Verified in Central Admin > Operations > Timer Job Status, that despite the above commands the Immediate Alerts job status has not updated
in more than a week.
·
Completed a reset on SPtimerV3, verified logon account was valid and active, service in running state.
·
In Central Admin > Operations > Timer Job Status, when sorting on "Started", the following timer jobs have all not run as of the same day more than a week
ago, Scheduled Unplublish, Variations Propagation, Quick Profile Synchronizations, Workflow, Workflow Failover, Immediate Alerts, Scheduled Approval, Variations Propagate Site Job Definition, , Office SharePoint Usage Analytics Processing, Profile Synchronizations,
My Site Job cleanup, Recycle Bin, Workflow Auto Cleanup, Site Collection: Delete, etc.
·
Utilized ULS log viewer and reviewed the ULS log for the time of my last edit in the Document Library, I found the following:
ERROR: request not found in the TrackedRequests. We might be creating and closing webs on different threads. ThreadId = 6,
Free call stack = at Microsoft.SharePoint.SPRequestManager.Release(SPRequest request)
at Microsoft.SharePoint.SPSite.Close()
at Microsoft.SharePoint.SPSite.Dispose()
at Microsoft.SharePoint.Workflow.SPWorkflowAutostartEventReceiver.AutoStartWorkflow(SPItemEventProperties properties, Boolean bCreate, Boolean bChange, AssocType atyp)
at Microsoft.SharePoint.Workflow.SPWorkflowAutostartEventReceiver.AutoStartWorkflow(SPItemEventProperties properties, Boolean bCreate, Boolean bChange)
at Microsoft.SharePoint.Workflow.SPWorkflowAutostartEventReceiver.ItemUpdated(SPItemEventProperties properties)
at Microsoft.SharePoint.SPEventManager.RunItemEventReceiver(SPItemEventReceiver receiver, SPItemEventProperties properties, SPEventContext context, String receiverData)
at Microsoft.SharePoint.SPEventManager.RunItemEventReceiverHelper(Object receiver, Object properties, SPEventContext context, String receiverData)
at Microsoft.SharePoint.SPEventManager.<>c__DisplayClass8`1.<InvokeEventReceivers>b__0()
at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)
at Microsoft.SharePoint.SPSecurity.RunAsUser(SPUserToken userToken, Boolean bResetContext, WaitCallback code, Object param)
at Microsoft.SharePoint.SPSecurity.RunAsUser(SPUserToken userToken, CodeToRunElevated code)
at Microsoft.SharePoint.SPEventManager.InvokeEventReceivers[ReceiverType](SPUserToken userToken, RunEventReceiver runEventReceiver, Object receivers, Object properties, Boolean checkCancel)
at Microsoft.SharePoint.SPEventManager.InvokeEventReceivers[ReceiverType](Byte[] userTokenBytes, RunEventReceiver runEventReceiver, Object receivers, Object properties, Boolean checkCancel)
at Microsoft.SharePoint.SPEventManager.HandleEventCallback[ReceiverType,PropertiesType](Object callbackData)
at Microsoft.SharePoint.Utilities.SPThreadPool.WaitCallbackWrapper(Object state)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state) , Allocation call stack (if present)
at Microsoft.SharePoint.Library.SPRequest..ctor()
at Microsoft.SharePoint.SPGlobal.CreateSPRequestAndSetIdentity(Boolean bNotGlobalAdminCode, String strUrl, Boolean bNotAddToContext, Byte[] UserToken, String userName, Boolean bIgnoreTokenTimeout, Boolean bAsAnonymous)
at Microsoft.SharePoint.SPSite.GetSPRequest()
at Microsoft.SharePoint.SPSite.get_Request()
at Microsoft.SharePoint.SPWorkItemCollection.DeleteWorkItem(Guid workItemId)
at Microsoft.SharePoint.SPWorkItemCollection.DeleteWorkItem(Guid siteId, Guid workItemId)
at Microsoft.SharePoint.SPWorkItem.Delete()
at Microsoft.SharePoint.Workflow.SPWinOeHostServices.WorkItemDequeue(Transaction txn, Object[] transData)
at Microsoft.SharePoint.Workflow.SPPendingWork.PerformWorkNow(Transaction txn)
at Microsoft.SharePoint.Workflow.SPPendingWorkBatch.Commit(Transaction transaction, ICollection items)
at System.Workflow.Runtime.WorkBatch.PendingWorkCollection.Commit(Transaction transaction)
at System.Workflow.Runtime.WorkBatch.Commit(Transaction transaction)
at System.Workflow.Runtime.VolatileResourceManager.Commit()
at System.Workflow.Runtime.WorkflowExecutor.DoResourceManagerCommit()
at System.Workflow.Runtime.Hosting.WorkflowCommitWorkBatchService.CommitWorkBatch(CommitWorkBatchCallback commitWorkBatchCallback)
at System.Workflow.Runtime.Hosting.DefaultWorkflowCommitWorkBatchService.CommitWorkBatch(CommitWorkBatchCallback commitWorkBatchCallback)
at System.Workflow.Runtime.WorkflowExecutor.CommitTransaction(Activity activityContext)
at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)
at System.Workflow.Runtime.WorkflowExecutor.System.Workflow.ComponentModel.IWorkflowCoreRuntime.PersistInstanceState(Activity activity)
at System.Workflow.ComponentModel.Activity.MarkClosed()
at System.Workflow.ComponentModel.Activity.ReleaseLockOnStatusChange(IActivityEventListener`1 eventListener)
at System.Workflow.ComponentModel.FaultAndCancellationHandlingFilter.SafeReleaseLockOnStatusChange(ActivityExecutionContext context)
at System.Workflow.ComponentModel.FaultAndCancellationHandlingFilter.OnEvent(Object sender, ActivityExecutionStatusChangedEventArgs e)
at System.Workflow.ComponentModel.ActivityExecutorDelegateInfo`1.ActivityExecutorDelegateOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
at System.Workflow.Runtime.Scheduler.Run()
at System.Workflow.Runtime.WorkflowExecutor.RunScheduler()
at System.Workflow.Runtime.WorkflowExecutor.RunSome(Object ignored)
at System.Workflow.Runtime.Hosting.DefaultWorkflowSchedulerService.WorkItem.Invoke(WorkflowSchedulerService service)
at System.Workflow.Runtime.Hosting.DefaultWorkflowSchedulerService.QueueWorkerProcess(Object state)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)
So at this juncture, I can only assume that the issue is somehow related to the OWS timer service and an inability to properly execute
even when forced to. Thoughts?
Ideas? Anything I may have missed?
Worst case scenario, I’m thinking of running psconfig against the server just to have it do a checks and balances with what’s
running in the stack. Any help is greatly appreciated.
November 19th, 2011 12:42pm
Hi,
You can execute psconfig however I would suggest you to check these before going for that:
1. Check if all IPs of all your WFEs are added into the allow relay list of outgoing eMail server.
2. Restart the timer services.
I hope this will help you out.Thanks, Rahul Rashu
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2011 12:50am
Is this a site that's been upgraded from SharePoint 2003?Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
November 20th, 2011 6:12am