Hi,

I deploy to customer my application. On my developer machine all works fine.. and as always on customer side all goes wrong

The code is simple as on example

      Try

            BusinessLayer.TransactionBegin("PENSOLUTIONOFFICE", lcTransactionKey, Data.IsolationLevel.ReadCommitted)

            mmks_updatePSOForm(loPSOFormStoreBO)



            lSaveResult = loPSOFormStoreBO.Save(True, lcTransactionKey)

            If lSaveResult = MicroFour.StrataFrame.Data.SaveUndoResult.Success Then

                BusinessLayer.TransactionCommit("PENSOLUTIONOFFICE", lcTransactionKey)

                lcErrorMessage = "SUCCESS"

            Else

                Throw New Exception("An error happen during save data!")

            End If

        Catch ex As Exception

            lcErrorMessage = ex.Message

            BusinessLayer.TransactionRollback("PENSOLUTIONOFFICE", lcTransactionKey)

        End Try

On customer machine BusinessLayer.TransactionCommit call an exception (free translation from german) Transaction is finised and can't be used anymore.. something like that...

The question is WHEN transaction is finished? and why on my developer machine all works fine and there an exception happens.

Everywhere installed SQL Server 2008.

Any ideas

Thanks

Denis

Now I get closer to my problem..



Please look...

[code]

Try

BusinessLayer.TransactionBegin("PENSOLUTIONOFFICE", lcTransactionKey, Data.IsolationLevel.ReadCommitted)

''' ************************************************************************************

''' HERE I UPDATE BUSINESS OBJECT PROPERTIES mmks_updatePSOForm(loPSOFormStoreBO)

''' IF I UPDATE ONE or ANY PROPERTIES OF BO - then SAVE() works perfect but TransactionCommit - FAIL

'' IF I DO NOT UPDATE ANY PROPERTIES OF BO - then TransactionCommit SUCCESS!!!!!

''' *************************************************************************************

MicroFour.StrataFrame.Data.DataBasics.DataSources("PENSOLUTIONOFFICE").SetDebugOn("c:\DebugFile.html", True)

lSaveResult = loPSOFormStoreBO.Save(True, lcTransactionKey)

If lSaveResult = MicroFour.StrataFrame.Data.SaveUndoResult.Success Then

BusinessLayer.TransactionCommit("PENSOLUTIONOFFICE", lcTransactionKey)

lcErrorMessage = "SUCCESS"

Else

Throw New Exception("An error happen during save data!")

End If

Catch ex As Exception

lcErrorMessage = ex.Message

BusinessLayer.TransactionRollback("PENSOLUTIONOFFICE", lcTransactionKey)

End Try

[code]



The diffrence between developer machine and customer machine where I currently debug it with Visual Studio..



on development machine I have included PenSolutionOfficeBO as Project.. but

on customer machine - its only DLL which located in BIN folder.



So.. any ideas now?



Thanks!