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 11.2.0.2 and later
Information in this document applies to any platform.

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

Symptoms

On x64 when RDBMS version is Oracle 11.2.0.2.0 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.

Cause

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