November 24, 2009 at 10:00 am
Trying to add transactions to my EDI process by wrapping loading an entire file of data into SQL Server database tables with transactions. So if the transaction fails it rolls back all the inserts for that file.
When I have a large file that takes more than 900 inserts with multiple child records. It fails the transaction after about 300 records with
gq59zk1.Console.ERROR
----------- SQL ERROR --------------
SET NOCOUNT ON ;INSERT INTO NY_Incoming_867_Metered_Consumption_Summary_Line_MEA
(
PeriodType,
Consumption,
Quantity,
UOM,
PeakType,
NY_Incoming_867_Metered_Consumption_Summary_Line_ID,
CreateDate,
CreateUser
)
VALUES
(
'AN',
'PRQ',
'0',
'K1',
'51',
7934157,
'11/24/2009 10:13:46 AM' ,
'MappingEngine'
)
; SELECT SCOPE_IDENTITY() AS PID; SET NOCOUNT OFF
----------- SQL ERROR --------------
System.Runtime.InteropServices.COMException (0x8004D00A): New transaction cannot
enlist in the specified transaction coordinator.
at System.Data.Common.NativeMethods.ITransactionJoin.JoinTransaction(Object p
unkTransactionCoord, Int32 isoLevel, Int32 isoFlags, IntPtr pOtherOptions)
at System.Data.OleDb.OleDbConnectionInternal.EnlistTransactionInternal(Transa
ction transaction, Boolean forcedAutomatic)
at System.Data.OleDb.OleDbConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, Conne
ctionState& originalState)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[]
datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand co
mmand, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at OpenEnergy.CDatabase.GetDS(String sSQL, String sName) in C:\Sandbox\SparkA
ll\OpenEnergy\CDatabase.vb:line 689
At the time this error occurs on my machine:
SQLServer machine gets hunderd of the follwing event:
The creator is SQLServer and the message is:
Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8007000e(Not enough storage is available to complete this operation.).
November 26, 2009 at 1:45 pm
Is this SQL 2005 on Windows 2003?
Have you check the security Setting in the "Component Services" console?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply