We updated our development Oracle database to Oracle 9.2.0.6 with the security patch this morning. When I run my ASP WEb app I now get the followinf error:
Server Error in '/gts' Application.
--------------------------------------------------------------------------------
ORA-02046: distributed transaction already begun ORA-02063: preceding line from RTS_ODS
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: CoreLab.Oracle.OracleException: ORA-02046: distributed transaction already begun ORA-02063: preceding line from RTS_ODS
Source Error:
[No relevant source lines]
Source File: c:\inetpub\wwwroot\GTS_WEB\MyProfile.aspx.vb Line: 61
Stack Trace:
[OracleException: ORA-02046: distributed transaction already begun
ORA-02063: preceding line from RTS_ODS
]
CoreLab.Oracle.OracleCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3) +767
CoreLab.Common.DbCommandBase.b(CommandBehavior A_0) +113
CoreLab.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +4
CoreLab.Oracle.OracleCommand.ExecuteReader() +7
GTS_WEB.CommonVB.Get_Work_Phone() in c:\inetpub\wwwroot\GTS_WEB\CommonVB.vb:221
GTS_WEB.MyProfile.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\GTS_WEB\MyProfile.aspx.vb:61
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
Any Ideas as to why this is happening?
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Problem with Oracle 9.2.0.6 with security patch
We did not encountered with this problem before. OraDirect .NET does not use distributed transaction. Possibly it is a problem of Oracle server (see error description in Oracle documentation). Try to modify you query.
ORA-02046 distributed transaction already begun
Cause: This is an internal error not normally encountered. A server session received a BEGIN_TRAN remote procedure call before finishing with a previous distributed transaction.
Action: Contact Oracle Customer Support.