InvalidOperationException - The Promote Method Returned An Invalid Value

(Doc ID 1439460.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Data Provider for .NET - Version and later
Information in this document applies to any platform.

*** Checked for relevance on 10-Jul-2017 ***


On x64 when RDBMS version is Oracle patch 2 or greater an error occurred when the second sql statement is executed in the same distributed transaction:

"InvalidOperationException - The Promote method returned an invalid value"

STACKTRACE: at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx)
at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)
at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
at System.Transactions.Transaction.Promote()
at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)
at System.Transactions.TransactionInterop.GetTransmitterPropagationToken(Transaction transaction)
at Oracle.DataAccess.Client.OracleConnection.Open()
at [Name of Executable].Program.Main(String[] args)

where [Name of Executable] is the actual name of the code being run.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms