Icon View Incident Report

Serious Serious
Reported By: Shane Sturgeon
Reported On: 6/22/2013
For: Version 2.13 Build 2
# 3870 Cannot Alter Triggers that Contain Errors

I have occasionally made an error in a configuraton change (Trigger alterations usually) which will usually result in a UE in EDB manager, and then the entire database is basically dead. Even after a machine restart I can't open tables, reverse engineer the DB, drop anything etc.

EDB Manager will still work on other databases (even under the same session), but try to select any object in the database and I get an EDB Error #700. The message tells me where the problem is (in this particular case it is in an After Delete trigger). I had a call to a procedure that took as a parameter an "OLDROW" value, but once I realised that was problematic, I changed both the procedure (so that it didn't require the parameter) and the trigger so it didn't pass it. However the error message seems to think the trigger is trying to call the procedure with the parameter and is saying that there is an invalid number of parameters specified.

In the past, I have managed to fix this problem by simply reinstating the parameter in the procedure so everything is "in sync" and then reversing out the changes in a different order, but this time EDB won't allow me to edit the procedure (when I try I get the #700 error with the trigger message).

Comments Comments
This is not entirely a bug - the #700 when clicking on various objects in the EDB Manager is just the automated dependency viewing in the EDB Manager. Go into File/Preferences/Explorer and un-check the Load/Show Object
Dependencies check box, and that will fix the constant syntax/compilation errors in the EDB Manager caused by the dependency loading/checking.

The bug part is that the trigger cannot be altered without causing the syntax error.

Resolution Resolution
Fixed Problem on 6/24/2013 in version 2.13 build 3

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