error inserting data using WCF-LOB sql binding

Asked By Raghu Donk
17-Nov-09 03:02 PM
Earn up to 10 extra points for answering this tough question.

Hi I am getting an error when trying to insert data using WCF-LOB sql binding on my Dev Server but when i am trying it from my local it is successful without any errors, I a pointing to the same DB from my local and Dev Server, Error is

xlang/s engine event log entry: Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'Module_1.Orchestration(f7440449-f961-7217-554f-eed5878838fb)'.

The service instance will remain suspended until administratively resumed or terminated.

If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception.

InstanceId: 69e2d2b6-4837-43ef-bf3f-d1866c7e87c0

Shape name:

ShapeId:

Exception thrown from: segment -1, progress -1

Inner exception: An error occurred while processing the message, refer to the details section for more information

Message ID: {EB5C58F6-7A10-4097-AAE1-9202C609A411}

Instance ID: {D9CA32EA-F8B7-4318-BA9B-327F071E8B8D}

Error Description: System.Transactions.TransactionException: The transaction has already been implicitly or explicitly committed or aborted. ---> System.Runtime.InteropServices.COMException (0x8004D00E): The transaction has already been implicitly or explicitly committed or aborted (Exception from HRESULT: 0x8004D00E)

at System.Transactions.Oletx.ITransactionShim.Export(UInt32 whereaboutsSize, Byte[] whereabouts, Int32& cookieIndex, UInt32& cookieSize, CoTaskMemHandle& cookieBuffer)

at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)

--- End of inner exception stack trace ---

Create New Account