.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

Missing Worklfow Status Column

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

I have a workflow running against a custom list and it is working pretty fine but I can't see the the column that is associated with the existing workflow, usually a list has a column containing the name of the workflow and this particular column register the current status value like "In Progress"


I removed the workflow, and attached again to the list but no columns were creaated, them I removed again the workflow and removed all the data from the list and I removed all items form the recycle bin before re-attaching the workflow and creating a new instance but I had no lucky in obtaining the status column of my workflow.


I'm really frustrated because I can't find any means to have this column on my list and I just want to find a way to have the status of the workflow being published to my list like any other workfow usually does.



View Complete Post

More Related Resource Links

Modified column missing when sorting


I resently updated few document libraries on my sharepoint site.  What I did I removed "Content approval" from those libraries and now my modified and created columns are missing from the columns of the list (appear to be hidden ).  So, I need to be able to sort by these columns and I have seen many people asking about this same question but I haven't found any answer to this issue.  The columns are still there but I they dont show up in the columns of the library.  I can still create a view with this columns but i cant sort by them.

Is this a bug or is there a reason why sharepoint does this? 


Thread status image missing

Note the "Red Box" where the image is missing. There are replies posted to that thread and also an accepted answer.Here is that thread link: http://forums.asp.net/t/1601163.aspxP.S. This might be normal but I noticed today.

Missing column statistics from default trace

I am seeing Missing statistics events on my default trace and was wondering whether I need to create statistics on the table. Missing Column Statistics Is this a good practice considering the advice on http://msdn.microsoft.com/en-us/library/ms190397.aspx

Change the Status in Gridview column




I have a gridview and a button-Start in aspx page.

In gridview 3 columns checkbox , Name and Status.

Select multiple columns and click on Start then Status column for selected rows should be changed to "Starting...", later it should be changed to "Started".


But it is showing directly "Started". In the mean time i should see "Starting..." also.


Here is my code


<b>Aspx page</b>


 <asp:GridView runat="server" AutoGenerateColumns="False">


<asp:TemplateField>   <ItemTemplate>                                                    <asp:CheckBox runat="server"/>



<ItemTemplate> <asp:BoundField HeaderText="Name" DataField="Name" />  

<asp:TemplateField HeaderText="Status">          &nb

Content Query Webpart Missing Content Type and Approval Status


I'm a great fan o the CQWP , and love the changes made in 2010 on this webpart. What bothers me is that I use to Filter Documents by Approval Status, thus showing Draft or Pending Documents and Group these by their Content Type.

Both these were available in 2007, but removed from 2010 CQWP. Any idea why, or how to bring this back? sample or URL guidance would be great. My gut feeling is custom XSLT but id like to confirm this first.

Thx a lot



document library column header is missing


When I open any document libraries within a specified site collection, I found out they all missing column headers. I could not do sorting on the columns. Anyone knows why?

Thanks in advance,



Missing column in MSlogreader_history table in the distribution database

We recently built a new two node cluster on a Windows 2008 R2 64bit OS. We installed SQL 2005 64bit Enterprise with SP3 and CU7. We want to run replication from node 1 (1 instance - publisher) to node 2 ( 2 instances - distributor instance and a subscriber instance). We use scripts to build transactional replication (push). These scripts have been used before in an identical setup except it is CU3 instead of CU7. On our new setup, with CU7, the MSlogreader_history table in the distribution databse is missing the @updateable_row column. We only have 15 columns in this system table on our new CU7 setup. The older CU3 setup has 16 columns in the MSlogreader_history table including the updateable_row column.

Replication monitor shows an error stating that the sp_MSadd_logreader has too many arguments specified (Code 1007).

Why is our MSlogreader_history table missing the updateable_row column, and how can this be fixed?

Many Missing Column Statistics errors on full-text index fragments, even after reorganizing catalog


I seem to have a large number of full-text index fragments, even after reorganizing both full-text catalogs. (SQL 2008)

While reviewing the results of the default trace, I noticed many “Missing Column Statistics” errors.  Seeing as how there are over a thousand of these errors within a 12 hour period, I figure this is something I should take care of. 

From trace, text data column:

  NO STATS:([MyDBName].[sys].[ifts_comp_fragment_2014778570_51269].[colid], [MyDBName].[sys].[ifts_comp_fragment_2014778570_51269].[pid], [MyDBName].[sys].[ifts_comp_fragment_2014778570_51269].[docidmax], [MyDBName].[sys].[ifts_comp_fragment_2014778570_51269].[dupseq])

When I query sys . fulltext_index_fragments , I see about 15 different fragments for each catalog, all with a status of 4.  I expected to see many more fragments listed, with a status of 0 maybe?  I guess I’m misunderstanding something.

After reorganizing the catalogs, I’m still seeing these

SSIS import - Missing 1st column from Excel


Hi ,

I have gone through some of the materials posted on this topic. but didnot work out for me. I am trying to import the excel file using ssis. I have got the header details , I have to skip the header  while importing. I am using following sql commad: to import . I am able to skip the header row, but missing the 1st coumn from excel.I am not able to add the F1 column in the query . Can any know why it is not possible, because of this I am miisng the 1st column to import.

 SELECT F2, F3,F4, F5
from [Sheet1$]
where (f2is not null) and (f2<>'status')

Please help me out




SP Datasource select Command not working for Status Column



    (MOSS 2007-Webuser control Web part)

    I'm having a cutom list that i'm binding using SPDatasource to a gridview. I want to filter the list based on column values. I tried the following code

            SPList taskList = site.Lists["Accounts"];
            SPDataSource mySPDS = new SPDataSource();

         mySPDS.SelectCommand = "<View><Query><Where><Eq><FieldRef Name='Vendor_x0020_Name'/><Value Type='Text'>"+ddlVendorName.SelectedItem.Text +"</Value></Eq></Where></Query></View>";


mySPDS.SelectCommand = "<View><Query><Where><Eq><FieldRef Name='Status'/><Value Type='Choice'>" + ddlStatus.SelectedItem.Text + "</Value></Eq></Where></Query></Vi

email alert notification when task status column value is chaned


Hi All,

I am creating a document library in which there are few columns present (like Assigned To,Task Status,Reviewr etc.)

I want to send alert or email notification when the status value is changed. Alert should go to "Assigned To" selected value from the Reveiwers name.

I have tried this with "alert me" functionality provided by WSS 2007 but I think it will not sufficient for me?.

I am not able to proceed please help me?

WorkflowStatus column showing status 8 across all ListItems


Hi All,

I have a list that has a two out of the box workflows i.e. Approval Workflows and one custom workflow (C#) attached to it.

We know that for each Workflow, a new column is automatically  created in the list; showing the status of the workflow.

From the front end I see, that these columns show the correct status i.e. In Progress / Completed etc.

However suddenly from past few days the internal value of these columns is showing 8 which is in correct and because of which the custom workflow has stopped working. The code for the custom workflow has not changed and the same code is being re-used on other list and workflow status is showing correctly on those lists.

Here are the status values as shown in the MSDN documentation:


NotStarted Workflow has not started.
  FailedOnStart Indicates that the workflow encountered an error when it started.
  InProgress Workflow is currently in progress.
  ErrorOccurred An error occurred during the execution of the workflow.

Missing column data in my dbo, but the URL is showing in the Meta SRC URI column.


I'm having a problem with my Body1 description column showing up.  My record number is 6858, and only 5857 will load up.  I cut the size down to 5,000 and it worked completely.  Do you have any ideas?  Do I need to increase some size settings?

Thank you

Why is workflow status column empty and how to change it?


One particular instance of the workflow shows workflow status column as empty although it should be showing IN PROGRESS since if click on workflows from item's context menu I can see the workflow running on it;  _layouts/workflow.aspx show it as in progess.
This workflow was not created 60 days ago and its not complete. I wonder why it displays empty in the workflow status column.

Also can this column be changed from web service? I tried using:

<FieldRef Name='myworkflow'>2</Field><FieldRef Name='ID'>23</Field>

and updating it. While the webservice code does not throw any error and ListService.UpdateItems() returns 0x000000, this column doesnt get updated. Any ideas what could be wrong?

Workflow on status column change


I want a workflow on a content type with a status column (new, pending, completed, ....)

I want it to fire off when this column changes, not when the item is updated, because it might be updated for other reasons (the title changed).  How do I make sure it only happens on the column change? 


Approval Status Value and Version missing in "Edit in datasheet" and "Export to Excel "


Hi there.

Anyone knows how to show the WF approval status value (Approved, In process, Rejected...) and the version column from library and list to xecel download (Export) or in datasheet?

Your expert advise will be much apprecaited.

Status List WebPart or KPIListWebPart missing when create sites based in a site template that has it


Hi Everyone,

I have a site collection in SharePoint server 2010, and within this site collection I have a site. This site has KPIListWebPart or Status List WebPart. I have added this WebPart through SPD 2010, because through SharePoint you cannot add this particular WebPart.

The problem is the following:

The site (with the Status List WebPart) has to be a Site Template, in order to allow the users to create sites as needed. In the site, the Status List WebPart works perfectly, but when I create a new site based in the site template, the Status List WebPart is missing. 

Any idea why is it happening?


Thanks in advance and best regards,


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