> DTC transaction prepre phase failed Why did it fail? The likely issue is a transaction timeout
On Wed, Jun 16, 2010 at 9:38 PM, Jan Limpens <[email protected]> wrote: > Hello, > > First of all - I am cross posting this to both nhibernate as well the rhino > list, as I cannot tell, where to ask this. Hope this is not too much of a > problem. > > I am facing this problem: I use a message bus (rhino) to create entities, > usually this works nicely, but here I have a problem. > Nhprof logs it like this: > > It starts with a few valid inserts... > > -- statement #1 > enlisted session in distributed transaction with isolation level: > Serializable > > -- statement #2 > INSERT INTO InventoryItem > (DefaultCosting, > DefaultPricing, > DefaultPurchasing, > DefaultSelling, > DefaultStocking, > Name, > Description, > IsPublished, > InventoryItemId) > VALUES (NULL /* @p0_0 */, > 'UN' /* @p1_0 */, > NULL /* @p2_0 */, > 'UN' /* @p3_0 */, > 'UN' /* @p4_0 */, > 'Fantasia Abelhinha' /* @p5_0 */, > '' /* @p6_0 */, > 0 /* @p7_0 */, > '37fb990c-fe53-4f1c-961b-9d9700f2b8ed' /* @p8_0 */) > > -- statement #3 > INSERT INTO UnitsOfMeasure > (InventoryItemId, > CanPrice, > CanSell, > CanStock, > Code, > ConversionFactor, > Weight) > VALUES ('37fb990c-fe53-4f1c-961b-9d9700f2b8ed' /* @p0_0 */, > 1 /* @p1_0 */, > 1 /* @p2_0 */, > 1 /* @p3_0 */, > 'UN' /* @p4_0 */, > 1 /* @p5_0 */, > 0 /* @p6_0 */) > > -- statement #4 > commit transaction > > and then, suddenly all goes red and I get a bunch of these > > -- statement #1 > enlisted session in distributed transaction with isolation level: > Serializable > > -- statement #2 > INSERT INTO InventoryItem > (DefaultCosting, > DefaultPricing, > DefaultPurchasing, > DefaultSelling, > DefaultStocking, > Name, > Description, > IsPublished, > InventoryItemId) > VALUES (NULL /* @p0_0 */, > 'UN' /* @p1_0 */, > NULL /* @p2_0 */, > 'UN' /* @p3_0 */, > 'UN' /* @p4_0 */, > 'Fantasia Abelhinha' /* @p5_0 */, > '' /* @p6_0 */, > 0 /* @p7_0 */, > '225cd996-1bc8-4560-bb08-9d9700f2b8ef' /* @p8_0 */) > > -- statement #3 > ERROR: > Could not synchronize database state with session > > > -- statement #4 > ERROR: > DTC transaction prepre phase failed > > then a few inserts go ok, etc... > > The insert statement is per se is ok in query analyzer, > > And then again, I do get valid inserts in between. So I guess some of my > settings are off - but unfortunately I cannot tell which... > > Of course, there must be a lot of missing information, needed to debug > this, here, but better I provide this as feed back, then > One I cannot provide is the usual rhino error message. out of some reason, > it is not generated, only the message is copied to the error queue, no > reason given. > > Ideas? > > -- > Jan > > -- > You received this message because you are subscribed to the Google Groups > "Rhino Tools Dev" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<rhino-tools-dev%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/rhino-tools-dev?hl=en. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
