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

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

Workflow SqlTrackingService Not Saving Data

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :JavaScript/VBScript


I’m trying to implement the SqlTrackingService for Workflow Foundation. I’ve installed the schema & logic and have added the appropriate code to the Service element of the web.config file. I know that my application is trying to access the tracking tables because if I rename them it’s throws an error.

I’ve created and completed a workflow but no data is appearing in the tracking tables. From what I’ve read it should work OOB but am I missing something?

Couple of other questions. I originally put the tracking tables in a separate database but my application didn’t like the tracking being in a separate database to the content to which workflow was being applied. Is this how tracking has to be implemented?

We put our database connection details in a separate file from the web.config, can I do the same for the tracking db connection or does this have to an attribute of the service/

Application is .Net 3.5 & SQL Server 2005. It also uses SharedConnectionWorkflowCommitWorkBatchService & SqlWorkflowPersistenceService and looking at some other threads I wondered if this has an impact.

Thanks in advance


View Complete Post

More Related Resource Links

Saving textbox data to MySql database in asp.net


Hi dear coders

though a very simple question to ask, but please tell me how to save and retrieve data in/from my textboxes to/from database (MYSQL) on submit button click.

i know its a very simple task but i cant make it done, so i request you to please send me some working example link or post any helpful code here in asp.net

i will be highly thankful for any kind help from you geniuses.



Modify User in Collect Data from User Workflow


I've created a workflow with a Collect Data from User action that emails a Group when the task is created. Once the task is claimed by an individual, the Assigned To column in the task list is updated to display that person's name but once the task is completed the email variable for the action is not updated and the group is emailed instead of the person listed as Assigned To.

So the question is this: Is there a way to update the user varialbe in the workflow task once the task is completed, or would I need to build my own workflow and use the Send Email action?

Excel sheet is not saving data while sending email

Hey Guys,  I am creating a SSIS package, where I am getting all the data into the excelsheet1, which is not formatted. So i created a formated excelsheet2, where i am giving reference to excelsheet1 cells reference. And I am sending email by attaching excelsheet2.              I am having issue when the data is updated, but my email attachment excel is showing old data. When i open the excelsheet1 it is being updated. I don't know why excelsheet2 is not updated automatically. I am using BIDS 2005 . Can anyone please suggest what will solve my problem. Thanks in Advance Priyamvadha

Share Point Designer 2007 Workflow (Sequential) - multi-collect data from user

I am currently building a multi-step workflow using ShrePoint designer for MOSS2007. I am getting a bit confused as to if I have an error or if I am doing something incorrect. Here is what I have going. My workflow consists of something similar to the following New document comes in, a collect data from user routine is ran and assigned to a reviewer. My understanding when I create a collect data from user WorkFlow step is any data I request is saved in the "Tasks" list. Therefore I need to grab the workflow task ID in order to later lookup what the reviewer submitted... I understand this...   However, I have one more collect data from user workflow step and I have one more item to collect. Even though this is a brand new collect data from user workflow step - does the collected data still go into the "Tasks" list? In other words, if I have two steps in a workflow and both of these steps are "collect data from user", does the data from both steps go into the same "Tasks" list?  I could see how this might be possible as long as the Task list columns contain all the items for all the different "collect" data from user steps.  I don't see two different Tasks lists representing or named "Reviewer" or "Final" or anything, so I assume the items are all in "Tasks"   However..

can a Workflow access a stored procedure and pass the parameters from the list data to the stored pr

The reason that I would like to consider this functionailty is because my table architecture is complicated and I do not want to modify my master table to accept all of this data where some of the data should be normalized into sub tables.  Has anyone see evidence of the stored-procedure parm approach?  Is this best accomplished through VS 2010 or can I do it through SPD? Thanks

showing modalpopup and saving data to database simultaneously using ajaxtoolkit and javascript

hi,i have a button ,i want that when i click on that button the data should be saved in the database as well as at the same time a modal popup should display the customerid .i have written the code as <asp:button id="save1" runat="server" onclick="Button4_Click" style=""z-index:" mode="hold" xmlns:asp="#unknown" /> left: 740px; position: absolute; top: 304px" Text="save"/> <asp:panel id="panel" runat="server" xmlns:asp="#unknown">  /asp:Panel> <ajaxtoolkit:modalpopupextender id="MPE" runat="server" targetcontrolid="save1" xmlns:ajaxtoolkit="#unknown"> PopupControlID="panel" DropShadow="true" BackgroundCssClass="modalBackground/> protected void Button4_Click(object sender, EventArgs e) { string id = TextBox1.Text; string name = TextBox2.Text; string cn = "Data Source=hcl;Initial Catalog=mydata;Integrated Security=True"; SqlConnection con = new SqlConnection(cn); SqlCommand cmd = new SqlCommand("insert into customer values (@id,@name)", con); con.Open(); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@id", id); cmd.Parameters.Add("@name",name); cmd.ExecuteNonQuery(); con.Close(); CUSTID.Text = id.ToString(); MPE.Show(); }

Workflow data missing from Document Library

Hi, We have this strange situation where the workflow status is missing from document library views. Here is the situation: I have a Document Library with 3 OOTB approval workflows configured to start manually. Process is that user uploads a doc, start the first workflow, once it gets completed starts the second, and so forth. Now if I check the All Documents view of this Document Library, I can see these three workflows have 3 columns and that shows the status of the workflow - say "In progress", "Completed" etc. Now our users who use this document library and workflow complains that they cannot see these status of the workflow after some days. If a workflow is completed and status shows completed there, but after some days that column is blank. I've checked the modified data for the documents and this issue according to the user happens to documents that was uploaded 2 weeks back too, which means this doesn't happen to old document only. This document library has Major and Minor versioning enabled. Why does this happen, does SharePoint remove data for completed workflows? I checked the document's workflow page and its empty; nothing under running workflows and nothing under completed workflows. In Doc Library settings - Workflow settings I could not find an option View Workflow reports. That page has the following details: Use this page to view or

sharing data between workflow during execution

Hello, I have number of workflows which are running at the sametime. I have a activity that gets the file from a remote location. It is possible that multiple workflow might require the same file. Is it possible, that once a given workflow has requested for the file, and if someother workflow wants the same, instead of looking for file, it waits for it, when the other workflow has downloaded the file, then it can use the same file. Similarly i have workflow loading files to a dataset, it is possible that other activity might want to load the same to a dataset can somebody please point to me, how can i do it, i have read about extension, but I am not able to find any documention, thats shows how can i use them for sharing information between workflows.

saving a text file in ms access data base

i have to read a text file in a text box then have to save it into ms access data base in column format how could i do this....

Insert "View Entries..." data into custom workflow e-mail

Scenario: There is a custom task list (not created by me) that has a Multiple Lines of Text column called [Description] that is displayed in views as a "View Entries..." hyperlink to the DispForm. On the DispForm there are hyperlinks to each previous version as well as the modifying user. Problem: I need to create a workflow that e-mails the person to whom the task is assigned to with looping functionality whenever it is reassigned. All of this works fine, except I am unable to insert the [Description] column info into the e-mail. I have tried adding the [Description] column lookup to the body, as well as assigning the contents to a string variable and displaying it, but none of these things work. I also discovered that when I switch to Datasheet view the entire [Description] column is empty. When I turn off "Append Changes to Existing Text" to the column, the "View Entries..." hyperlink disappears workflow functions just fine, but since the descriptions can run rather long people don't want to remove this functionality. Any help on the subject would be apprecated!

Saving data in javascript from codebehind and use data in other javascript functions


In the Page_Load event I want to write some data in javascript which can be used later via a javascript function.

Protected Sub Page_Load
'get data from database
    SELECT * FROM locations
'write the data in javascript
    Me.Page.ClientScript.RegisterClientScriptBlock(Me.GetType(), "ScriptKey", "var sDataArray = MultiDimensionalArray(0, 3);sDataArray[0][0]='THIS IS SOME DATA';", True)

End Sub

Then in the ActiveTabChanged event of the tabcontrol I want to use that data:

 function ActiveTabChanged(sender, e) {
     if (sender.get_activeTabIndex() == 1) {
         __doPostBack(sender.get_id(), sender.get_activeTabIndex());
 How can this be done?

Reading Infopath Repeating Table data in .Net Workflow


Hello, i have an infopath for that has a repeating table on it that i am using for users to add comments. The table contains a couple of textboxes, one that automatically inserts the users name into it and the other for the user to enter their own comments. I want to be able to read the contents of the repeating table when a manual workflow is started against the form list in sharepoint so that i can email all the users who have left comments on the form.

I am struggling to find any info on reading repeating table data from an infopath form in a .net workflow. I have tried using an XPathNavigator to select the repeating table but it only displays the first comment in the table.

Can anyone provide any info on accomploshing this or point me to any articles that explain how to do this?

thanks a lot



pass data to event in workflow



i have the event that calling  my workflow to start,then this workflow when is completing must passing data to this event.

how i can call(and pass data to)event in sequential workflow programming?(in sharepoint2010,visual studio2010) 


Saving Data from Excel


Can someone point me in the right direction.

I need the ability for a user to browse to an Excel sheet stored on his local machine and save the contents into a database table.


VS 2010 Workflow -Linq Data Connections



We have several workflows to build that will use a common linq data class.

What is the best way to expose this class to all WF projects?

Tried a solution with 2 projects 

  • The data class
  • The workflow with references to the data class

But the workflow always "failed on start"

Soon as I removed the references to the dataaccess project it ran OK



Saving arabic data in sql server


Hello, I have a multilanguage system, where i want to save both arabic and english data, so when inserting or updating arabic data, I am using N, but when i am inserting, it is still saving ???? while updating it is being saved properly.

Please could you advise why the update statment is working while on the other hand the insert is not.




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