We help IT Professionals succeed at work.

MOSS 2007 Workflows

glamp321
glamp321 asked
on
Certain pages and doc libraries are not sending emails alerting the Approvers group that content needs to be approved.  This is not happening for all pages and libraries.  In general, Sharepoint emails are going out fine (contributor is being notified that a workflow has started, new contributors are being notified when they are added to a SP group, etc.), it's just these few pages/libraries that refuse to cooperate.
Comment
Watch Question

Check that Content Approval is enabled for those librarie before you create the workflow, and then Check Workflow before you exit the Workflow Designer.

You should also read this article...
http://weblogs.asp.net/mellota/archive/2007/10/11/sharepoint-2007-task-notification-alert-emails-not-working.aspx

Hope this helps.

Author

Commented:
I already have Approval checked for this library.  I receive the email that the workflow "Parallel Approval has started", but I don't receive the email that I need to approve it, and I am in the Approvers SP group.  Where is the "check workflow" option?
The "Check workflow" option is in the bottom left corner of the Workflow Designer window. This is the tool that appears in SharePoint Designer when you create a workflow. (See attached graphic). This begs the question - how are you creating the workflows? (browser, SP Designer, VIsual Studio, etc)

Compare the working and non-working workflows. Is there any pattern to this, such as only certain sites or users? Is it all workflows in a certain site? Have the sites or pages in question been customized in any way? Were the workflows created by different people? This might help to narrow down the problem. It also helps to do  a detailed comparison of the settings of a working and non-working example to look for differences.
WorkflowDesigner.png

Author

Commented:
So far, I've been going into Workflow settings through the browser.  I actually have no experience with SP Designer, our web developer built all of the libraries and workflows.  I'll pass this info along to him, but is there any easy troubleshooting steps I can take in the browser, or will it be more effective to just work with him in SP Designer?
It depends on where the workflows are created. You can edit the basic workflows in the browser, but if he created those in SP Designer, you'll have to get him to check those.

Author

Commented:
Ok, some new developments:

-the workflow alert issue is not random, it is for our entire SP site.
-the submitter receives an email saying the workflow has started, the approver DOES NOT receive any alert, but can still see the task if they go into the browser and look at workflow tasks, and once the content is approved/rejected, the editor receives an email stating that the workflow is complete.  To me, this indicates that the workflow is functioning normally, it is the Alert associated with the Approval task that is failing.
-it is unclear how these workflows were originally created.  when we try to "open workflow" in SP Designer, there are no workflows available to open.
-if we create a new workflow at the top site level, will this workflow apply to all child pages/libraries/lists?
Thanks again for your help with this.
Sorry it took so long to get back to you. It's been a really busy week for me.

Are you getting any errors in your system/application logs that are related to the Timer Service or SMTP?

In SharePoint, the normal Alerts (the ones you subscribe to) are handled differently than the task notifications. Here's an article that gives some detailed insight into the process:
http://blogs.msdn.com/b/sharepointdeveloperdocs/archive/2007/12/07/customizing-alert-notifications-and-alert-templates-in-windows-sharepoint-services-3-0.aspx

I'll keep looking into this, but unfortunately can't test it at the moment as my Dev machine is being reconfigured.



Author

Commented:
Event 6875, WSS 3:
Error loading and running event receiver Microsoft.SharePoint.Publishing.Internal.ScheduledItemEventReceiver in Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Additional information is below.

: Invalid List Item. The List Item provided is not compatible with a Scheduled Item.
----------
The SSP Timer Job Distribution List Import Job was not run.

Reason: Logon failure: unknown user name or bad password

Technical Support Details:
System.ComponentModel.Win32Exception: Logon failure: unknown user name or bad password
   at Microsoft.Office.Server.Utilities.WindowsSecurity.GetUserTokenFromCredentials(String userDomainName, String password, LogonType logonType)
   at Microsoft.Office.Server.Utilities.WindowsSecurity.GetUserTokenFromCredentials(String userDomainName, String password)
   at Microsoft.Office.Server.Administration.JobHandler.Execute(Object state, Boolean timedOut)
-------------------------------


does this look like it could be the problem?  in the invalid pw error, which password, and which service does it need to be set for?  
Well, the first error (6875) seems to be harmless. See http://www.eventidwiki.com/index.php?title=Event_ID_:_6875%2C_Windows_SharePoint_Services_3 and KB article http://support.microsoft.com/kb/948323.

The second could be your problem. If the Distribution List can't be imported, that would certainly affect e-mails. Check that your SharePoint Timer Service is running, and look at what login is used to run it. Mine is using NT AUTHORITY\NETWORK. Then read this page for some ideas to try.  http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/c83b015c-d13d-4663-98f6-1d98193b8b92

Good luck!
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.