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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Using "Transaction activty" in Workflow to update 2 tables - throws "communication with the underlyi

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :WPF
 

Scenario:
I created a transactionscope over 2 code activities,
Code activity1 opens a connection, fires an insert into a table and closes the connection.
Code actibity2 also opens connection, does a simple insert into same table and closes the connection

Observation:
I get the following exception:
The 1st code activity runs fine, then the second code activity fails when it tries to open a connection and I get this message "Communication with the underlying transaction manager has failed. "

Note:
I have persistence services working properly, I'm able to persist the workflows..which means my MSDTC is configured right, also able to insert data into the tables..but when I use the transactionscope I just get that error whever I open the connection in the second code activity

Am I missing something or this is one of those inbuilt bugs of the "workflowfoundation" bugs like the timer etc?





View Complete Post


More Related Resource Links

Event Hanlder to update other SQL tables

  

Hi,

I'm writing a small app to allow viewing and editing of a single SQL table (the _Assets table).

I have a form-view that allows the data to be viewed (ItemTemplate) and edited (EditItemTemplate).

Everything works well. All the SQL editing is done in the Mark-Up using a simple SqlDataSource, asp:Parameters and data-binding, (ie. there is no VB code behind).

However, I need to write an event-handler which updates other tables when the EditItemTemplate INSERT button is used.

This event handler needs to update OTHER SQL tables.

The idea is to create a HISTORY of changes (Updates) made to my _Assets table.

It would look something like this:

IF the value of the _Assets.Comments field is changed by the formview, then:

Open SQL connection to _CommentsHistory table

Update _CommentsHistory

SET CountrySerial = asp:Parameter Name "CountrySerial" from SqlDataSource ID="FindAsset"

SET OldComment = [the original Comment] asp:Parameter Name "Comments" from SqlDataSource ID="FindAsset"

SET NewComment = [the New Comment inserted in the formview] TextBox ID="CommentsTextBox" from FormView ID="FormView1"

SET ChangeDate = { fn (now)}

Set ChangedBy =

SqlDataAdapter.Update related tables

  

Hi!


I would like to get 2 related tables from SQL Server to DataSet, insert new rows and save them back to SQL Db.


Let's say i have 2 related tables as shown below...

Table1 Table2
test1ID (Primary Key) test2ID (Primary Key)
data test1ID

data

In Sql i have Diagram with relationship and Update Rule is set to Cascade


I am trying to get them to dataset, insert "master" and "child" row and save them back to db.

I tried different approaches (none of them workes) and this is one of them:

Dim ds As New DataSet()
        Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("NastanitveConnectionString").ConnectionString)
        Dim sql As String = "SELECT * from Table1;Select * from Table2;"
        Dim d

Update workflow task

  

Hello guys,

 

I created a timer job service to send reminders when a task is overdue, now I am looking at how visible it is for reassigning the task to some one else within the timer job service itself.

 

Is this possible?

 

Thanks


How to update Sql Server related tables from Dataset(SchemaFill)

  
Hi!I would like to update new records that get inserted in DataSet to Sql Server Database.Below is a working example of how to do this if you use "DataAdapter.Fill(ds)". But i don't want to fill data, becouse i don't need data, i only need shema (I will use this dataset to insert new data to Sql), so i would like to use "DataAdapter.FillSchema(ds)"Please help me out at least with this one... i'm stuck... can't continue untill i crack this nut.<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <table> <tr> <td> <asp:GridView ID="GridView1" runat="server" ShowHeaderWhenEmpty="True"> <Columns> <asp:CommandField ShowSelectButton="True" /> </Columns>

Update related tables

  
Hi All, Forgive me if this is the wrong place to post this question. I looked for a forum on SQL statements but couldn't find one. I have a FormView with data from two tables in the SqlDataSource.  The second table is linked to the first by a FK/PK. There is an example from the Northwind SQL database, e.g. if the Products table is the main table but I want to display the Category Description in the FormView and edit it, how do I write the Update and Insert statements.? I have tried using the query builder in VS 2008  but it doesn't seem to work. Any help greatly appreciated. Regards,Penn

Start workflow on database update

  
HiIs there a way to start a workflow when something in a database has changed (e.g. a row was added)? I am looking for something similar to a Receive activity, but which monitors parts of a database.Could that be achieved by having a "master" workflow that spins off sub-workflows?ThanksAlex

help with query - update from 2 tables

  
hi i have 2 tables     table1: num,X,Y     table2: num,X,Y i need to update X and Y in table1 where table1.num = table2.num how to do it ? i need it in Oracle query (i think that in sql server it will work too) thank's in advance 

2007 VHD - Workflow Setting throws "The trial period for this product has expired"

  
I recently downloaded the SharePoint 2007 VHD from this link: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=67f93dcb-ada8-4db5-a47b-df17e14b2c74&displaylang=en The above link shows 5/3/2010 as Date Published.  So I am assuming that this is the new version of VHD published this year. I am able to login to this VHD and also view the default SharePoint site.  But, when I goto Workflow Setting of a List and click on NEXT button, it throws "The trial period for this product has expired" error.  This error is not written in ULS LOGS. I also noticed something strange in "WIN03_MOSS_README.htm", which is part of this download.  The Program Details section in this Readme says: The evaluation period for this virtual machine image ends @ 2/22/2011.  NO EFFORT SHOULD BE MADE TO ACTIVATE THIS IMAGE.  After 2/10/2010, the evaluation period is over and the image should be discarded.  So what exactly is the expiry date of this VHD?  Is it 22-Feb-2011 or 10-Feb-2010?  Can someone from Microsoft VHD team provide a valid response. Thanks & Regards, Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.

Approval Workflow does not update the Content Approval status if started automatically

  

Hi,

I’m using a simple Approval Workflow associated with Content Approval on site pages. It works fine when I set it to be started manually (by using Allow this workflow to be manually started by an authenticated user with Edit Item permissions  option) and on the completion of the workflow the Content Approval status is updated accordingly. But when I set it to be started automatically (by using Start this workflow when a new item is created  / Start this workflow when an item is changed options), it does not updates the Content Approval status. Note that I’ve set the Update the approval status after the workflow is completed (use this workflow to control content approval) option to true.

Regar

Approval Workflow does not update the Content Approval status if started automatically

  

Hi,

I’m using a simple Approval Workflow associated with Content Approval on site pages. It works fine when I set it to be started manually (by using Allow this workflow to be manually started by an authenticated user with Edit Item permissions  option) and on the completion of the workflow the Content Approval status is updated accordingly. But when I set it to be started automatically (by using Start this workflow when a new item is created  / Start this workflow when an item is changed options), it does not updates the Content Approval status. Note that I’ve set the Update the approval status after the workflow is completed (use this workflow to control content approval) option to true.

Regards

Approval Workflow does not update the Content Approval status if started automatically

  

Hi,

I’m using a simple Approval Workflow associated with Content Approval on site pages. It works fine when I set it to be started manually (by using Allow this workflow to be manually started by an authenticated user with Edit Item permissions  option) and on the completion of the workflow the Content Approval status is updated accordingly. But when I set it to be started automatically (by using Start this workflow when a new item is created  / Start this workflow when an item is changed options), it does not updates the Content Approval status. Note that I’ve set the Update the approval status after the workflow is completed (use this workflow to control content approval) option to true.

Regards

How do I create a query that joins two tables and returns a single entry with the most recent update

  

Say I have the following two tables (Purchase & Customer). 

CustomerID StoreName PurchaseDate
1 Asheville 9/14/2010 15:49

Insert/Update data to multiple tables on a single button click

  

Hi experts,

I need to insert/update data to 3 or more tables on a single button click.What is best method for achieving this?I am using mysql as my DB.

Thanks for your valuable reply in advance.


Update Infopath Fields with SharePoint Designer Workflow

  

Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.

 

Regards..

 


Update Approval Workflow task status

  

Hello All

I am trying to update the task status automatically after a list item is approved without much luck. I need to set the task status to "completed" without having to manually hitting the "complete task" button, so the next person in line can approve the list item.

How can I change the status of a task using SharePoint Designer 2010?

In my SharePoint Designer task editor I have:

<code>

if Current Item:Approval Status equals 0;Approved

---I need to add a line in here that updates the task status to "completed"

Assign Approve list item to User2

</code>

 

Thank you all in advance.

Regards

Yoshi


Update Infopath Fields with SharePoint Designer Workflow

  

Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.


Update a table from two different tables

  

Hi there,

I'm working on SQL Server 2005.

I need to compare two tables and then update a third table depending on the comparison from two tables.

let's say I have Table A - the one I need to update

Table B and Table C. both of these tables have a common fieldname CustomerName, now when CustomerName from Table A and CustomerName from Table C are the same, I need to update Table A CustomerNameExist field with something like 'YES'

Let me know if I'm making sense here.

Thanks,

Midway

 


Categories: 
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