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
"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.
