Transaction Key Already Started Error


Author
Message
choyt
choyt
StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)StrataFrame Novice (98 reputation)
Group: Forum Members
Posts: 78, Visits: 246
Hi All

I am occasionally getting tis error directly after running a transaction that failed. I have verified that the rollback occured both by walking through the code and looking at the table afterward.

The only way I have found to fix this is to stop my services and restart them. Is there a more graceful way to do this? It seems to only happen when I'm using a Transaction Key. I considered creating a random transaction key but am concerned about not releasing resources.

Thanks!

Clay

System.ArgumentException was caught
  Message="A transaction with the key [StopItin] is already started."
  Source="MicroFour StrataFrame Base"
  StackTrace:
       at MicroFour.StrataFrame.Data.DbDataSourceItem.TransactionBegin(String TransactionKey, IsolationLevel Level)
       at MicroFour.StrataFrame.Data.DataLayer.TransactionBegin(String DataSourceKey, String TransactionKey, IsolationLevel IsoLevel)
       at MicroFour.StrataFrame.Business.BusinessLayer.TransactionBegin(String DataSourceKey, String TransactionKey, IsolationLevel IsoLevel)
       at PIPS.BO.TravelVoucher.ItineraryStopInfo.DoInsert(Int64 PCSDataPackageTravelVoucherID, Type ReasonForStopID, String StopLocation, Type TravelModeID, DateTime ArrivalDateThisLocation, DateTime DepartureDateThisLocation, String CurrentUser, Int32 StopNumber, StopBeforeAfter StopBeforeAfter, Decimal LodgingCost, Decimal TransportationCost, Type PrivatelyOwnedConveyanceTypeID, DateTime RAPStartDate, DateTime RAPEndDate, DateTime PortCallDate, DateTime SignInDate) in E:\SDI\PIPSDevelopment\PIPSBO\DataManipulationClasses\TravelVoucher\ItineraryStopInfo.vb:line 63

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
choyt - 17 Years Ago
choyt - 17 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search