| ojamali@comsoltx.com 2005-04-11, 5:54 pm |
| I have a written a AIC component in C#, and am using BizTalk Server
2002 with SP1 and the OS is Windows 2003. This AIC component takes in
the data and calls a web service to do some validation and if the data
passes the validation, it writes the data to a Sql Server 2000
database.
After some time when BizTalk is in middle of processing the data, i get
this entries in event log "error "0x80040e14] The following stored
procedure call failed: { call dta_log_outbound_details(??'Distributed
transaction completed. Either enlist this session in a new transaction
or the NULL transaction.'[0x1625] Changes could not be committed to the
database.
[0x80040e14] The following stored procedure call failed: " { call
cs_create_SuspendedQ_from_WorkQ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?)}". :'Distributed transaction completed. Either enlist this
session in a new transaction or the NULL transaction.'
[0x011e] A new work item in the Suspended queue cannot be created."
And right after this this error gets written to the event log.
" [0x8004e002] The root transaction wanted to commit, but transaction
aborted"
Anyone out there know how to get around this problem or how to resolve
it. The file size that i am using is between 90 and 100k(Biztalk should
be able handle this file size pretty easily) and contains about 700 to
800 records. I am at my wits end over here and would gladly welcome any
help from anyone.
|