Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 5/16/2011
For: Version 2.05 Build 7
# 3449 Trying to Alter a Table That is Opened Via a Foreign Key from Another Table Can Cause Locking Errors

I have a test database with 2 tables, table1 and table2. Table2 has a foreign key reference back to table 1. If you open table1 for editing and then attempt to alter table2, you get a 300 error indicating that you can’t get exclusive to table2. That’s fine and expected since table2 would be opened due to the FK reference. But once that error occurs, even if I close table1 and try the alter again with no tables open, table2 still can’t be opened in exclusive mode until the session is closed and opened again. So it looks like something isn’t being cleaned up properly after the failed alter attempt.


Resolution Resolution
Fixed Problem on 5/18/2011 in version 2.05 build 8


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image