Oracle Database Discussions

Hi All,

I'm baffled by a bug returned by the Oracle data adaptor for .NET. I'm certain that it's a configuration issue as the application runs fine on other servers. This server is was built the same way, but obviously I've missed something. Does anyone have a similar experience or have any insight to offer, **please** ? Very urgent (of course!).

With grateful thanks,
Kierman

Environment:
- Windows 2000 Advanced Server with SP3
- .NET Framework 1.1
- Oracle 9i Client version 9.2.0.1.0
- Oracle9i 9.2.0.1.1 Patch for Oracle Service for MT
- Oracle Data Adaptor for .NET 9.2.020

Error is: "ORA-00161: transaction branch length 72 is illegal (maximum allowed 64)"


Trace is (read from bottom up):

2004-04-28 09:41:56,250 [2072] DEBUG WebService - Adding new request:ID=0,IMEI=121212121212121,reason=1,type=Bar,source=4,currentStatus=Unknown,subscriberNumber=0871212121,unbarPassword=unbar
2004-04-28 09:41:56,265 [2072] DEBUG RequestManager - AddRequest: ID=0,IMEI=121212121212121,reason=1,type=Bar,source=4,currentStatus=Unknown,subscriberNumber=0871212121,unbarPassword=unbar
2004-04-28 09:41:56,390 [2072] ERROR DataAccess - Oracle exception (ORA-00161: transaction branch length 72 is illegal (maximum allowed 64)).
Exception: System.Data.OracleClient.OracleException
Message: ORA-00161: transaction branch length 72 is illegal (maximum allowed 64)
Source: System.Data.OracleClient
at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at Vodafone.Eirrm.DataAccess.OracleBaseObject.ExecuteNonQuery(String storedProcedure, OracleParameter[] parameters)
at Vodafone.Eirrm.DataAccess.ReadRequest.InitRequest(IEirrmRequest request)

2004-04-28 09:41:56,390 [2072] ERROR RequestManager -
Exception: Vodafone.Eirrm.Global.EirrmException
Message: EirrmException.OracleException 200: OracleException
Source: mscorlib

Server stack trace:
at Vodafone.Eirrm.DataAccess.ReadRequest.InitRequest(IEirrmRequest request)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Vodafone.Eirrm.DataAccess.IReadRequest.InitRequest(IEirrmRequest request)
at Vodafone.Eirrm.RequestManager.RequestManager.AddRequests(Collection requests)

Nested Exception

Exception: System.Data.OracleClient.OracleException
Message: ORA-00161: transaction branch length 72 is illegal (maximum allowed 64)
Source: System.Data.OracleClient
at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at Vodafone.Eirrm.DataAccess.OracleBaseObject.ExecuteNonQuery(String storedProcedure, OracleParameter[] parameters)
at Vodafone.Eirrm.DataAccess.ReadRequest.InitRequest(IEirrmRequest request)


2004-04-28 09:41:56,390 [2072] ERROR WebService - Add request failed: ID=0,IMEI=121212121212121,reason=1,type=Bar,source=4,currentStatus=Unknown,subscriberNumber=0871212121,unbarPassword=unbar
Exception: Vodafone.Eirrm.Global.EirrmException
Message: EirrmException.OracleException 200: OracleException
Source: mscorlib

Server stack trace:
at Vodafone.Eirrm.DataAccess.ReadRequest.InitRequest(IEirrmRequest request)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Vodafone.Eirrm.DataAccess.IReadRequest.InitRequest(IEirrmRequest request)
at Vodafone.Eirrm.RequestManager.RequestManager.AddRequests(Collection requests)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [1]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Vodafone.Eirrm.RequestManager.IRequestManager.AddRequests(Collection requests)
at Vodafone.Eirrm.WebService.WebService.AddRequest(String imei, String subscriberNumber, RequestType type, Int32 reason, String lastUsedDate, Int32 source, String handsetMake, String handsetModel, String unbarPassword, String inputFilename)

Nested Exception

Exception: System.Data.OracleClient.OracleException
Message: ORA-00161: transaction branch length 72 is illegal (maximum allowed 64)
Source: System.Data.OracleClient
at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at Vodafone.Eirrm.DataAccess.OracleBaseObject.ExecuteNonQuery(String storedProcedure, OracleParameter[] parameters)
at Vodafone.Eirrm.DataAccess.ReadRequest.InitRequest(IEirrmRequest request)