An error has occurred after workflow completed MOSS 2007

If you have a "built in" or custom approval workflow setup for your document library. The workflow runs correctly, however sometimes you look at the workflow status, you may receive an error after the task has been approved and completed such as,
Event Type: Error User ID: System Account Description: An error has occurred in [your workflow name].
Resolution: There is a section "Post-completion Workflow Activities", where you can check "Update the approval status (use this workflow to control content approval)". If you check this option, and you do NOT have content approval enabled on the library level, you get the system account error message. If you do not check it, everything works fine.

Most common problems in SharePoint naming: spaces

When I did create a workflow action, Using SharePoint Designer 2007, which emails the URL of the current item in a list. I did use below lookup items in my workflow mail
1-[%LISTNAME: Encoded Absolute URL %]
2-[%LISTNAME: Server Relative URL%]
3-[%LISTNAME: URL Path %]
4-[%LISTNAME: Path %]

There is one problem which will always occur and another which may occur, depending upon the naming convention you use for your lists.

Problem 1: ID number pulled from URL actions are appended with "_.000" in case 1, 2 and 3.
Problem 2: In case 4, Spaces within list names are sometimes ignored, sometimes not. i.e. "My Test List" could be translated into "My Test %20List" - causing a 404 error during the URL lookup.

Solution: Here I am solving problem 2. It works for me. According this,

You need to rename your lists to contain no spaces. Now this would seem easy to do - enter your list settings, go to Title, description and navigation, and change the name. This will not work as it seems to only change a pointer for SharePoint references, but not anything that has to do with URL paths.

You need to rename the list itself within SharePoint Designer to have one single list name. Right-click on the selected list, select "rename" and rename the list to something without spaces. SharePoint Designer will save this information to your SharePoint site and references in all attached workflows will reflect these changes.

Basically this changes internal name of list. Now you can rename list name again from SharePoint list setting, go to Title, description and navigation, and change the name, if you need to display list title with space to all.

Error "401 Unauthorized" For MOSS FBA

When you have SharePoint Server 2007 implementation with Form Based Authentication (FBA) and anonymous access turned on you may experience 401 Unauthorized when you visit the site like http://xxxxxx/sites123/pages123/default.aspx

Look into your web.config file for Web Application that you extended to use FBA for *compilation* tag and edit it to make it look like below. Save the web.config and give it a run.

*compilation batch="false" debug="false" /*
Note: Please replace * (Blogger not support HTML tagging)

And also when you visit the URL could you please check which Zone does the site belong to in the IE status bar?
I suppose the URL belongs to the Local Intranet Zone or Trusted Sites which automatically log on with your current Windows credential. If your windows credential does not have the permission to access the site, you would get 401 Unauthorized error. If so, please remove the sites from the Local Intranet Zone or Trusted Sites and try again.

Hope it will help !! :-)