Icon View Incident Report

Serious Serious
Reported By: Richard Harding
Reported On: 9/18/2008
For: Version 2.01 Build 5
# 2800 A Write Error During the Final Portion of an Alter Table Can Cause Version Mismatch Errors for Table

I have a script that:
* increases the size of a column in 1 table
* adds 2 column to another table
* adds a column to another table.

Distributed the script to 4 remote customers. Used EDB manager to execute the script. Worked fine for 3 sites. The 4th site was more interesting.

* The window appeared with messages the alteration of the 3 tables started and ended.
* An error occurred writing to a temporary file - not sure what the error was.
* The first 2 tables had the alterations applied
* Retried to do the ALTER on the third table and received a Version Mismatch error on the table.
* Any action on this table resulted in the Version Mismatch error.

Recovered by creating a new database, restoring from the backup and executing the 3 ALTER statements (one at a time).

Resolution Resolution
Fixed Problem on 9/19/2008 in version 2.02 build 1

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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial