Distributed transaction already begun "ORA 02046 " when I use Link

Question

I have a very big problem for me appears with a few steps when I use devart to connect to Oracle.

• Select on the following view in Oracle Code:

  create or replace view Test_View as 
  select "ID","USR" 
  from Test_Table@link_DB; `
  

• Using LINQ CONNECT MODAL

That's all, When I open the page the following exception will be shown (from the first time or after a postBack)

distributed transaction already begun "ORA 02046 "

Any help!

Answer 1

There is a problem with distributed transactions state on your Oracle database servers.

Try to rollback "in-doubt" distributed transaction as described here.

Step-by-step-guide located here.