| Deepak 2005-04-12, 5:53 pm |
| Hi,
There might be different reasons why you are getting this
error. One of that I have seen is due to Transaction
errors.
How are you updating Data to SQL Server 2000? Is it
Transactional? If so check whether your Transaction to
update the SQL DB Store is being aborted, if so Biztalk
Transaction would also be aborted and you will get the
error messages.
Hope this helps.
Deepak
http://deepakl.blogspot.com
>-----Original Message-----
>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.
>
>.
>
|