.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Workflow History and SQL Error

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :SharePoint

Like many others who work on SPD 2007 workflows might have encountered the following problem:

That is, When trying to view an item in a list which has workflows run against it, you get an error:

  • Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries

Now when I was searching for the solution I stumbled upon a post that suggested the reason we can't access the items is because when SharePoint pulls up the item for edit/view it checks the Workflow History for that item. If there are more than about 200 entries for that item in the Workflow History list, we get the SQL query error.   Now I am aware that the workflow history data is purged from the MOSS Workflow database table after 60 days but I was wondering:

a) Avoid the triggering of unnecessary history events when an item is created (view  link  for details)


b) If there is a way that I am able to control the workflow history list in some w

View Complete Post

More Related Resource Links

Nintex Workflow Error: No workflows are waiting for a BizTalk message [...] No processing has been d



I created a Workflow with Nintex Workflow 2007 (on SharePoint 2007) to send/receive data to BizTalk 2009. It worked fine already. But now I get the following error mesage in the EventViewer:

Nintex Workflow; Build: 11000 (http://ls457/_layouts/nintexworkflow/BiztalkHandler.ashx)
No workflows are waiting for a BizTalk message with message Id of 'GeneralAccessRequest_2010-08-23T15_00_04_44961212B370C554EDFAC41C1201ED6CEFB' on teamsite http://ls457/sites/testapp. No processing has been done.

What could that mean? Any ideas? I definitely changed nothing on the orchestration or BizTalk administration. The BizTalk action sends the data correctly to it's destination (database), but it seems that nintex doesn't receive any return data. I don't think it's a BizTalk problem, because in the BizTalk Message Tracking Database the Message is listet, so it has been sent correctly by BizTalk. But the handler probably has problems to find/receive this message.

Kind regards,


SPField of WorkflowEventType in the Workflow History List has value Workflow Initiated but when i ed


hi all

how are you

i wish anyone could help me in this problem

i have a sharepoint sequential workflow created in visual studio

when the workflow starts i log into the workflow history list that workfow is started using the LogToHistoryListActivity

i entered the hidden workflow history list from the browser for example:


i noticed that an item is created in the above list when i run my workflow

the field Event Type in the item above has the value of Workflow Initiated but when i edit the item i noticed that the field Event Type has a value of 0

so can anyone tells me how this field works and from where it is getting itsvalues

thanks a lot


How to Get Error Message from Job History if SQLAgent Job Fails

Hello, I am using "last_run_outcome" value = 0 (fail) or 1 (pass)  from sysjobsteps to identify if the job has failed. So if the job has failed, can I get the Error Message from SQL ? (which we can see in Job History). Thanks, Prabhat

Error loading workflow services

Hello, I'm developing a service library using the new wf 4.0 and one of my requirements is that some activities have the ability to be resumed by a client, so i created a wcf resume service that could load a workflow definition and resume a bookmark of that workflow. One of the services i created was a flowchart that has a receive reply activites inside a sequence activity has a start point, after that i have another sequence that have another sequence, yes 2 sequence activities, and my custom activity that needs to be resumed by a client. The 2 nested sequence activites was a something i used only for testing, but if i had those 2 sequence activities nested i got an error when loading that workflow definition in my resume service: 'ObtemPareceres' is not of type 'Sequence'. When loading this instance you must ensure that the activity with name 'ObtemPareceres' implements 'Sequence'. The "ObtemPareceres" is my custom activity, and if i remove that second nested sequence everything works fine. Anyone has any idea of whats going where? thanksFrederico Regateiro

Workflow "Error Occurred" Message

Hi, We have upgraded a VS 2008 custom workflow in our production environment but we are now seeing an "Error Occurred" message when starting in one site that the workflow is activated on.  It works fine on another site.  Permissions DID NOT change for users on this site before or after or during the upgrade of the workflow. It works fine in our test environment. How can I troubleshoot this in production environment (I cannot debug)? Can somebody give me a definite answer on what are the required permissions to give user to allow them to start workflows and edit only their own Tasks?  I have asked this question on a number of forums with no definitive answer.

Error Occured during workflow

Hi, i have created a workflow using VS2010 and deployed in SP2010 but while running the workflow its giving me a status message " ERROR OCCURED" my scenario is :  once we upload a document in library it should be copy to another site's or sub site's document library.  can i create a workflow using SPD2010 for this requirement? let me know if anybody have answer.   thanks share2010        

Imported Workflow project does not compile "error 348: Compilation failed. Unable to load one or mor

Original workflow project was compiled on 32 bit machine. I exported it to VS.Net 2010 and it fails to compile. Has anybody seen this error? -Stan  

VS 2010 and error while compiling Workflow project

Get the following message:   ------ Build started: Project: DSS_IP_WorkFlow, Configuration: Debug Any CPU ------ C:\PRJ\JD Powers\DssIP\DSS_IPSoln\DSS_IP.2010\DSSIP\DSSIP-Simulator\DSS_IP_WorkFlow : error 348: Compilation failed. Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.   What I'm doing wrong to my project?

state machine workflow project creation error

Hi,   I have a dev environment which i had sharepoint 2007 and now i upgraded it to sharepoint 2010. Now when i try to create a state machine workflow project it gives me an error Object Reference not set to an object. I uninstalled Sharepoint extensions 1.3 (as i 64bit win2008 vm) and when i am trying to install it. In one of the installation screens where it asks for the port no  and the select the app pool it only shows the sharepoint central v3 app pool . i was expecting to have sharepoint 2010 product app pool in the drop down. I know that there should be a app pool on port 80. Since i upgraded sharepoint to 2010. I want sharepoint visual studio extensions 1.3 to point to sharepoint 80 app pool . Please can you tell me how i can do it.    

Error customizing Approval Workflow in SharePoint Designer

When attempting to customize OOTB Approval Workflow, message "Workflow is read only?"  Request copy errors with "Server could not complete your request" Details button produces blank.  Any clue?  I am the site collection administrator for the site and the secondary farm administrator.

Error editing a document that is running a workflow

After workflow is started i try edit document, but this error is displayed: System.ArgumentNullException: Value cannot be null.  Parameter name: s     em System.IO.StringReader..ctor(String s)      em System.Xml.XmlDocument.LoadXml(String xml)      em Microsoft.SharePoint.Publishing.Internal.WorkflowUtilities.FlattenXmlToHashtable(String strXml)      em Microsoft.SharePoint.Publishing.Internal.WorkflowUtilities.DoesWorkflowCancelWhenItemEdited(String associationXml)      em Microsoft.SharePoint.Publishing.WebControls.ConsoleDataSource.EnsurePageNotInLockingWorkflowIfInEditMode()      em Microsoft.SharePoint.Publishing.WebControls.ConsoleDataSource.LoadDataSource()      em Microsoft.SharePoint.Publishing.WebControls.ConsoleDataSource.OnLoad(EventArgs e)      em Microsoft.SharePoint.Publishing.WebControls.XmlConsoleDataSource.OnLoad(EventArgs e)      em Microsoft.Share.Point.Publishing.WebControls.PublishingSiteActionsMenuCustomizer.OnLoad(EventArgs e)      em System.Web.UI.Control.LoadRecursive()      em System.Web.UI.Control.LoadRecursive()      em System.Web.UI.Control.L

Access Denied/The workflow could not copy the item workflow error after Sharepoint 2010 upgrade

We have a sharepoint designer workflow that copies a document from one library to another on the same site.  Before the upgrade to 2007 it worked fine, but now with 2010 it gives an error and cancels the workflow when it gets to the copy list item step.   The error on the workflow page: The workflow could not copy the item. Make sure the source and destination lists have the same columns and column settings.  Access Denied   Specifically it is the "copy list item current item to documentlibrary" sharepoint designer workflow action.   I have given the system account full permissions to the library and double checked that all columns are the same in both libraries. These are the verbose trace logs:   09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72er Medium System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>Access denied. at Microsoft.SharePoint.SPFile.UpdateInternal(Boolean migrationSemantics, Boolean reGhost) at Microsoft.SharePoint.Workflow.SPWinOEWSSService.CommitCopyFile(Transaction txn, Object[] transData) 09/01/2010 09:46:04.05 w3wp.exe (0x17C4) 0x093C SharePoint Foundation Workflow Infrastructure 72fe High Error in commiting pending workflow batch items: Sys

Receiving Error when Trying to Develop Sharepoint 2007 Workflow using VS 2010 Pro

I have created a Windows Server 2003 Enterprise (32 bit) SP2 image configured with Sharepoint 2007 Enterprise and a trial edition of Visual Studio 2010 Professional.  All software is fully patched.  When I try to create a new Sharepoint 2007 Sequential Workflow (.NET Framework 3.5) in either C# or VB, I receive a pop-up error: Exception of type 'System.PlatformNotSupportedException' was thrown. and, when I click OK and fill in the name of the workflow and a valid Sharepoint Web URL for testing, I receive the following error: SharePoint site location entered is not valid.  The SharePoint site at <removed> could not be found.  Verify that you have typed the URL correctly.  If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application. The URL in question references the default SharePoint site on this test server and does exist.  My assumption is that the second error received is a symptom of the first.  I have looked elsewhere and seen issues related to 64bit SharePoint implementations but, this is a 32 bit installation.  Based on the VS 2010 web site, I have met all of the prerequisites for developing SharePoint 2007 workflows through VS 2010 Pro.  Does anyone have any ideas on what I might be missing or what I need to

An error has occured in Workflow name ?

My library setting- Workflow settings - "Cancellation & Error Report" : Description shows An error has occured in Workflow name. My question is : 1. What is the meaning of the above error? 2. how can i see the detail description of this error? 3. Why this message is coming? Thank in advance for your reply, Justin  

Workflow history truncated description

Hello When viewing the workflow history for a review workflow, the description field is truncated if it is very long (it appear with ... at the end). Is there a way to see the value of the whole field? Someone already asked this question but the answer given is about using the SharePoint Object Model. I am looking for a solution for end-users. http://social.msdn.microsoft.com/Forums/en-US/sharepointworkflow/thread/5af8d475-149b-45eb-b565-e47ccb71a03b

page version history gives error: "value cannot be null. parameter key: name"

Hello, I'm have customized my homepage in SharePoint Designer 2010. I want to go back to a previous version, so I right click on the aspx file in sharepoint designer and choose "version history". When I do that I get this message: There was an error connecting to the server. The server error encountered is "Value cannot be null. Parameter name: key" What should I do in order to revert my aspx page to a previous version ?

SharePoint Designer Error - Unexpected error on server associating the workflow

I am creating a multistep workflow with multiple Approval steps.  When I get to step 7 or the 7th Approval step and try to publish it, it states that "Errors were found when compiling the workflow.  The workflow files were saved but cannot be run."  With "Unexpected error on server associating the workflow" in the advanced section.  This same error occurs at other stages of the approvals as well.  If I put another process/action in the step, the workflow runs without any problem.  Thanks for the help! JeremyJeremy
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend