Transaction processing strange behavior


Author
Message
Marcel Heitlager
Marcel Heitlager
StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)
Group: StrataFrame Users
Posts: 84, Visits: 835
Hi,

For some reason when I try to save data to two tables during a transaction save, sometimes the transaction only commits one of the tables. This is on a website. It happens when a person might put a payment through and the entire transaction fails, and rolls back for some reason.   Then the person will try it again within a couple of minutes, and the transaction only commits the data to the 2nd save.  See below:


        '-- first generate a unique transaction key
        Dim lcTransactionKey As String = AES.BOL.Base.Utils.NewSeqGuid().ToString

        Try
            TransactionBegin(Me.OPPaymentDetail.DataSourceKey, lcTransactionKey, IsolationLevel.ReadCommitted)
           
            '-- First save data to the contact information table - This save Fails
            Me.OPPaymentDetail.Save(True, lcTransactionKey)
           
            '-- next get the primary key value and save to ACH detail table - This save Succeeds
            Me.OPACHInfoBO.ah_op_Key = Me.OPPaymentDetail.GetPostSavePrimaryKeyValue(-1).ToString
            Me.OPACHInfoBO.Save(True, lcTransactionKey)


            TransactionCommit(Me.OPPaymentDetail.DataSourceKey, lcTransactionKey)
 
            Return True
        Catch ex As Exception

            TransactionRollback(Me.OPPaymentDetail.DataSourceKey, lcTransactionKey)

            Me.SendTransactionReportError()
            Return False
        End Try


It seems the 2nd transaction always commits, but the first doesn't. 
It's running on SQL Server Express 2005, Windows Server 2003.  Could it be some memory cache issue?

Thanks,

Marcel
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search