Attempted to read or write protected memory using TransactionScop e and Oracle 10g Client.

[OUSoonerTaz]

We are randomly getting this error message on our development and
staging machines:

Attempted to read or write protected memory. This is often an
indication that other memory is corrupt.; at
System.Data.Com mon.UnsafeNativ eMethods.OraMTS JoinTxn(OciEnli stContext
pCtxt, IDtcTransaction pTrans)
at
System.Data.Ora cleClient.Trace dNativeMethods. OraMTSJoinTxn(O ciEnlistContext
pCtxt, IDtcTransaction pTrans)
at System.Data.Ora cleClient.Oracl eInternalConnec tion.Enlist(Str ing
userName, String password, String serverName, Transaction transaction,
Boolean manualEnlistmen t)
at
System.Data.Ora cleClient.Oracl eInternalConnec tion.Activate(T ransaction
transaction)
at
System.Data.Pro viderBase.DbCon nectionInternal .ActivateConnec tion(Transactio n
transaction)
at
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)
at System.Data.Ora cleClient.Oracl eConnection.Ope n()

We are using VS2005, C#, Oracle 10g Client, and the TransactionScop e.
When we get this error, it's usually either on the opening of the
connection OR on the execution of the proc/package. We had to install
the client, then install, as a separate package the oracle support for
MTS which supports transactions.

Here is a snippet of code that causes this error:

using (TransactionSco pe scope = new TransactionScop e())
{
using (IDbConnection connection = this.GetConnect ion())
{
connection.Open ();
...DO SOME STUFF
try
{
command.Execute NonQuery();
foreach (IDataParameter parameter in command.Paramet ers)
{
if( parameter.Direc tion.Equals(
ParameterDirect ion.InputOutput ) || parameter.Direc tion.Equals(
ParameterDirect ion.Output ) )
returnParameter s.Add(parameter );
}
}
catch (Exception ex)
{
// ERROR HANDLING HERE
}
}
scope.Complete( );
}

Like I said, it happens randomly, but when it does occur, it's on one
of those two methods Open or Execute. Does anyone have any idea why
this breaks down

Thanks in advance for your help!

Sean

[bob]

Hi,
They don't come much worse than this do they?
As a test I suggest that you instantiate a new connection inside the method
rather than calling out for it.

FWIW
Bob
<OU*********@gm ail.com> wrote in message
news:11******** *************@g 14g2000cwa.goog legroups.com...

We are randomly getting this error message on our development and
staging machines:

Attempted to read or write protected memory. This is often an
indication that other memory is corrupt.; at
System.Data.Com mon.UnsafeNativ eMethods.OraMTS JoinTxn(OciEnli stContext
pCtxt, IDtcTransaction pTrans)
at
System.Data.Ora cleClient.Trace dNativeMethods. OraMTSJoinTxn(O ciEnlistContext pCtxt, IDtcTransaction pTrans)
at System.Data.Ora cleClient.Oracl eInternalConnec tion.Enlist(Str ing
userName, String password, String serverName, Transaction transaction,
Boolean manualEnlistmen t)
at
System.Data.Ora cleClient.Oracl eInternalConnec tion.Activate(T ransaction
transaction)
at
System.Data.Pro viderBase.DbCon nectionInternal .ActivateConnec tion(Transactio n transaction)
at
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject)
at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n)
at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry)
at System.Data.Ora cleClient.Oracl eConnection.Ope n()

We are using VS2005, C#, Oracle 10g Client, and the TransactionScop e.
When we get this error, it's usually either on the opening of the
connection OR on the execution of the proc/package. We had to install
the client, then install, as a separate package the oracle support for
MTS which supports transactions.

Here is a snippet of code that causes this error:

using (TransactionSco pe scope = new TransactionScop e())
{
using (IDbConnection connection = this.GetConnect ion())
{
connection.Open ();
...DO SOME STUFF
try
{
command.Execute NonQuery();
foreach (IDataParameter parameter in command.Paramet ers)
{
if( parameter.Direc tion.Equals(
ParameterDirect ion.InputOutput ) || parameter.Direc tion.Equals(
ParameterDirect ion.Output ) )
returnParameter s.Add(parameter );
}
}
catch (Exception ex)
{
// ERROR HANDLING HERE
}
}
scope.Complete( );
}

Like I said, it happens randomly, but when it does occur, it's on one
of those two methods Open or Execute. Does anyone have any idea why
this breaks down

Thanks in advance for your help!

Sean

[dom]

Have a look to the service called 'Distributed Transaction Coordinator'. It must be set to Automatic Start. Otherwise the error occurs.

[naz]

That worked and was very helpful, thanks. . .

Have a look to the service called 'Distributed Transaction Coordinator'. It must be set to Automatic Start. Otherwise the error occurs.