Icon View Incident Report

Serious Serious
Reported By: Adam Brett
Reported On: 5/10/2014
For: Version 2.16 Build 2
# 4047 Computed Columns Not Being Handled Properly When Loading Replication Updates

I am having some pretty basic problems with an Elevate DB database, replication process.

I have a database, installed on 3 machines. An Office server (serving about 5 machines) and 2 field laptops. It is expected that the system will scale up to about 6 field laptops in time.

I am getting error messages when I try to load updates:

"Error #1305 The column does not exist in the table OnFarmProcessing Error #401"

Note that there is a space entered where I would expect a column name, so the update file must be holding a blank value.


Comments Comments
The issue was due to a change in 2.15 and higher to fix the problem reported in incident report #3955. The change was to allow computed columns to save their values to output streams. However, computed columns still completely ignored any incoming values in input streams, and this created an asymmetrical situation where computed columns would be saved in replication streams stored in update files, but any attempt to load such update files would fail because the computed columns were not properly advancing the stream position past the incoming computed column values.

If you encounter this issue, then please make sure to update all involved ElevateDB installations to 2.17 or higher, and then re-attempt the loading of the updates.


Resolution Resolution
Fixed Problem on 5/12/2014 in version 2.17 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 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