3989

Product Name

Event ID

3989

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

XACT_UNSUPPORT_PARALLEL_TRAN3

Message Text

New request is not allowed to start because it should come with valid transaction

descriptor.

This error occurs when you execute a distributed query that joins multiple tables hosted by

remote instances of SQL Server while the

session setting is. An error message

similar to the following is reported to the user:

Msg 3989, Level 16, State 1, Line #

New request is not allowed to start because it should come with valid transaction

descriptor.

There are some design limitations in the way SQL Server handles distributed queries (DQs)

when the following conditions are true:

joins multiple tables of one remote SQL Server data source.

The session that is issuing the query is not enlisted in a distributed transaction.

ﾉ

Expand table

XACT_ABORT