Transaction Error ( urgent )

[akshya]

Dear friends ,i am facing a criticalerror,pls help me out :-

My MTS component(developed using ATL and using ADO to access SQL Server) running on Win 2k behaving well normally without any error,but sometimes it abort when firing a SQL query before deafult transaction time out period ( 60 sec) and produce following error in event log file:-

"New transaction cannot enlist in the specified transaction coordinator" .
This error is occuring rarely.Pls tell what can be its reason and how to fix it .

regards
akshay

Other entries in event log file is as:-

(3016,2828)2003/09/16 15:46:00.638 H:0337 W:10158080 P:4603904 ERROR: COM
Exception in setConnection() [DbKernel.cpp(75)]
ADO ERROR @: File name=C:\ProgramFiles\......mercury_wms.udl
ADO ERROR 1: 0x8004d00a
Source : Microsoft OLE DB Provider for SQL Server
Description: New transaction cannot enlist in the specified transaction coordinator.
SqlState : (null)
NativeError: 0x0
HelpFile : (null)
HelpContext: 0
ERROR: COM Exception in executeQuery() [DbKernel.cpp(171)]
ADO ERROR 1: 0x8004d00a
Source : Microsoft OLE DB Provider for SQL Server
Description: New transaction cannot enlist in the specified transaction coordinator.
SqlState : (null)
NativeError: 0x0 HelpFile : (null)
HelpContext: 0
ERROR: Error SQL : set transaction isolation level read committed;
INSERT INTO MRC_STOCK_DATA (STOCK_ITEM_GUID, WAREHOUSE_GUID,ITEM_ID,
UNIT_ID,TOTAL_RECEIVED,TOTAL_REJECTED, TOTAL_PICK_RESERVE,TOTAL_PICKED,
TOTAL_ADJUSTED,TOTAL_RETURNED,TOTAL_DISPOSED_OFF,TOTAL_PACKED,
TOTAL_SHIPPED,ON_HAND, ON_HOLD,TOTAL_EXCESS,ON_ORDER,ON_RESERVE,
CREATED_BY, LAST_MODIFIED_BY) Select newid(),WAREHOUSE_GUID,
'{B3CE6383-EE8A-4131-8F85-6C8EB4C994B3}','{6AA23C56-7A4F-11D2-84B0-0000F80
627E2}',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'eStore_User','eStore_User' From
Mrc_Warehouse [DbKernel.cpp(173)]
(3016,2828)2003/09/16 15:46:00.654 H:0337 W:10162176 P:4608000 ERROR: ADO
Error!- Catch Block [DalKernel.cpp(150)]
COM ERROR : 0x8004d00a
Meaning : IDispatch error #52746
Source : (null)
Description: (null)
ERROR: Generated BS error code: 0x3004009a, returned error code:0x800460ff [DalKernel.cpp(156)]

 

[EddieCatflap]

Hi akshya,

I've encountered MTS related runtime errors before and the source of the problem was my SQL statements. The VC++ compiler does not detect them and you only discover that they are faulty at runtime.
Just to rule out any SQL errors you should open up your .udl file in MS Word. This will give you the SQL statement for your connection. Then copy and paste this statement into the SQL query analyser and execute it. This will then inform you of whether your SQL statement contains errors or not. I suggest this also because the top of your event log shows an ADO error with mercury_wms.udl.

HTH, Andy.

 

[akshya]

Hi Andy,
thanx for ur reply.I will update u after checking it out.

thanks again
akshya