StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POTransactionScope and Error: ORA-02049
text
Body
copied!<p>I have the following routine:</p> <pre><code>For j = 1 To NumItems dbValueLookup.Load(j) Using scope As New TransactionScope() For i = firstIndex To lastIndex 'dbValueLookup is basically just a Dictionary of items already in the DB If dbValueLookup.ContainsKey(i) Then 'updateData is a subroutine that updates this row with new data updateData(j,i) rowsUpdated = rowsUpdated + 1 dbValueLookup.Remove(i) Else 'updateData is a subroutine that adds a new row to DB addData(j,i) rowsAdded = rowsAdded + 1 End If Next If dbValueLookup.Count = 0 Then 'This commits the transaction - records will be updated when End Using is reached scope.Complete() If rowsAdded + rowsUpdated > 0 Then ShowMessage("Records Updated: " + rowsUpdated.ToString() + " Records Added: " + rowsAdded.ToString()) End If Else 'We are left with data from the database that was not updated. This is a problem, so we don't "Complete" the scope. 'This will result in a rollback. ShowWarningMessage("Incomplete Data for " + i.ToString()) End If End Using Next </code></pre> <p>Running this against both our production and test Oracle 11g database sporadically (or if there is a pattern, I haven't found it yet) generates the Oracle Error: ORA-02049: timeout: distributed transaction waiting for lock</p> <p>Since this is the only process running against the test database, there shouldn't be any issue with different users competing for a lock.</p> <p>Any ideas what might be causing this error?</p> <p>Thanks in advance.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload