Transaction Commit problem


Author
Message
dgsoft
dgsoft
StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)StrataFrame User (139 reputation)
Group: StrataFrame Users
Posts: 93, Visits: 236
Hi,

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

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? Smile and why on my developer machine all works fine and there an exception happens.

Everywhere installed SQL Server 2008.

Any ideas

Thanks

Denis
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
dgsoft - 15 Years Ago
Edhy Rijo - 15 Years Ago
dgsoft - 15 Years Ago
dgsoft - 15 Years Ago
Edhy Rijo - 15 Years Ago
                         Also before the save, use code like this one to debug the data that is...
Edhy Rijo - 15 Years Ago
                             Thanks for response
yes.. database is a same.. I copy MDF file...
dgsoft - 15 Years Ago
                                 What is this function doing: mmks_updatePSOForm(loPSOFormStoreBO)
Edhy Rijo - 15 Years Ago
                                     Its just to set values for BO properties

Private Sub...
dgsoft - 15 Years Ago
                                     This is complete method code

In my case llNewUser = .F. and...
dgsoft - 15 Years Ago
                                         Sorry.. I copy wrong code :))))

[code]

_...
dgsoft - 15 Years Ago
                                             I really don't see anything wrong, so at this point is just to try and...
Edhy Rijo - 15 Years Ago
                                                 Please look my last comment.. I thinking I localize the problem untill...
dgsoft - 15 Years Ago
                                                     Good, so the problem is here:
[codesnippet]
Private Sub...
Edhy Rijo - 15 Years Ago
                                                         Yes.
Even if I leave only one line for update
toBO.filename...
dgsoft - 15 Years Ago
                                                         This quote is from the "Using Transactional Processing" topic in the...
Edhy Rijo - 15 Years Ago
                                                             I made so
mmks_updatePSOForm(loPSOFormStoreBO)
...
dgsoft - 15 Years Ago
                                                             This is error message details..
Transaction still does not work....
dgsoft - 15 Years Ago
                                                                 Just idea
Maybe the code close the connection without completing...
dgsoft - 15 Years Ago
                                                                     And the last idea what I have...
When I made BO.SAVE() - because...
dgsoft - 15 Years Ago
                                                                         OK, let's back up several steps and talk a little logic and maybe we...
Trent L. Taylor - 15 Years Ago
                                                                             Hi Trent,
Thanks for response.
1) I shutdown developer SQL...
dgsoft - 15 Years Ago
                                                                                 Well, you might be chasing your tail (I have been known to do that...
Trent L. Taylor - 15 Years Ago
                                                                                     Hi,
All good what you say but then I need a StrataFrame license...
dgsoft - 15 Years Ago
                                                                                         [quote][b]dgsoft (07/23/2009)[/b][hr]Hi,
All good what you say...
Edhy Rijo - 15 Years Ago
                                                                                             [quote][b]Edhy Rijo (07/23/2009)[/b][hr][quote][b]dgsoft...
Edhy Rijo - 15 Years Ago
                                                                                                 What Edhy mentioned is exactly what I was getting at. There is no...
Trent L. Taylor - 15 Years Ago
                                     Now I get closer to my problem..

Please look...
[code]...
dgsoft - 15 Years Ago
                                 Also.. one comment.. If I remove transaction.. code does not call any...
dgsoft - 15 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search