Devart Forums

Posted: **Sat 19 Dec 2015 20:08**

Hi,

I am getting this Error from a remote SQL-Server 2012 CU2 test.
I added code to write the Monitor data to file and got this, there is only one connection.
The only thread that ran, using the same connection string, logged disconnect so I have no idea how this would come about.

Any hints appreciated:

Code: Select all

uniConnection.Transaction=Start:
... Many inserts

uniConnection.tbFetchLog=INSERT INTO FETCHLOG    (DOMAINID, MESSAGE, ALERTLEVEL, EVENTTIME)  VALUES    (?, ?, ?, ?)  
SET ? = SCOPE_IDENTITY()  SELECT ? = DOMAINID, ? = MESSAGE, ? = ALERTLEVEL, ? = SERVER, ? = EVENTTIME FROM FETCHLOG  WHERE   
  ID = SCOPE_IDENTITY()    
  :DOMAINID(LargeInt,IN)=2   
  :MESSAGE(WideString[35],IN)='5 Folder(s) added, 1 File(s) processed '   
  :ALERTLEVEL(Integer,IN)=0   
  :EVENTTIME(DateTime,IN)=18.12.2015 12:51:48   
  :ID(LargeInt,IN/OUT)=<NULL>   
  :DOMAINID(LargeInt,IN/OUT)=2   
  :MESSAGE(WideString[35],IN/OUT)='5 Folder(s) added, 1 File(s) processed '   
  :ALERTLEVEL(Integer,IN/OUT)=0   
  :SERVER(WideString[0],IN/OUT)=<NULL>   
  :EVENTTIME(DateTime,IN/OUT)=18.12.2015 12:51:48
  
uniConnection.tbServers=SELECT * FROM Servers  WHERE DOMAINID=2 AND isDC=0

uniConnection.Transaction=Commit:
uniConnection.Transaction=Start:

uniConnection.tbFetchLog=INSERT INTO FETCHLOG    (DOMAINID, MESSAGE, ALERTLEVEL, EVENTTIME)  VALUES    (?, ?, ?, ?)  
SET ? = SCOPE_IDENTITY()  SELECT ? = DOMAINID, ? = MESSAGE, ? = ALERTLEVEL, ? = SERVER, ? = EVENTTIME FROM FETCHLOG  WHERE  
  ID = SCOPE_IDENTITY()    
  :DOMAINID(LargeInt,IN)=2   
  :MESSAGE(WideString[30],IN)='Attempting connection to: EVA '   
  :ALERTLEVEL(Integer,IN)=0   
  :EVENTTIME(DateTime,IN)=18.12.2015 12:51:49   
  :ID(LargeInt,IN/OUT)=<NULL>   
  :DOMAINID(LargeInt,IN/OUT)=2   
  :MESSAGE(WideString[30],IN/OUT)='Attempting connection to: EVA '   
  :ALERTLEVEL(Integer,IN/OUT)=0   
  :SERVER(WideString[0],IN/OUT)=<NULL>   
  :EVENTTIME(DateTime,IN/OUT)=18.12.2015 12:51:49
=Error: Cannot create new connection because in manual or distributed transaction mode.

Posted: **Thu 24 Dec 2015 10:01**

We can't reproduce the described behavior. Please try to compose a small sample reproducing the issue and send it to andreyz*devart*com, including scripts for generating the test tables.

Devart Forums

Cannot create new connection because in manual or distributed transaction mode

Cannot create new connection because in manual or distributed transaction mode

Re: Cannot create new connection because in manual or distributed transaction mode